protected void gridRTMPlaning_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
var listUpdates = new List <RtmPlanningProjectDetails>();
foreach (var args in e.UpdateValues)
{
foreach (System.Collections.DictionaryEntry val in args.NewValues)
{
if (val.Key.ToString() != "Criteria" &&
val.Key.ToString() != "Score" &&
val.Key.ToString() != "SRCTitle" &&
val.Key.ToString() != "ChecklistType" &&
val.Value != null)
{
RtmPlanningProjectDetails checklist = new RtmPlanningProjectDetails();
checklist.CriteriaId = Convert.ToString(args.Keys["src_id"]);
checklist.ProjectName = val.Key.ToString();
checklist.IsActive = bool.Parse(val.Value.ToString());
listUpdates.Add(checklist);
}
}
}
if (listUpdates.Count > 0)
{
rtm_services.UpdateRTMPlanningDetails(listUpdates);
}
e.Handled = true;
}
protected void gvIndividualFee_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
e.Handled = true;
string fbatch = "";
string studFees = "";
for (int i = 0; i < e.UpdateValues.Count; i++)
{
//fbatch += "('" + int.Parse(e.UpdateValues[i].NewValues[2].ToString()) + "','" + cmbStudentBatch.GridView.GetRowValues(cmbStudentBatch.GridView.FocusedRowIndex, "ID").ToString() + "','" + double.Parse(e.UpdateValues[i].NewValues[0].ToString()) + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + cmbStudentBatch.GridView.GetRowValues(cmbStudentBatch.GridView.FocusedRowIndex, "Bgroup").ToString() + "'),";
List <object> studUserIds = gvStudents.GetSelectedFieldValues("UserId");
if (studUserIds.Count > 0)
{
foreach (object studUserId in studUserIds)
{
studFees += "('" + int.Parse(e.UpdateValues[i].NewValues[2].ToString()) + "','" + cmbStudentBatch.GridView.GetRowValues(cmbStudentBatch.GridView.FocusedRowIndex, "ID").ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + studUserId + "','" + cmbStudentBatch.GridView.GetRowValues(cmbStudentBatch.GridView.FocusedRowIndex, "Bgroup").ToString() + "','" + double.Parse(e.UpdateValues[i].NewValues[0].ToString()) + "'),";
}
}
}
//if (fbatch.Length != 0 && studFees.Length != 0)
if (studFees.Length != 0)
{
//new FeesBatchesService().AddFeesBatchesList(fbatch.TrimEnd(','), new SessionManager().GetUserId(Session));
new StudentFeesService().AddStudentFeesList(studFees.TrimEnd(','), new SessionManager().GetUserId(Session));
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.success('Saved Successfully','Message')", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.info('Oops something is not right! No data to save','Message')", true);
}
loadBatchFees();
uPanel.Update();
}
/// <summary>
/// Maneja los eventos de modificacion de la vista UiVistaMetaDetalle
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void UiVistaMetaDetalle_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
var diasDelPeriodo = int.Parse(UiDiasPeriodoMeta.Value?.ToString() ?? "0");
foreach (var actualizacion in e.UpdateValues)
{
var metaPorVendedor = decimal.Parse(actualizacion.NewValues["GOAL_BY_SELLER"].ToString());
var detalle = MetaDetalle.FirstOrDefault(md => md.CORRELATIVE == int.Parse(actualizacion.Keys["CORRELATIVE"].ToString()));
if (detalle == null)
{
continue;
}
detalle.GOAL_BY_SELLER = metaPorVendedor;
detalle.DAILY_GOAL_BY_SELLER = detalle.GOAL_BY_SELLER / diasDelPeriodo;
MetaDetalle[MetaDetalle.FindIndex(md => md.CORRELATIVE.Equals(detalle.CORRELATIVE))] = detalle;
}
e.Handled = true;
CalcularMontoTotalDeMetaDespuesDeActualizacionDeMetaPorVendedor(sender);
}
protected void gridProjectRoles_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
foreach (var item in e.UpdateValues)
{
//e.UpdateValues
}
//ProjectUserRoleList NewRoles = new ProjectUserRoleList();
//foreach (var item in e.UpdateValues)
//{
// NewRoles.Add(new ProjectUserRole
// {
// Id = Guid.Parse(item.Keys[0].ToString()),
// UserID = Guid.Parse(gridProjectRoles.GetRowValuesByKeyValue(item.Keys[0].ToString(), "UserID").ToString()),
// RoleID = Guid.Parse(item.NewValues[0].ToString()),
// ProjectID = Guid.Parse(ddlProjects.SelectedItem.Value.ToString())
// });
//}
//string result = rc_services.UpdateProjectUserRoles(NewRoles);
//if (result == "1")
//{
// e.Handled = true;
//}
////gridProjectRoles.CancelEdit();
//gridProjectRoles.DataSource = rc_services.GetProjectUserRoles(Guid.Parse(ddlProjects.SelectedItem.Value.ToString()));
//gridProjectRoles.DataBind();
}
protected void dgUMServicios_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
ASPxGridView dg = (ASPxGridView)sender;
try
{
using (var db = new UnidadDeTrabajo())
{
foreach (var item in e.InsertValues)
{
db.UnidadMedida.InsertarValoresUnidadMedida(item.NewValues, int.Parse(dg.GetMasterRowKeyValue().ToString()), null);
}
foreach (var item in e.UpdateValues)
{
db.UnidadMedida.ActualizarUnidadMedida(item.Keys, item.NewValues);
}
foreach (var item in e.DeleteValues)
{
db.UnidadMedida.EliminarUnidadMedida(item.Keys);
}
}
dg.JSProperties["cpOperacionesGrid"] = "Operación realizada con éxito";
}
catch (Exception ex)
{
dg.JSProperties["cpOperacionesGrid"] = "Error: " + ex.Message;
}
e.Handled = true;
}
protected void dgOpcionesMenu_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
ASPxGridView dg = (ASPxGridView)sender;
try
{
using (var db = new UnidadDeTrabajo())
{
foreach (var item in e.InsertValues)
{
db.MenuPerfil.InsertarValoresMenuPerfil(item.NewValues, int.Parse(Session["IdUserMenu"].ToString()));
}
foreach (var item in e.UpdateValues)
{
db.MenuPerfil.ActualizarMenuPerfil(item.Keys, item.NewValues);
}
foreach (var item in e.DeleteValues)
{
db.MenuPerfil.EliminarMenuPerfil(item.Keys);
}
}
dg.JSProperties["cpOperacionesGrid"] = "Operación realizada con éxito";
}
catch (Exception ex)
{
dg.JSProperties["cpOperacionesGrid"] = "Error: " + ex.Message;
}
e.Handled = true;
}
/// <summary>
/// Metodo que controla la edicion de la secuencia de visita de los clientes y carga de nuevo la vista
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void UiVistaDeClientes_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
if (e.UpdateValues.Count <= 0)
{
e.Handled = true;
return;
}
var actualizacionDeCliente = e.UpdateValues[0];
var tipoDeTarea = UiTxtTaskType.Value.ToString().Split('|')[2];
UsuarioDeseaActualizarSecuenciaDeVisitaDeCliente?.Invoke(sender, new SecuenciaPorVendedorArgumento
{
SecuenciaPorVendedor = new SecuenciaPorVendedor
{
CODE_ROUTE = actualizacionDeCliente.Keys["CODE_ROUTE"].ToString(),
TYPE_TASK = tipoDeTarea,
DAY = int.Parse(actualizacionDeCliente.Keys["DAY"].ToString()),
},
PRIORITY = int.Parse(actualizacionDeCliente.NewValues["PRIORITY"].ToString()),
CODE_ROUTE = actualizacionDeCliente.Keys["CODE_ROUTE"].ToString(),
CODE_CUSTOMER = actualizacionDeCliente.Keys["CODE_CUSTOMER"].ToString(),
DAY = int.Parse(actualizacionDeCliente.Keys["DAY"].ToString()),
TYPE_TASK = tipoDeTarea ?? string.Empty
});
e.Handled = true;
}
protected void gvAttendance_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
e.Handled = true;
int j = 0;
while (j < e.UpdateValues.Count)
{
Attendance att = new Attendance();
att.ClassID = int.Parse(gvAttendance.GetRowValues(j, "ClassID").ToString());
att.LessonID = int.Parse(gvAttendance.GetRowValues(j, "LessonID").ToString());
att.Attended = e.UpdateValues[j].NewValues["Attended"].ToString();
att.Score = Decimal.Parse(e.UpdateValues[j].NewValues["Score"].ToString());
att.ClassSchedID = int.Parse(gvAttendance.GetRowValues(j, "ClassSchedID").ToString());
att.Completed = e.UpdateValues[j].NewValues["Completed"].ToString();
att.ModuleID = int.Parse(gvAttendance.GetRowValues(j, "ModuleID").ToString());
att.LastModified = DateTime.Now;
att.ID = int.Parse(gvAttendance.GetRowValues(j, "ID").ToString());
att.IndexNo = int.Parse(gvAttendance.GetRowValues(j, "IndexNo").ToString());
new AttendanceServices().UpdateAttendance(att, new SessionManager().GetUserId(this.Session));
j++;
}
loadAttedScheduls();
}
protected void dgPrensaOrdenTrabajo_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
try
{
using (var db = new UnidadDeTrabajo())
{
OrdenTrabajo ordenTrabajo = db.OrdenTrabajo.ObtenerPorId(int.Parse(lblIdOrden.Text));
ordenTrabajo.OperadoresPrensa = cmbOperadorP.Text;
ordenTrabajo.ComentariosPrensa = txtObservacionesP.Text;
db.OrdenTrabajo.Actualizar(ordenTrabajo);
db.Grabar();
foreach (var item in e.InsertValues)
{
db.PrensaOrdenTrabajo.InsertarValoresPrensaOrdenTrabajo(item.NewValues, int.Parse(lblIdOrden.Text.ToString()));
}
foreach (var item in e.UpdateValues)
{
db.PrensaOrdenTrabajo.ActualizarValoresPrensaOrden(item.Keys, item.NewValues);
}
}
//pcEditorOrdenesTrabajo.ShowOnPageLoad = false;
dgPrensaOrdenTrabajo.JSProperties["cpPrensaOrden"] = "Operación realizada con éxito";
CargarDatosPrensaOrdenTrabajo(int.Parse(lblIdOrden.Text));
}
catch (Exception ex)
{
dgPrensaOrdenTrabajo.JSProperties["cpPrensaOrden"] = "Ha ocurrido un error inesperado: " + ex.Message;
}
e.Handled = true;
}
protected void ASPxGridView1_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
ASPxGridView grid = (ASPxGridView)sender;
e.Handled = true;
foreach (var updateValue in e.UpdateValues)
{
int index = grid.FindVisibleIndexByKeyValue(updateValue.Keys["Seq"]);
int seq = (int)grid.GetRowValues(index, "Seq");
string emp_nm = updateValue.NewValues.Contains("Print_emp_nm") ? Convert.ToString(updateValue.NewValues["Print_emp_nm"]) : Convert.ToString(updateValue.OldValues["Print_emp_nm"]);
string emp_enm = updateValue.NewValues.Contains("Print_emp_enm") ? Convert.ToString(updateValue.NewValues["Print_emp_enm"]) : Convert.ToString(updateValue.OldValues["Print_emp_enm"]);
string comp_nm = updateValue.NewValues.Contains("Print_comp_nm") ? Convert.ToString(updateValue.NewValues["Print_comp_nm"]) : Convert.ToString(updateValue.OldValues["Print_comp_nm"]);
string dept_nm = updateValue.NewValues.Contains("Print_dept_nm") ? Convert.ToString(updateValue.NewValues["Print_dept_nm"]) : Convert.ToString(updateValue.OldValues["Print_dept_nm"]);
string posi_nm = updateValue.NewValues.Contains("Print_posi_nm") ? Convert.ToString(updateValue.NewValues["Print_posi_nm"]) : Convert.ToString(updateValue.OldValues["Print_posi_nm"]);
using (UnitOfWork uow = XpoHelper.GetNewUnitOfWorkINTF())
{
CriteriaOperator op = CriteriaOperator.Parse("Seq=?", seq);
CardApprovalEntity Xpo = uow.FindObject <CardApprovalEntity>(op);
Xpo.Print_emp_nm = emp_nm;
Xpo.Print_emp_enm = emp_enm;
Xpo.Print_comp_nm = comp_nm;
Xpo.Print_dept_nm = dept_nm;
Xpo.Print_posi_nm = posi_nm;
Xpo.Seq = seq;
Xpo.Save();
uow.CommitChanges();
}
}
}
protected void UiVistaReubicacionInventario_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
e.Handled = true;
var borroRegistros = false;
var actualizoRegistros = false;
foreach (var item in e.UpdateValues)
{
foreach (var inv in InventarioReubicado.Where(inv => int.Parse(item.Keys["INVENTORY"].ToString()) == inv.INVENTORY))
{
inv.QTY = float.Parse(item.NewValues["QTY"].ToString());
actualizoRegistros = true; break;
}
}
foreach (var item in e.DeleteValues)
{
foreach (var inv in InventarioReubicado.Where(inv => int.Parse(item.Keys["INVENTORY"].ToString()) == inv.INVENTORY))
{
InventarioReubicado.Remove(inv);
borroRegistros = true;
break;
}
}
if (borroRegistros)
{
UiVistaReubicacionInventario.JSProperties.Add("cpLlenarListaInventario", "Enable");
}
if (actualizoRegistros)
{
Session["UiVistaReubicacionInventario"] = InventarioReubicado;
UiVistaReubicacionInventario.DataSource = InventarioReubicado;
UiVistaReubicacionInventario.DataBind();
}
}
protected void ASPxGridView1_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
foreach (var args in e.UpdateValues)
{
UpdateItem(args.Keys, args.NewValues);
}
e.Handled = true;
}
protected void dgRequerimientoDetalle_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
try
{
NumeroRequerimiento = Request.QueryString["Id"];
using (var db = new UnidadDeTrabajo())
{
if (NumeroRequerimiento == "Nuevo")
{
Requerimiento req = new Requerimiento
{
Fecha = DateTime.Now,
FechaCreacion = DateTime.Now,
IdUsuario = Session["IdUserActive"] != null?int.Parse(Session["IdUserActive"].ToString()) : 1,
TipoRequerimiento = "",
DocumentoReferencia = "",
IdEstado = 26,
};
db.Requerimiento.Insertar(req);
db.Grabar();
foreach (var item in e.InsertValues)
{
db.RequerimientoDetalle.InsertarValoresRequerimientoDetalle(item.NewValues, req.Id, decimal.Parse(txtPrecioDolar.Text));
}
NumeroRequerimiento = req.Id.ToString();
string url = "Requerimientos.aspx?Id=" + NumeroRequerimiento;
Response.RedirectLocation = url;
}
else
{
foreach (var item in e.InsertValues)
{
db.RequerimientoDetalle.InsertarValoresRequerimientoDetalle(item.NewValues, int.Parse(NumeroRequerimiento.ToString()), decimal.Parse(txtPrecioDolar.Text));
}
foreach (var item in e.UpdateValues)
{
db.RequerimientoDetalle.ActualizarRequerimientoDetalle(item.Keys, item.NewValues);
}
foreach (var item in e.DeleteValues)
{
db.RequerimientoDetalle.EliminarRequerimientoDetalle(item.Keys);
}
}
dgRequerimientoDetalle.DataSource = db.RequerimientoDetalle.ObtenerDetalleRequerimiento(int.Parse(NumeroRequerimiento));
dgRequerimientoDetalle.DataBind();
}
dgRequerimientoDetalle.JSProperties["cpOperacionGrid"] = "Operación realizada con éxito";
}
catch (Exception ex)
{
dgRequerimientoDetalle.JSProperties["cpOperacionGrid"] = "Ha ocurrido un error inesperado: " + ex.Message;
}
e.Handled = true;
}
protected void GridView_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
foreach (var args in e.InsertValues)
{
//InsertNewItem(args.NewValues);
}
//foreach (var args in e.UpdateValues)
// UpdateItem(args.Keys, args.NewValues);
//foreach (var args in e.DeleteValues)
// DeleteItem(args.Keys, args.Values);
e.Handled = true;
}
protected void gridVallabels_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
if (e.InsertValues.Count > 0)
{
foreach (var args in e.InsertValues)
{
var x = hidFieldValueSetID.Value;
args.NewValues.Add("fieldvaluesetID", x);
}
}
string results = DxDbOps.ProcessBatch(e, "datFieldValueSetItem", "data", "dbo");
e.Handled = true;
}
protected void UiViewSkuTranferencia_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
var actualizoSku = false;
var borroSku = false;
TransferenciaDetalle transferenciaDetalle;
foreach (var item in e.UpdateValues)
{
transferenciaDetalle = new TransferenciaDetalle {
TRANSFER_ID = Convert.ToInt32(txtCodigo.Text), SKU_CODE = item.Keys["SKU_CODE"].ToString(), QTY = float.Parse(item.NewValues["QTY"].ToString())
};
UsuarioDeseaCrearTransferenciaDetalle?.Invoke(sender, new TransferenciaDetalleArgumento {
Data = transferenciaDetalle
});
actualizoSku = true;
}
foreach (var item in e.DeleteValues)
{
transferenciaDetalle = new TransferenciaDetalle {
TRANSFER_ID = Convert.ToInt32(txtCodigo.Text), SKU_CODE = item.Keys["SKU_CODE"].ToString()
};
UsuarioDeseaEliminarTransferenciaDetalle?.Invoke(sender, new TransferenciaDetalleArgumento {
Data = transferenciaDetalle
});
actualizoSku = true;
borroSku = true;
}
if (actualizoSku)
{
TransferenciaEncabezado transferenciaEncabezado;
transferenciaEncabezado = new TransferenciaEncabezado {
TRANSFER_ID = Convert.ToInt32(txtCodigo.Text)
};
ObtenerTransferenciaDetalle?.Invoke(sender, new TransferenciaDetalleArgumento {
DataTransferenciaEncabezado = transferenciaEncabezado
});
if (borroSku)
{
UiViewSkuTranferencia.JSProperties.Add("cpRecargarListaSku", "Enable");
}
}
e.Handled = true;
UiViewSkuTranferencia.JSProperties.Add("cpLimpiarListaSKUSinSerie", "Enable");
}
protected void UiVistaListainventarioConSerie_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
foreach (var itemDelete in e.DeleteValues)
{
var delete = itemDelete;
foreach (var itemListaInventarioConSerie in ListaInventarioConSerie.Where(itemListaInventarioConSerie => itemListaInventarioConSerie.WAREHOUSE.Equals(delete.Keys["WAREHOUSE"]) && itemListaInventarioConSerie.SKU.Equals(delete.Keys["SKU"]) && itemListaInventarioConSerie.SERIAL_NUMBER.Equals(delete.Keys["SERIAL_NUMBER"])))
{
ListaInventarioConSerie.Remove(itemListaInventarioConSerie);
break;
}
}
e.Handled = true;
}
protected void gvPrivillages_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
e.Handled = true;
string pvbatch = "";
//CHECK IF MAIN MENU ACCESS HAS BEEN ASSIGNED TO THIS STAFF ALREADY
if (cmbMainMenu.Value != null)
{
UserAccess us = new UserAccess();
us.MainId = int.Parse(cmbMainMenu.Value.ToString());
us.UserId = txtstaffId.Text;
if (new UserAccessService().ExistUserAccess(us, new SessionManager().GetUserId(this.Session)))
{
}
else
{
us.DateCreated = DateTime.Now;
us.LastModify = DateTime.Now;
if (new UserAccessService().AddUserAccess(us, new SessionManager().GetUserId(this.Session)))
{
for (int i = 0; i < e.UpdateValues.Count; i++)
{
pvbatch += "('" + txtstaffId.Text + "','" + int.Parse(cmbMainMenu.Value.ToString()) + "','" + int.Parse(e.UpdateValues[i].NewValues[1].ToString()) + "','" + e.UpdateValues[i].NewValues[2].ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'),";
}
if (new UserPermissionService().AddUserPermissionList(pvbatch.TrimEnd(','), new SessionManager().GetUserId(this.Session)))
{
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.success('Saved Successfully','Message')", true);
loadprivillages(int.Parse(cmbMainMenu.Value.ToString()), us.UserId);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.info('Oops something is not right!','Message')", true);
}
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.info('Please select an Access Level.','Message')", true);
cmbMainMenu.IsValid = false;
}
LoadUsers();
cleargvPrivillages();
LoadMainMenu();
uPanel.Update();
UpPrivillages.Update();
}
protected void ASPxGridView3_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
try
{
var newval = new double[e.UpdateValues.Count];//RESULTADO QUE SE INGRESA EN PICKING_DETAIL
var pickingDet = new int[e.UpdateValues.Count];
var conteo = 0;
//OBTIENE LOS VALORES NUEVOS Y LOS ANTERIORES
foreach (var args in e.UpdateValues)
{
foreach (int valor in args.Keys.Values)
{
pickingDet[conteo] = valor;
}
foreach (double valor in args.NewValues.Values)
{
newval[conteo] = valor;
}
conteo++;
}
//INSERTAR HEADER
var ds = _objFreight.InsertPickingHeaderFf(Session["connectionString"].ToString(), ASPxTextBox7.Text, ASPxTextBox3.Value.ToString(), ASPxTextBox6.Text, ASPxTextBox4.Text, ASPxTextBox5.Text);
var header = ds.Tables[0].Rows[0]["ID"].ToString();
//RESULTADO DE LA RESTA DEL VALOR ANTERIOR CON EL NUEVO VALOR
for (var i = 0; e.UpdateValues.Count > i; i++)
{
var dsGrid = (DataSet)Session["DATOS_PICKING_DATASET"];
var dt = dsGrid.Tables[1];
var resultado = dt.Select("PICKING_DETAIL =" + pickingDet[i] + "");
foreach (var row in resultado)
{
_objFreight.InsertPickingDetailFf(Session["connectionString"].ToString(), header, row[1].ToString(), row[2].ToString(), newval[i].ToString(CultureInfo.InvariantCulture));
_objFreight.UpdatePickingDetailFf(Session["connectionString"].ToString(), pickingDet[i].ToString(CultureInfo.InvariantCulture), (Convert.ToDouble(row["ENTREGADO"]) + newval[i]).ToString(CultureInfo.InvariantCulture));
}
_countId = Request.QueryString["codigo"];
GetDataHeader(_countId);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
e.Handled = true;
_countId = Request.QueryString["codigo"];
GetDataHeader(_countId);
}
protected void grditems_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
using (Entities1 db = new Entities1())
{
for (int i = 0; i < e.UpdateValues.Count; i++)
{
grditems.BeginUpdate();
db.usp_RegularMaintenceUpdate(Convert.ToInt16(e.UpdateValues[i].Keys[0]), dtemaintenance.Date, Convert.ToInt16(e.UpdateValues[i].Keys[1]), Convert.ToInt16(e.UpdateValues[i].NewValues[0]));
grditems.EndUpdate();
}
e.Handled = true;
grditems.DataSource = db.usp_RegularMaintenceInsertSelect(dtemaintenance.Date, Convert.ToInt16(drptower.SelectedItem.Value));
DataBind();
}
}
protected void grid_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
foreach (var args in e.InsertValues)
{
DataProvider.InsertCustomer((string)args.NewValues["CustomerName"], (int)args.NewValues["CountryID"], (int)args.NewValues["CityID"]);
}
foreach (var args in e.UpdateValues)
{
DataProvider.UpdateCustomer((int)args.Keys["CustomerID"], (string)args.NewValues["CustomerName"], (int)args.NewValues["CountryID"], (int)args.NewValues["CityID"]);
}
foreach (var args in e.DeleteValues)
{
DataProvider.DeleteCustomer((int)args.Keys["CustomerID"]);
}
e.Handled = true;
}
protected void gridAPD_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
var listInsert = new List <EnterpriseAPD>();
foreach (var args in e.InsertValues)
{
//InsertNewItem(args.NewValues);
EnterpriseAPD EntAPD = new EnterpriseAPD();
EntAPD.APDtype = Convert.ToString(args.NewValues["APDtype"]);
EntAPD.APDNumber = Convert.ToString(args.NewValues["APDNumber"]);
EntAPD.APDName = Convert.ToString(args.NewValues["APDName"]);
EntAPD.Description = Convert.ToString(args.NewValues["Description"]);
EntAPD.StartDate = Convert.ToDateTime(args.NewValues["StartDate"]);
EntAPD.EndDate = Convert.ToDateTime(args.NewValues["EndDate"]);
listInsert.Add(EntAPD);
}
if (listInsert.Count > 0)
{
rtm_services.InsertNewEnterpriseAPD(listInsert);
}
var listUpdates = new List <EnterpriseAPD>();
foreach (var args in e.UpdateValues)
{
EnterpriseAPD Apd = new EnterpriseAPD();
//Apd.Id = Convert.ToString(args.Keys["Id"]);
Apd.APDtype = Convert.ToString(args.NewValues["APDtype"]);
Apd.APDNumber = Convert.ToString(args.NewValues["APDNumber"]);
Apd.APDName = Convert.ToString(args.NewValues["APDName"]);
Apd.Description = Convert.ToString(args.NewValues["Description"]);
Apd.StartDate = Convert.ToDateTime(args.NewValues["StartDate"]);
Apd.EndDate = Convert.ToDateTime(args.NewValues["EndDate"]);
listUpdates.Add(Apd);
}
if (listUpdates.Count > 0)
{
rtm_services.UpdateEnterpriseAPD(listUpdates);
}
foreach (var args in e.DeleteValues)
{
DeleteAPD(args.Keys);
}
e.Handled = true;
BindAPD();
}
protected void gvStudents_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
e.Handled = true;
StudentLessonsRegistration lg = new StudentLessonsRegistration();
for (int i = 0; i < e.UpdateValues.Count; i++)
{
lg.ID = int.Parse(e.UpdateValues[i].Keys[0].ToString());
lg.ExamsMarks = decimal.Parse(e.UpdateValues[i].NewValues[3].ToString());
lg.LastModified = DateTime.Now;
new StudentLessonsRegistrationService().UpdateStudentLessonsRegistrationExams(lg, new SessionManager().GetUserId(this.Session));
}
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.success('Saved Successfully','Message')", true);
loadBatchstudents();
uPanel.Update();
}
protected void dgRecepcionDetalleNew_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
try
{
using (var db = new UnidadDeTrabajo())
{
Recepcion recepcion = new Recepcion
{
Fecha = DateTime.Now,
FechaCreacion = DateTime.Now,
IdUsuario = Session["IdUserActive"] != null?int.Parse(Session["IdUserActive"].ToString()) : 1,
IdEmpresa = int.Parse(cmbProveedor.Value.ToString()),
IdOrdenCompra = int.Parse(cmbIdOrdenCompra.Value.ToString()),
IdTipoDocumento = int.Parse(cmbTipoDocumento.Value.ToString()),
SerieComprobante = txtSerieDocumento.Text,
NumeroComprobante = int.Parse(txtNumeroDocumento.Value.ToString()),
SerieGuiaRemision = txtSerieGuia.Text,
NumeroGuiaRemision = txtNumeroGuia.Value != null?int.Parse(txtNumeroGuia.Text) : 0,
IdEstado = 22,
IdAlmacen = 1,
};
db.Recepcion.Insertar(recepcion);
db.Grabar();
foreach (var item in e.UpdateValues)
{
db.RecepcionDetalle.InsertarValoresRecepcionDetalle(item.NewValues, recepcion.Id);
}
if (db.RecepcionDetalle.SumaCantidades_x_OrdenCompra(int.Parse(cmbIdOrdenCompra.Value.ToString())) == db.RecepcionDetalle.SumaCantidadesRecibidas_x_OrdenCompra(int.Parse(cmbIdOrdenCompra.Value.ToString())))
{
db.OrdenCompra.RecepcionarOrdenCompra(int.Parse(cmbIdOrdenCompra.Value.ToString()), 12);
}
else
{
db.OrdenCompra.RecepcionarOrdenCompra(int.Parse(cmbIdOrdenCompra.Value.ToString()), 21);
}
}
pcEditorRecepciones.ShowOnPageLoad = false;
dgRecepcionDetalleNew.JSProperties["cpAdminOperacion"] = "Operación realizada con éxito";
}
catch (Exception ex)
{
dgRecepcionDetalleNew.JSProperties["cpAdminOperacion"] = "Ha ocurrido un error inesperado: " + ex.Message;
}
e.Handled = true;
}
protected void grid_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
throw new DemoException("Data modifications are not allowed in the online example. If you need to test the data editing functionality, please download the example on your machine and run it locally.");
foreach (var args in e.InsertValues)
{
InsertNewItem(args.NewValues);
}
foreach (var args in e.UpdateValues)
{
UpdateItem(args.Keys, args.NewValues);
}
foreach (var args in e.DeleteValues)
{
DeleteItem(args.Keys, args.Values);
}
entity.SaveChanges();
e.Handled = true;
}
protected void gridSku_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
if (ValidarConexionYUsuarioLogueado(sender))
{
foreach (var item in e.UpdateValues)
{
if (!SaveSku(item.Keys["CODE_SKU"].ToString(), decimal.Parse(item.NewValues["COST"].ToString())))
{
break;
}
}
GetSkuAssigned();
LlenarGridSku();
gridSkuPriceList.JSProperties.Add("cpFillLookSku", "Enable");
e.Handled = true;
}
}
protected void gvFeesBatch_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
e.Handled = true;
string fbatch = "";
string studFees = "";
for (int i = 0; i < e.UpdateValues.Count; i++)
{
//get all batch of the same program/course
// List<int> batchIDs = new ClassSchedulerServices().GetClassSchedulerIDs(int.Parse(cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "ClassID").ToString()), cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "Bgroup").ToString(), new SessionManager().GetUserId(Session));
// foreach (int batchID in batchIDs)
// {
//prepare the data for all the batches fees
//fbatch += "('" + int.Parse(e.UpdateValues[i].NewValues[2].ToString()) + "','" + int.Parse(cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "ID").ToString()) + "','" + double.Parse(e.UpdateValues[i].NewValues[0].ToString()) + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "Bgroup").ToString() + "'),";
//get all the sudent registered under that batch by the batch IDs
List <StudentRegistration> batchRegStud = new StudentRegistrationService().GetAllStudentRegistrationByBatchIdBgroup(int.Parse(cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "ID").ToString()), cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "Bgroup").ToString(), new SessionManager().GetUserId(Session));
if (batchRegStud.Count > 0)
{
foreach (StudentRegistration studUserId in batchRegStud)
{
studFees += "('" + int.Parse(e.UpdateValues[i].NewValues[2].ToString()) + "','" + cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "ID").ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + studUserId.StuduserId + "','" + cmbProgram.GridView.GetRowValues(cmbProgram.GridView.FocusedRowIndex, "Bgroup").ToString() + "','" + double.Parse(e.UpdateValues[i].NewValues[0].ToString()) + "'),";
}
}
//}
}
//if (fbatch.Length != 0 && studFees.Length != 0)
if (studFees.Length != 0)
{
//new FeesBatchesService().AddFeesBatchesList(fbatch.TrimEnd(','), new SessionManager().GetUserId(Session));
new StudentFeesService().AddStudentFeesList(studFees.TrimEnd(','), new SessionManager().GetUserId(Session));
//Session["alertmsg"] = "1";
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.success('Saved Successfully','Message')", true);
}
else
{
//Session["alertmsg"] = "2";
ScriptManager.RegisterStartupScript(this, GetType(), ",toastr", "toastr.info('Oops something is not right! No student registered for this batch','Message')", true);
}
loadBatchFees();
uPanel.Update();
}
protected void UiVistaSku_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
var listaSku = FacturaDetalles;
foreach (var item in e.UpdateValues)
{
foreach (var rowSku in listaSku)
{
if (item.Keys["SKU"].Equals(rowSku.SKU))
{
rowSku.SERIE = item.NewValues["SERIE"].ToString();
rowSku.SERIE_2 = item.NewValues["SERIE_2"].ToString();
break;
}
}
}
e.Handled = true;
LlenarVistaSku(listaSku);
}
protected void UiVistaCargaSecuencia_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
var listaDeModificados = new List <Frecuencia>();
foreach (var item in e.UpdateValues)
{
var registro = Secuencias.FirstOrDefault(p => p.ID_FREQUENCY == int.Parse(item.Keys["ID_FREQUENCY"].ToString()) && p.CODE_CUSTOMER == item.Keys["CODE_CUSTOMER"].ToString());
if (registro == null)
{
continue;
}
registro.SUNDAY = int.Parse(item.NewValues["SUNDAY"].ToString());
registro.MONDAY = int.Parse(item.NewValues["MONDAY"].ToString());
registro.TUESDAY = int.Parse(item.NewValues["TUESDAY"].ToString());
registro.WEDNESDAY = int.Parse(item.NewValues["WEDNESDAY"].ToString());
registro.THURSDAY = int.Parse(item.NewValues["THURSDAY"].ToString());
registro.FRIDAY = int.Parse(item.NewValues["FRIDAY"].ToString());
registro.SATURDAY = int.Parse(item.NewValues["SATURDAY"].ToString());
registro.PRIORITY = int.Parse(item.NewValues["PRIORITY"].ToString());
registro.FREQUENCY_WEEKS = int.Parse(item.NewValues["FREQUENCY_WEEKS"].ToString());
listaDeModificados.Add(registro);
}
if (listaDeModificados.Count > 0)
{
UsuarioDeseaActualizarSecuencia?.Invoke(sender,
new FrecuenciaArgumento
{
XmlDocumentos = ObtenerXmlDeListadoDeSecuencia(listaDeModificados),
UserID = Session["LOGIN"].ToString()
});
}
else
{
TerminoProceso("cpTerminoDeProcesarInformacionDesdeExcel", true, sender);
}
e.Handled = true;
}
protected void grid_BatchUpdate(object sender, DevExpress.Web.Data.ASPxDataBatchUpdateEventArgs e)
{
var IDs = e.UpdateValues.Select(x => (int)x.Keys[0]).ToList();
var prods = _db.ShopProduct.Where(x => IDs.Contains(x.ID)).ToList();
foreach (var item in e.UpdateValues)
{
int id = (int)item.Keys[0];
var prod = prods.First(x => x.ID == id);
prod.Comment = (string)item.NewValues["Comment"];
prod.CategoryID = (int?)item.NewValues["CategoryID"];
prod.ColorID = (int?)item.NewValues["ColorID"];
prod.ProductID = (long?)item.NewValues["ProductID"];
}
_db.SaveChanges();
e.Handled = true;
}
