protected void gridFleteros_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Logger variables System.Diagnostics.StackTrace stackTrace = new System.Diagnostics.StackTrace(true); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name; string methodName = stackFrame.GetMethod().Name; int fletero_ID = Convert.ToInt32(gridFleteros.DataKeys[e.RowIndex].Value); using (bonisoftEntities context = new bonisoftEntities()) { fletero obj = context.fleteros.First(x => x.Fletero_ID == fletero_ID); context.fleteros.Remove(obj); context.SaveChanges(); #region Guardar log try { string userID1 = HttpContext.Current.Session["UserID"].ToString(); string username = HttpContext.Current.Session["UserName"].ToString(); Global_Objects.Logs.AddUserLog("Borra fletero", obj.GetType().Name + ": " + obj.Fletero_ID, userID1, username); } catch (Exception ex) { Global_Objects.Logs.AddErrorLog("Excepcion. Guardando log. ERROR:", className, methodName, ex.Message); } #endregion BindGrid(); lblMessage.Text = "Borrado correctamente."; } }
protected void gridFleteros_RowUpdating(object sender, GridViewUpdateEventArgs e) { // Logger variables System.Diagnostics.StackTrace stackTrace = new System.Diagnostics.StackTrace(true); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name; string methodName = stackFrame.GetMethod().Name; GridViewRow row = gridFleteros.Rows[e.RowIndex]; TextBox txb1 = row.FindControl("txb1") as TextBox; TextBox txb2 = row.FindControl("txb2") as TextBox; TextBox txb3 = row.FindControl("txb3") as TextBox; TextBox txb4 = row.FindControl("txb4") as TextBox; TextBox txb5 = row.FindControl("txb5") as TextBox; TextBox txb23 = row.FindControl("txb23") as TextBox; TextBox txb24 = row.FindControl("txb24") as TextBox; if (txb1 != null && txb2 != null && txb3 != null && txb4 != null && txb5 != null && txb23 != null && txb24 != null) { using (bonisoftEntities context = new bonisoftEntities()) { int fletero_ID = Convert.ToInt32(gridFleteros.DataKeys[e.RowIndex].Value); fletero obj = context.fleteros.First(x => x.Fletero_ID == fletero_ID); obj.Nombre = txb1.Text; obj.Comentarios = txb2.Text; obj.Direccion = txb3.Text; obj.Telefono = txb4.Text; obj.Email = txb23.Text; obj.Nro_cuenta = txb24.Text; obj.Depto_empresa = txb5.Text; context.SaveChanges(); #region Guardar log try { string userID1 = HttpContext.Current.Session["UserID"].ToString(); string username = HttpContext.Current.Session["UserName"].ToString(); Global_Objects.Logs.AddUserLog("Modifica fletero", obj.GetType().Name + ": " + obj.Fletero_ID, userID1, username); } catch (Exception ex) { Global_Objects.Logs.AddErrorLog("Excepcion. Guardando log. ERROR:", className, methodName, ex.Message); } #endregion lblMessage.Text = "Guardado correctamente."; gridFleteros.EditIndex = -1; BindGrid(); } } }
protected void gridFleteros_RowCommand(object sender, GridViewCommandEventArgs e) { // Logger variables System.Diagnostics.StackTrace stackTrace = new System.Diagnostics.StackTrace(true); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); string className = System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name; string methodName = stackFrame.GetMethod().Name; if (e.CommandName == "InsertNew") { GridViewRow row = gridFleteros.FooterRow; TextBox txb1 = row.FindControl("txbNew1") as TextBox; TextBox txb2 = row.FindControl("txbNew2") as TextBox; TextBox txb3 = row.FindControl("txbNew3") as TextBox; TextBox txb4 = row.FindControl("txbNew4") as TextBox; TextBox txb5 = row.FindControl("txbNew5") as TextBox; TextBox txb23 = row.FindControl("txbNew23") as TextBox; TextBox txb24 = row.FindControl("txbNew24") as TextBox; if (txb1 != null && txb2 != null && txb3 != null && txb4 != null && txb5 != null && txb23 != null && txb24 != null) { using (bonisoftEntities context = new bonisoftEntities()) { fletero obj = new fletero(); obj.Nombre = txb1.Text; obj.Comentarios = txb2.Text; obj.Direccion = txb3.Text; obj.Telefono = txb4.Text; obj.Email = txb23.Text; obj.Nro_cuenta = txb24.Text; obj.Depto_empresa = txb5.Text; context.fleteros.Add(obj); context.SaveChanges(); #region Guardar log try { int id = 1; fletero fletero = (fletero)context.fleteros.OrderByDescending(p => p.Fletero_ID).FirstOrDefault(); if (fletero != null) { id = fletero.Fletero_ID; } string userID1 = HttpContext.Current.Session["UserID"].ToString(); string username = HttpContext.Current.Session["UserName"].ToString(); Global_Objects.Logs.AddUserLog("Agrega fletero", fletero.GetType().Name + ": " + id, userID1, username); } catch (Exception ex) { Global_Objects.Logs.AddErrorLog("Excepcion. Guardando log. ERROR:", className, methodName, ex.Message); } #endregion lblMessage.Text = "Agregado correctamente."; BindGrid(); } } } else { //BindGrid(); } }