protected void GrdDatos_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
PerfilesGrid();
Cnx.SelecBD();
using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
{
sqlCon.Open();
using (SqlTransaction Transac = sqlCon.BeginTransaction())
{
string VBQuery = "EXEC SP_TablasIngenieria 15,'',@ID,@US,'','','','','Encabezado','DELETE',0,0,0,0,0,0,'01-01-1','02-01-1','03-01-1'";
using (SqlCommand SC = new SqlCommand(VBQuery, sqlCon, Transac))
{
SC.Parameters.AddWithValue("@US", Session["C77U"].ToString());
SC.Parameters.AddWithValue("@ID", GrdDatos.DataKeys[e.RowIndex].Value.ToString());
try
{
var Mensj = SC.ExecuteScalar();
if (!Mensj.ToString().Trim().Equals(""))
{
DataRow[] Result = Idioma.Select("Objeto= '" + Mensj.ToString().Trim() + "'");
foreach (DataRow row in Result)
{
Mensj = row["Texto"].ToString().Trim();
}
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + Mensj + "');", true);
Transac.Rollback();
return;
}
Transac.Commit();
BindDataEnc(TxtBusqueda.Text);
GrdContdr.DataSource = null;
GrdContdr.DataBind();
}
catch (Exception ex)
{
Transac.Rollback();
DataRow[] Result = Idioma.Select("Objeto= 'MensErrEli'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //Error en el ingreso')", true);
Cnx.UpdateErrorV2(Session["C77U"].ToString(), ViewState["PFileName"].ToString().Trim(), "DELETE", ex.StackTrace.Substring(ex.StackTrace.Length - 300, 300), ex.Message, Session["77Version"].ToString(), Session["77Act"].ToString());
}
}
}
}
}
//****************************** Contadores Asignados
protected void BindDataContdr(string VbPatronM)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
DataTable dtbl = new DataTable();
string VbTxtSql = "EXEC SP_TablasIngenieria 15,@C,'','','','','','','Detalle','SELECT',0,0,0,0,0,0,'01-01-1','02-01-1','03-01-1'";
Cnx.SelecBD();
using (SqlConnection SCnx = new SqlConnection(Cnx.GetConex()))
{
SCnx.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, SCnx))
{
SC.Parameters.AddWithValue("@C", VbPatronM);
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = SC;
SDA.Fill(dtbl);
}
}
if (dtbl.Rows.Count > 0)
{
GrdContdr.DataSource = dtbl;
GrdContdr.DataBind();
}
else
{
dtbl.Rows.Add(dtbl.NewRow());
GrdContdr.DataSource = dtbl;
GrdContdr.DataBind();
GrdContdr.Rows[0].Cells.Clear();
GrdContdr.Rows[0].Cells.Add(new TableCell());
GrdContdr.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count;
DataRow[] Result = Idioma.Select("Objeto= 'SinRegistros'");
foreach (DataRow row in Result)
{
GrdContdr.Rows[0].Cells[0].Text = row["Texto"].ToString();
}
GrdContdr.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
protected void GrdDatos_RowCommand(object sender, GridViewCommandEventArgs e)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
PerfilesGrid();
if (e.CommandName.Equals("AddNew"))
{
string VbDesc, VBQuery;
string VbCod = (GrdDatos.FooterRow.FindControl("TxtCodPatronPP") as TextBox).Text.Trim().ToUpper();
if (VbCod == String.Empty)
{
DataRow[] Result = Idioma.Select("Objeto= 'MstrMens09'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //Debe ingresar el código.
return;
}
VbDesc = (GrdDatos.FooterRow.FindControl("TxtDescPP") as TextBox).Text.Trim();
if (VbDesc == String.Empty)
{
DataRow[] Result = Idioma.Select("Objeto= 'MstrMens06'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //Debe ingresar una descripción')", true);
return;
}
Cnx.SelecBD();
using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
{
sqlCon.Open();
using (SqlTransaction Transac = sqlCon.BeginTransaction())
{
VBQuery = "EXEC SP_TablasIngenieria 15,@Desc,@Cd,@US,'','','','','Encabezado','INSERT',0,0,0,0,0,0,'01-01-1','02-01-1','03-01-1'";
using (SqlCommand SC = new SqlCommand(VBQuery, sqlCon, Transac))
{
SC.Parameters.AddWithValue("@Desc", VbDesc);
SC.Parameters.AddWithValue("@Cd", VbCod);
SC.Parameters.AddWithValue("@US", Session["C77U"].ToString());
try
{
var Mensj = SC.ExecuteScalar();
if (!Mensj.ToString().Trim().Equals(""))
{
DataRow[] Result = Idioma.Select("Objeto= '" + Mensj.ToString().Trim() + "'");
foreach (DataRow row in Result)
{
Mensj = row["Texto"].ToString().Trim();
}
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + Mensj + "');", true);
Transac.Rollback();
GrdContdr.DataSource = null;
GrdContdr.DataBind();
return;
}
Transac.Commit();
BindDataEnc(TxtBusqueda.Text);
GrdContdr.DataSource = null;
GrdContdr.DataBind();
}
catch (Exception ex)
{
Transac.Rollback();
DataRow[] Result = Idioma.Select("Objeto= 'MensErrIng'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //Error en el ingreso')", true);
Cnx.UpdateErrorV2(Session["C77U"].ToString(), ViewState["PFileName"].ToString().Trim(), "INSERT", ex.StackTrace.Substring(ex.StackTrace.Length - 300, 300), ex.Message, Session["77Version"].ToString(), Session["77Act"].ToString());
}
}
}
}
}
}
