protected void sdsProducto_Inserted(object sender, SqlDataSourceStatusEventArgs e)
    {
        decimal outputValue = (decimal)(e.Command.Parameters)[0].Value;
        String NombreProducto = Convert.ToString((e.Command.Parameters)[1].Value);

        Response.Redirect("./Mantenimientos/vAsociaProductos.aspx?ProductoId=" + outputValue + "&nombreProducto=" + NombreProducto);
    }

 protected void srcMessage_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows == 0)
     {
         Response.StatusCode = 404;
     }
 }

    protected void sdsAseguradoFRM_Inserted(object sender, SqlDataSourceStatusEventArgs e)
    {
        this.hdfAseguradoId.Value = e.Command.Parameters["@personaId"].Value.ToString();
        this.hdfAsegurado.Value = ((TextBox)this.FormView1.FindControl("PrimerNombreTextBox")).Text;

        this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "callParent", " xAddEventListener(window,'load',copyValues);", true);
    }

 protected void SqlDataSourceModifica_Deleted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Exception != null)
     {
         LabelErrorMessage.Text = "Impossibile eseguire la cancellazione probabilmente l'emento è in uso dalla tabella Strumenti.\n" + e.Exception.Message;
         e.ExceptionHandled = true;
     }
 }

 protected void ds_Enrollment_Updated(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows > 0)
         lbl_error.Text = "Save Successfully.";
     else
         lbl_error.Text = "Save fail.";
     lbl_error.Visible = true;
 }

    protected void dsSelectedCommunication_Updated(object sender, SqlDataSourceStatusEventArgs e)
    {
        //once updated, send user back to gridview
        mvCommunications.ActiveViewIndex = 0;

        //update the gridview
        gvCommunications.DataBind();
    }

 protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     if(e.Exception != null)
     {
         Label1.Text = "Data error";
         e.ExceptionHandled = true;
     }
 }

    protected void save_click(object sender, SqlDataSourceStatusEventArgs e)
    {
        a_step_2.Disabled = false;
        a_step_3.Disabled = false;
        (fv_contact.FindControl("tb_name") as TextBox).Enabled = false;
        ltrl_changes_submitted.Visible = true;

        Session["unfinishedContact"] = int.Parse(e.Command.Parameters["@contact_id"].Value.ToString());
    }

 protected void SDS_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows < 1)
         this.Visible = false;
     else
     {
         base.pg.ScriptOrCssFileImportHead("/scripts/jquery.raty-2.4.5/js/jquery.raty.min.js");
     }
 }

    protected void sdsEliminarAjuste_Updated(object sender, SqlDataSourceStatusEventArgs e)
    {
        this.lblMensaje.Text = "El Caso de Ajuste se encuentra ahora Eliminado, ya no podrá acceder a el...";
        /*this.pnlConfirmacion.Style.Remove(HtmlTextWriterStyle.BackgroundColor);
        this.pnlConfirmacion.Style.Add(HtmlTextWriterStyle.BackgroundColor, "RED");*/
        this.pnlConfirmacion.Visible = true;

        this.ClientScript.RegisterStartupScript(this.GetType(), "scriptInicial", "window.onload = function() { cierraLaVentana();}", true);
    }

    protected void SqlDataSource2_Updated(object sender, SqlDataSourceStatusEventArgs e)
    {
        // check e to see if an exception has happened
        if(e.Exception != null) {
            Label12.Text = "An error occured when performing the query";

            e.ExceptionHandled = true;
        }
    }

 protected void SDS_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     //eğer kayıt var ise css dosyasını import et
     if (e.AffectedRows < 1)
         this.Visible = false;
     else
     {
         pg.ScriptOrCssFileImportHead("//cdn.jsdelivr.net/jquery.marquee/1.3.1/jquery.marquee.min.js");
     }
 }

 protected void Comment_Selected(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows <= 0)
     {
         NoComment.Visible = true;
     }
     else
     {
         NoComment.Visible = false;
     }
 }

 protected void CheckLogin(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.AffectedRows > 0)
     {
         FormsAuthentication.RedirectFromLoginPage(Login.UserName, false);
     }
     else
     {
         Login.FailureText = "Wrong user name or password!";
     }
 }

    protected void pInsert(object sender, SqlDataSourceStatusEventArgs e)
    {
        if (e.Exception == null)
        {
            mensagemErro.Text = String.Format("<br> Product '{0}' successfully added. <br><br>", e.Command.Parameters["@id_product"].Value);
            ProductsMultiView.ActiveViewIndex = 0;
            LinkProductsManage.CssClass = "selectedview";
            LinkProductsCreate.CssClass = "";

            string id_product_for_image = String.Format("{0}", e.Command.Parameters["@id_product"].Value);

            // verifica o tipo de ficheiro
            // neste exemplo, apenas vamos permitir upload ficheiros do tipo JPG
            if (imageUpload.PostedFile.ContentType == "image/jpg" || imageUpload.PostedFile.ContentType == "image/jpeg" || imageUpload.PostedFile.ContentType == "image/pjpeg")
            {
                // verifica o tamanho do ficheiro
                // neste exemplo, o tamanho do ficheiro tem que ser superior a ZERO e inferior a 512 Kb
                if (imageUpload.PostedFile.ContentLength > 0 && imageUpload.PostedFile.ContentLength < (512 * 1024))
                {
                    try
                    {
                        //imageUpload.PostedFile.SaveAs(Server.MapPath("~/files/products/" + imageUpload.PostedFile.FileName));
                        imageUpload.PostedFile.SaveAs(Server.MapPath("~/files/products/" + id_product_for_image + ".JPG"));
                        mensagemErro.Text += "Ficheiro guardado com sucesso no servidor!<br />";
                        mensagemErro.Text += "File name: " + imageUpload.PostedFile.FileName + "<br>" + imageUpload.PostedFile.ContentLength + " kb<br>" + "Content type: " + imageUpload.PostedFile.ContentType;
                        mensagemErro.CssClass = "ok";
                    }
                    catch (Exception ex)
                    {
                        mensagemErro.Text += "Ocorreu um erro ao tentar guardar no servidor";
                        mensagemErro.Text += "<br />" + ex.Message.ToString();
                        mensagemErro.CssClass = "error";
                    }

                }
                else
                {
                    mensagemErro.Text += "Ficheiro inválido: o tamanho não pode exceder os 512 kB";
                    mensagemErro.CssClass = "error";
                }
            }
            else
            {
                mensagemErro.Text += "Ficheiro inválido/Sem Ficheiro: escolha uma imagem JPG";
                mensagemErro.CssClass = "error";
            }
        }
        else
        {
            mensagemErro.Text = "Unable to add Product. Please try again.";
            e.ExceptionHandled = true;
        }
        mensagemErro.Text += "<br>";
    }

	protected void sourceEmployees_Selected(object sender, SqlDataSourceStatusEventArgs e)
	{
		if (e.Exception != null)
		{
			// Mask the error with a generic message (for security purposes.)
			lblError.Text = "An exception occured performing the query.";

			// Consider the error handled.
			e.ExceptionHandled = true;
		}
	}

 protected void SqlDataSource1_Updated(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Exception == null)
     {
         ShowMessage("Actualizado con éxito");
     }
     else
     {
         ShowMessage("Se ha producido un error al actualizar, la operación fue cancelada");
         e.ExceptionHandled = true;
     }
 }

 protected void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)
 {
     if (e.Exception != null && e.Exception is SqlException)
     {
       SqlException myException = (SqlException)e.Exception;
       if (myException.Number == 547)
       {
     ErrorMessage.Text = @"Sorry, you can't delete this genre because it has associated reviews that you need to delete first.";
     e.ExceptionHandled = true;
       }
     }
 }

    protected void dsCaseActivities_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        if (e.Exception != null)
        {
            //Show error message
            frmCaseDetails.Visible = false;
            lblError.Visible = true;
            lblError.Text = "The database is currently offline";

            //Set the exception handled property so it doesn't bubble-up
            e.ExceptionHandled = true;
        }
    }

    protected void SqlDataSource2_Updated(object sender, SqlDataSourceStatusEventArgs e)
    {
        if (e.Exception!=null)
        {
            lblResults.Text = "You broke it... why would you do that?";
            lblResults.Text += "<br><br><b> Message: </b> " + e.Exception.Message + "<br><br>";
            lblResults.Text += "<b> Source: </b> " + e.Exception.Source + "<br><br>";
            lblResults.Text += "<b> Stack Trace: </b> " + e.Exception.StackTrace;
            lblResults.ForeColor = System.Drawing.Color.Red;

            e.ExceptionHandled = true;
        }
    }