protected void Grid_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dtbEliminados = new DataTable(); try { dtbEliminados.Columns.Add(Constantes.ColumnaHorarioSchclassid, typeof(int)); 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, dtbEliminados); } new ClsHorariosAsistencia().GestionarHorario((DataTable)Session[Constantes.SesionTablaHorario], dtbEliminados); //Session[Constantes.TablaDistribucion] = null; grvHorarios.DataSource = (DataTable)Session[Constantes.SesionTablaHorario]; grvHorarios.DataBind(); e.Handled = true; } catch (Exception ex) { Session["Error"] = ex.Message; ASPxWebControl.RedirectOnCallback("~/horarios.aspx"); } }
protected void Grid_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dtbEliminados = new DataTable(); try { dtbEliminados.Columns.Add(Constantes.ColumnaCiudadesCodigo, typeof(int)); 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, dtbEliminados); } new ClsGeneral().GestionarCiudad((DataTable)Session[Constantes.SesionTablaCiudades], dtbEliminados); grvCiudades.DataSource = (DataTable)Session[Constantes.SesionTablaCiudades]; grvCiudades.DataBind(); e.Handled = true; } catch (Exception ex) { //Session["ErrorMessage"] = ex.Message; //if (Page.IsCallback) // ASPxWebControl.RedirectOnCallback("~/error.aspx"); //else // Response.Redirect("~/error.aspx", false); } }
protected void Grid_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var listUpdates = new List <RtmProjectChecklist>(); foreach (var args in e.UpdateValues) { RtmProjectChecklist checklist = new RtmProjectChecklist(); checklist.Id = Convert.ToString(args.Keys["Id"]); checklist.Title = Convert.ToString(args.NewValues["Title"]); checklist.Type = Convert.ToString(args.NewValues["Type"]); checklist.Description = Convert.ToString(args.NewValues["Description"]); checklist.IsActive = Convert.ToBoolean(args.NewValues["IsActive"]); listUpdates.Add(checklist); } if (listUpdates.Count > 0) { rtm_services.UpdateCheckListDetails(ddlProjects.SelectedItem.Value.ToString(), listUpdates); } foreach (var args in e.DeleteValues) { DeleteItem(args.Keys); } e.Handled = true; BindCheckList(ddlProjects.SelectedItem.Value.ToString()); BindObjectives(); BindCriteria(); }
protected void GridObjective_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var listUpdates = new List <RtmObjectives>(); foreach (var args in e.UpdateValues) { RtmObjectives objective = new RtmObjectives(); objective.Id = Convert.ToString(args.Keys["Id"]); objective.UniqueId = Convert.ToString(args.NewValues["UniqueId"]); objective.Name = Convert.ToString(args.NewValues["Name"]); listUpdates.Add(objective); } if (listUpdates.Count > 0) { rtm_services.UpdateObjectivesDetails(listUpdates); } foreach (var args in e.DeleteValues) { DeleteObjecyiveItem(args.Keys); } e.Handled = true; BindObjectives(); BindCriteria(); }
protected void gridCriteria_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var listUpdates = new List <RtmCriteria>(); foreach (var args in e.UpdateValues) { RtmCriteria criteria = new RtmCriteria(); criteria.Id = Convert.ToString(args.Keys["Id"]); criteria.Title = Convert.ToString(args.NewValues["Title"]); criteria.Name = Convert.ToString(args.NewValues["Name"]); criteria.Criteria = Convert.ToString(args.NewValues["Criteria"]); criteria.Source = Convert.ToString(args.NewValues["Source"]); criteria.Critical = Convert.ToBoolean(args.NewValues["Critical"]); listUpdates.Add(criteria); } if (listUpdates.Count > 0) { rtm_services.UpdateCriteriatDetails(listUpdates); } foreach (var args in e.DeleteValues) { DeleteCriteriaItem(args.Keys); } e.Handled = true; BindCriteria(); }
//public static DxDbOps() //{ // // // // TODO: Add constructor logic here // // //} public static string ProcessBatch(ASPxDataBatchUpdateEventArgs e, string tbl, string db, string schema) { string results = ""; if (e.InsertValues.Count > 0) { foreach (ASPxDataInsertValues i in e.InsertValues) { BuildInsertSqlCode(i, tbl, db, schema); } } if (e.UpdateValues.Count > 0) { foreach (ASPxDataUpdateValues u in e.UpdateValues) { BuildUpdateSqlCode(u, tbl, db, schema); } } if (e.DeleteValues.Count > 0) { foreach (ASPxDataDeleteValues d in e.DeleteValues) { results += BuildDeleteSqlCode(d, tbl, db, schema); } } return(results); }
protected void UiVistaOrdenDeVentaDetalle_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } foreach (var itemUpdate in e.UpdateValues) { var update = itemUpdate; foreach (var itemOrden in OrdenDeVentaDetalles.Where(itemOrden => itemOrden.SKU.Equals(update.Keys["SKU"]))) { itemOrden.QTY = decimal.Parse(itemUpdate.NewValues["QTY"].ToString()); itemOrden.TOTAL_LINE = itemOrden.PRICE * decimal.Parse(itemUpdate.NewValues["QTY"].ToString()); itemOrden.DISCOUNT = UiSpinDescuentoAplicado.Number; itemOrden.TOTAL_DISCOUNT = (itemOrden.TOTAL_LINE - ((itemOrden.TOTAL_LINE * itemOrden.DISCOUNT) / 100)); } } foreach (var itemDelete in e.DeleteValues) { var delete = itemDelete; foreach (var itemOrden in OrdenDeVentaDetalles.Where(itemOrden => itemOrden.SKU.Equals(delete.Keys["SKU"]))) { OrdenDeVentaDetalles.Remove(itemOrden); AgregarSkuAListaSkusParaVenta(itemOrden.SKU); break; } ((ASPxGridView)(sender)).JSProperties.Add("cpActualizarListaSkusParaVenta", "enable"); } e.Handled = true; }
protected void ASPxGridView1_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { GetFormValues(); foreach (var args in e.UpdateValues) { DataProvider.UpdateItem(args.Keys, args.NewValues); } ASPxGridView1.JSProperties["cpInfo"] = "Submitted"; e.Handled = true; }
protected void Grid_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { foreach (var args in e.InsertValues) { GridDataItem.InsertNewItem(args.NewValues); } foreach (var args in e.UpdateValues) { GridDataItem.UpdateItem(args.Keys, args.NewValues); } e.Handled = true; }
protected void GridGroupDetail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dt = new DataTable(); foreach (var args in e.UpdateValues) { string OBID = args.Keys[0].ToString(); // leftrel string tag_no = args.NewValues[2].ToString(); string right_rel = CauseGrid.GetRowValuesByKeyValue(OBID, "RIGHTREL").ToString(); string qry = " UPDATE TBLSYSTEM_TAGNO SET TAGNO = '" + tag_no + "' "; qry = qry + " WHERE LEFTREL = '" + OBID + "' AND RIGHTREL = '" + right_rel + "' "; SqlCommand cmd; cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn); cmd.ExecuteNonQuery(); } }
protected void Grid_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { foreach (var args in e.InsertValues) { InsertNewItem(args.NewValues, true, (ASPxGridView)sender); } foreach (var args in e.UpdateValues) { UpdateItem(args.Keys, args.NewValues, true); } foreach (var args in e.DeleteValues) { DeleteItem(args.Keys, args.Values, true); } e.Handled = true; }
// Method for grid update for GridCategory protected void GridCategory_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var listInsert = new List <BusinessCategory>(); foreach (var args in e.InsertValues) { //InsertNewItem(args.NewValues); BusinessCategory category = new BusinessCategory(); category.AreaID = Convert.ToString(args.NewValues["AreaID"]); category.UniqueID = Convert.ToString(args.NewValues["UniqueID"]); category.CategoryTitle = Convert.ToString(args.NewValues["CategoryTitle"]); category.Description = Convert.ToString(args.NewValues["Description"]); category.Source = Convert.ToString(args.NewValues["Source"]); category.Date = Convert.ToDateTime(args.NewValues["Date"]); listInsert.Add(category); } if (listInsert.Count > 0) { rtm_services.InsertNewBusinessCategory(listInsert); } var listUpdates = new List <BusinessCategory>(); foreach (var args in e.UpdateValues) { BusinessCategory category = new BusinessCategory(); category.Id = Convert.ToString(args.Keys["Id"]); category.UniqueID = Convert.ToString(args.NewValues["UniqueID"]); category.CategoryTitle = Convert.ToString(args.NewValues["CategoryTitle"]); category.Description = Convert.ToString(args.NewValues["Description"]); category.Source = Convert.ToString(args.NewValues["Source"]); category.Date = Convert.ToDateTime(args.NewValues["Date"]); listUpdates.Add(category); } if (listUpdates.Count > 0) { rtm_services.UpdateBusinessCategory(listUpdates); } foreach (var args in e.DeleteValues) { DeleteCategoryItem(args.Keys); } e.Handled = true; BindCategory(); BindProcess(ddlProjects.SelectedItem.Value.ToString()); }
// Method for grid update for GridProcess protected void GridProcess_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var listInsert = new List <BusinessProcess>(); foreach (var args in e.InsertValues) { //InsertNewItem(args.NewValues); BusinessProcess process = new BusinessProcess(); process.CategoryId = Convert.ToString(args.NewValues["CategoryId"]); process.UniqueID = Convert.ToString(args.NewValues["UniqueID"]); process.ProcessTitle = Convert.ToString(args.NewValues["ProcessTitle"]); process.Description = Convert.ToString(args.NewValues["Description"]); process.Source = Convert.ToString(args.NewValues["Source"]); process.Date = Convert.ToDateTime(args.NewValues["Date"]); listInsert.Add(process); } if (listInsert.Count > 0) { rtm_services.InsertNewBusinessProcesses(listInsert); } var listUpdates = new List <BusinessProcess>(); foreach (var args in e.UpdateValues) { BusinessProcess process = new BusinessProcess(); process.Id = Convert.ToString(args.Keys["Id"]); process.UniqueID = Convert.ToString(args.NewValues["UniqueID"]); process.ProcessTitle = Convert.ToString(args.NewValues["ProcessTitle"]); process.Description = Convert.ToString(args.NewValues["Description"]); process.Source = Convert.ToString(args.NewValues["Source"]); process.Date = Convert.ToDateTime(args.NewValues["Date"]); process.IsActive = Convert.ToBoolean(args.NewValues["IsActive"]); listUpdates.Add(process); } if (listUpdates.Count > 0) { rtm_services.UpdateProcessDetails(ddlProjects.SelectedItem.Value.ToString(), listUpdates); } foreach (var args in e.DeleteValues) { DeleteProcessItem(args.Keys); } e.Handled = true; BindProcess(ddlProjects.SelectedItem.Value.ToString()); }
protected void UiVistaClientes_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var actualizoSku = false; var borroSku = false; Frecuencia frecuencia; int idFrecuencia = 0; foreach (var item in e.UpdateValues) { idFrecuencia = int.Parse(item.Keys["ID_FREQUENCY"].ToString()); frecuencia = new Frecuencia { ID_FREQUENCY = idFrecuencia, CODE_CUSTOMER = item.Keys["CODE_CUSTOMER"].ToString(), PRIORITY = int.Parse(item.NewValues["PRIORITY"].ToString()) }; UsuarioDeseaInsertarCliente?.Invoke(UiVistaClientes, new FrecuenciaArgumento { Data = frecuencia }); actualizoSku = true; } foreach (var item in e.DeleteValues) { idFrecuencia = int.Parse(item.Keys["ID_FREQUENCY"].ToString()); frecuencia = new Frecuencia { ID_FREQUENCY = idFrecuencia, CODE_CUSTOMER = item.Keys["CODE_CUSTOMER"].ToString() }; UsuarioDeseaBorrarCliente?.Invoke(sender, new FrecuenciaArgumento { Data = frecuencia }); actualizoSku = true; borroSku = true; } if (actualizoSku && idFrecuencia != 0) { UsuarioDesesaObtenerClientesAsociados?.Invoke(UiVistaClientes, new FrecuenciaArgumento { Data = new Frecuencia { ID_FREQUENCY = idFrecuencia } }); if (borroSku) { UiVistaClientes.JSProperties.Add("cpLlenarListaClientes", "Enable"); } } e.Handled = true; }
protected void GridGroupDetail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dt = new DataTable(); foreach (var args in e.UpdateValues) { string OBID = args.Keys[0].ToString(); string desc_new = args.NewValues[0].ToString(); string seq_new = args.NewValues[1].ToString(); string qry = " UPDATE TBLSYSTEM_TEMPLATE SET DESCRIPTION = '" + desc_new + "', SEQ = '" + seq_new + "' "; qry = qry + " WHERE OBID = '" + OBID + "' "; SqlCommand cmd; cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn); cmd.ExecuteNonQuery(); } }
protected void gridEditStaff_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { int staffID = Convert.ToInt32(gridStaffList.GetSelectedFieldValues("staffID").First()); List <bool> results = new List <bool>(); foreach (ASPxDataUpdateValues args in e.UpdateValues) { if (Convert.ToInt32(args.Keys[0].ToString()) < 0) { //Add staffID to the NewValues //int staffID = Convert.ToInt32(cboStaffInLab.Value.ToString()); args.NewValues["staffID"] = staffID; bool result = DxDbOps.BuildInsertSqlCode(args.NewValues, "tbllabgroup_staff", "backend"); results.Add(result); if (result) { needrefresh = true; } } else { bool result = DxDbOps.BuildUpdateSqlCode(args, "tbllabgroup_staff", "backend"); results.Add(result); if (result) { needrefresh = true; } } } DataTable dt = GetStaffToEdit(staffID); Session["labgroups_staff"] = dt; e.Handled = true; }
protected void Grid_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { if (!BatchUpdateCheckBox.Checked) { return; } 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; }
/// <summary> /// UiVistaDeSkusAsociadosAPromocionDeVentaPorMultiplo_OnBatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void UiVistaDeSkusAsociadosAPromocionDeVentaPorMultiplo_OnBatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } try { var listaDeSkusModificados = new List <VentaPorMultiploDePromo>(); foreach (var item in e.UpdateValues) { var skuDeVentaPorMultiplo = SkusAsociadosAPromocionDeVentaPorMultiplo.FirstOrDefault(sku => sku.SWIFT_PROMO_SKU_SALES_BY_MULTIPLE_ID == int.Parse(item.Keys["SWIFT_PROMO_SKU_SALES_BY_MULTIPLE_ID"].ToString())); if (skuDeVentaPorMultiplo == null) { continue; } skuDeVentaPorMultiplo.MULTIPLE = int.Parse(item.NewValues["MULTIPLE"].ToString()); listaDeSkusModificados.Add(skuDeVentaPorMultiplo); } if (listaDeSkusModificados.Count > 0) { UsuarioDeseaModificarSkuDeVentaPorMultiploAsociadoAPromocionDeVentaPorMultiplo?.Invoke( sender, new PromoArgumento { Promo = new Promo { PROMO_ID = int.Parse(UiTxtCodigoDePromocionDeVentaPorMultiplo.Value.ToString()) } , VentasPorMultiploDePromo = listaDeSkusModificados }); } var listaDeSkusEliminados = e.DeleteValues.Select(skuEliminado => SkusAsociadosAPromocionDeVentaPorMultiplo.FirstOrDefault(sku => sku.SWIFT_PROMO_SKU_SALES_BY_MULTIPLE_ID == int.Parse(skuEliminado.Keys["SWIFT_PROMO_SKU_SALES_BY_MULTIPLE_ID"].ToString()))).ToList(); if (listaDeSkusEliminados.Count > 0) { UsuarioDeseaEliminarSkuDeVentaPorMultiploAsociadoAPromocionDeVentaPorMultiplo?.Invoke(sender, new PromoArgumento { Promo = new Promo { PROMO_ID = int.Parse(UiTxtCodigoDePromocionDeVentaPorMultiplo.Value.ToString()) } , VentasPorMultiploDePromo = listaDeSkusEliminados }); } e.Handled = true; } catch (Exception exception) { EstablecerError(exception.Message, sender); } }
protected void ASPxGridView3_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } try { var fieldValues = ASPxGridView3.GetSelectedFieldValues(new[] { "CODE_CUSTOMER", "NAME_CUSTOMER" }); var newval = new int[e.UpdateValues.Count]; var customerKey = new string[e.UpdateValues.Count]; var conteo = 0; var customerValues = new Customer[fieldValues.Count]; var objSync = new System.Collections.ObjectModel.Collection <SyncSellers>(); var objNewTask = new System.Collections.ObjectModel.Collection <NewTask>(); foreach (var args in e.UpdateValues) { foreach (string valor in args.Keys.Values) { customerKey[conteo] = valor; } foreach (int valor in args.NewValues.Values) { newval[conteo] = valor; } conteo++; } conteo = 0; foreach (object[] value in fieldValues) { var flag = false; customerValues[conteo] = new Customer { CodeCustomer = value[0].ToString(), NameCustomer = value[1].ToString() }; for (var i = 0; customerKey.Count() > i; i++) { if (customerKey[i] != value[0].ToString()) { continue; } customerValues[conteo].Priority = newval[i]; flag = true; } if (flag == false) { customerValues[conteo].Priority = 1; } conteo++; } for (var i = 0; customerValues.Count() > i; i++) { var pResult = ""; _objTask.UpdateInsertPresaleTasks(Session["connectionString"].ToString(), customerValues[i].CodeCustomer, customerValues[i].NameCustomer, ASPxGridLookup1.Text, ASPxMemo1.Text, ASPxTimeEdit1.DateTime, ASPxCalendar1.SelectedDate, customerValues[i].Priority, ref pResult); if (pResult != ASPxGridLookup1.Text) { objSync.Add(new SyncSellers { OldSeller = pResult, NewSeller = ASPxGridLookup1.Text }); } else { objNewTask.Add(new NewTask { NewSeller = ASPxGridLookup1.Text }); } } //puede ser distinct por si solo se desea una notificacion ASPxGridView3.JSProperties.Add("cpSyncUsers", new object[] { objSync }); ASPxGridView3.JSProperties.Add("cpNewTask", new object[] { objNewTask }); GetTasksByDate(ASPxCalendar1.SelectedDate); ASPxPopupControl1.ShowOnPageLoad = false; ASPxGridLookup1.Text = ""; ASPxMemo1.Text = ""; ASPxGridView3.Selection.UnselectAll(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true); } e.Handled = true; }
protected void UiVistaBodegasAsociadasAOficinaDeVentas_OnBatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var idOficina = 0; if (UiTxtCodigo.Text != "") { idOficina = int.Parse(UiTxtCodigo.Text); } if (idOficina != 0) { var listaBodegasEliminadas = new List <Bodega>(); foreach (var item in e.DeleteValues) { var bodega = new Bodega { CODE_WAREHOUSE = item.Keys["CODE_WAREHOUSE"].ToString() }; listaBodegasEliminadas.Add(bodega); } if (listaBodegasEliminadas.Count > 0) { foreach (var item in listaBodegasEliminadas) { UsuarioDeseaEliminarBodegaALaOficinaDeVentas?.Invoke(sender, new OficinaDeVentaArgumento { OficinaDeVenta = new OficinaDeVenta { SALES_OFFICE_ID = idOficina } , Bodega = item }); } } e.Handled = true; UiVistaBodegasAsociadasAOficinaDeVentas.JSProperties.Add("cpTerminoBatchBodegas", "Enabled"); } else { var listaNueva = BodegasAsociadas ?? new List <Bodega>(); foreach (var item in e.DeleteValues) { var tmp = (List <Bodega>)listaNueva; tmp.RemoveAll(x => x.CODE_WAREHOUSE == item.Keys["CODE_WAREHOUSE"].ToString()); listaNueva = tmp; } BodegasAsociadas = listaNueva; e.Handled = true; var res = BodegasNoAsociadas.Where( s => BodegasAsociadas.All(s2 => s2.CODE_WAREHOUSE != s.CODE_WAREHOUSE)).ToList(); BodegasNoAsociadas = res; UiVistaBodegasAsociadasAOficinaDeVentas.JSProperties.Add("cpTerminoBatchBodegasNueva", "Enabled"); } }
protected void Detail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dt = new DataTable(); ASPxGridView EffectGrid = (ASPxGridView)sender; foreach (var args in e.UpdateValues) { string OBID = args.Keys[0].ToString();// leftrel string tag_no = args.NewValues[3].ToString(); string right_rel = EffectGrid.GetRowValuesByKeyValue(OBID, "RIGHTREL").ToString(); string qry = " UPDATE TBLSYSTEM_TAGNO SET TAGNO = '" + tag_no + "' "; qry = qry + " WHERE LEFTREL = '" + OBID + "' AND RIGHTREL = '" + right_rel + "' "; SqlCommand cmd; cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn); cmd.ExecuteNonQuery(); } }
protected void GridGroupDetail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { SqlCommand up_cmd = new SqlCommand(); up_cmd.Connection = fgm_moduler.func_Class.conn; bool success = false; string grouptag_Name; XmlDocument tag_Doc = new XmlDocument(); XmlElement tag_Ele; XmlElement data_Ele; tag_Ele = tag_Doc.CreateElement("Detector"); tag_Ele.SetAttribute("Name", tagName.Value); tag_Ele.SetAttribute("OBID", Detector_obid); tag_Doc.AppendChild(tag_Ele); DataTable dt1 = Srch_DataField("FDM"); DataTable dt = dynamic_table; dt.Columns.Add("v_state"); dt.Columns.Add("old_value"); //dt.Columns.Add("old_value"); string db_name = ""; string auth = ""; foreach (var args in e.UpdateValues) { db_name = args.Keys[0].ToString(); DataRow dr = dt.Select("DB_NAME = '" + db_name + "'")[0]; if(dr["AUTH"].ToString() != "System") { string newValue = ""; if (args.NewValues["N3_VALUE"] != null) newValue = args.NewValues["N3_VALUE"].ToString(); dr["old_value"] = args.OldValues["N3_VALUE"].ToString(); dr["N3_VALUE"] = newValue; dr["v_state"] = "Updated"; } } foreach (DataRow dr in dt.Select("AUTH <> 'System'", "VIEW_SEQ")) { //db_name = dr["DB_NAME"].ToString(); //auth = dr["AUTH"].ToString(); data_Ele = tag_Doc.CreateElement("Data"); data_Ele.SetAttribute("Name", dr["DB_NAME"].ToString()); data_Ele.InnerText = dr["N3_VALUE"].ToString(); if (dr["v_state"].ToString() == "Updated") { data_Ele.SetAttribute("v_state", "Updated"); data_Ele.SetAttribute("old_value", dr["old_value"].ToString()); } tag_Ele.AppendChild(data_Ele); } grouptag_Name = fgm_moduler.Validate_tagName(ref tag_Ele, env_config, module_Name, ""); if (grouptag_Name.Contains("Err")) { (sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "Tag No : Error - "+group_Name; return; } if (grouptag_Name != tag_Ele.GetAttribute("oldValue")) { fgm_moduler.Update_N2REVGRP(up_cmd, "N1NAME", grouptag_Name, Detector_obid); tagName.Value = grouptag_Name; } try { foreach (XmlElement Ele in tag_Ele.SelectNodes("./Data[@v_state = 'Updated']")) { //Count Handling if (Ele.GetAttribute("Name").ToString() == "CNT") { int prev_cnt; int cur_cnt; try { prev_cnt = Convert.ToInt32(Ele.Attributes["old_value"].Value); cur_cnt = Convert.ToInt32(Ele.InnerText); } catch (Exception ex) { (sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "CNT : Invalid value"; success = false; continue; } if (prev_cnt < cur_cnt) { int add = cur_cnt - prev_cnt; for (int i = 0; i < add; i++) { Add_Detector(Detector_obid, grouptag_Name,tag_Ele); } } else if (prev_cnt == cur_cnt) { success = false; continue; } else { int del = prev_cnt - cur_cnt; for (int i = 0; i < del; i++) { Del_Detector(Detector_obid); } } } fgm_moduler.Add_Attr(ref up_cmd, Ele.GetAttribute("Name"), "text", Ele.InnerText, Detector_obid); success = true; } if (e.UpdateValues.Count > 0) { if (success) { fgm_moduler.Update_N2REVGRP(up_cmd, "N1LASTUPDATED", "date", Detector_obid); fgm_moduler.Update_N2REVGRP(up_cmd, "", "version", Detector_obid); } } makeViewGridGroupDetail(Detector_obid); } catch (Exception ex) { (sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = ex.ToString(); } e.Handled = true; }
protected void GridDetector_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { SqlCommand up_cmd = new SqlCommand(); SqlCommand chk_cmd = new SqlCommand(); SqlDataReader chk_reader; bool success = false; bool g_success = false; up_cmd.Connection = fgm_moduler.func_Class.conn; chk_cmd.Connection = fgm_moduler.func_Class.conn; XmlDocument tag_Doc = new XmlDocument(); XmlElement root_Ele = tag_Doc.CreateElement("UpdateTags"); tag_Doc.AppendChild(root_Ele); XmlElement tag_Ele = null ; XmlElement data_Ele; DataTable dt = dynamic_table_detector; dt.Columns.Add("v_state"); dt.Columns.Add("old_value"); foreach (var args in e.UpdateValues) { string[] split = args.Keys[0].ToString().Split('@'); string detector_obid = split[0]; string db_name = split[1]; string detector_name = split[2]; DataRow dr = dt.Select("OBID = '" + detector_obid + "' AND DB_NAME ='" + db_name + "'")[0]; //if (dr["AUTH"].ToString() != "System") //{ string newValue = ""; if (args.NewValues["N3_VALUE"] != null) newValue = args.NewValues["N3_VALUE"].ToString(); dr["old_value"] = args.OldValues["N3_VALUE"].ToString(); dr["N3_VALUE"] = newValue; dr["v_state"] = "Updated"; //} } string tag_obid = ""; string tag_name = ""; //XML Document 생성 foreach (DataRow dr in dt.Select("", "N1NAME, VIEW_SEQ")) { if (tag_obid != dr["OBID"].ToString()) { tag_obid = dr["OBID"].ToString(); tag_name = dr["N1NAME"].ToString(); tag_Ele = tag_Doc.CreateElement("Detector"); tag_Ele.SetAttribute("Name", tag_name); tag_Ele.SetAttribute("OBID", tag_obid); root_Ele.AppendChild(tag_Ele); } data_Ele = tag_Doc.CreateElement("Data"); data_Ele.SetAttribute("Name", dr["DB_NAME"].ToString()); data_Ele.InnerText = dr["N3_VALUE"].ToString(); if (dr["v_state"].ToString() == "Updated") { data_Ele.SetAttribute("v_state", "Updated"); data_Ele.SetAttribute("old_value", dr["old_value"].ToString()); } tag_Ele.AppendChild(data_Ele); } try { tag_obid = ""; tag_name = ""; foreach (XmlElement detector_Ele in tag_Doc.SelectNodes("//Detector")) { success = false; XmlElement Ele = detector_Ele; tag_name = fgm_moduler.Validate_tagName(ref Ele, env_config, "FDMDetector", ""); tag_obid = detector_Ele.GetAttribute("OBID"); if (tag_name.Contains("Err")) { (sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "Tag No : Error - " + tag_name; return; } if (Ele.GetAttribute("oldValue") != "") { string v_sql = "SELECT N1NAME FROM N2REVGRP WHERE N1NAME = '" + tag_name + "' AND N1TERMINATIONDATE = '' "; v_sql = v_sql + "AND N1CLASS = 'TagDetector' AND N1PROJECTNAME = '" + SessionInfo.ProjectName + "' "; chk_cmd.CommandText = v_sql; chk_reader = chk_cmd.ExecuteReader(); if (chk_reader.Read()) { //Tag No. 중복검사 (sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = "SEQ : Duplicate"; //e.Handled = true; chk_reader.Close(); break; } else { //TagNo Change chk_reader.Close(); fgm_moduler.Update_N2REVGRP(up_cmd, "N1NAME", tag_name, tag_obid); } } foreach (XmlElement detector_Data_Ele in detector_Ele.SelectNodes("./Data[@v_state = 'Updated']")) { fgm_moduler.Add_Attr(ref up_cmd, detector_Data_Ele.GetAttribute("Name"), "text", detector_Data_Ele.InnerText, tag_obid); if (detector_Data_Ele.GetAttribute("Name") == "SEQ") { fgm_moduler.Update_N2REVGRP(up_cmd, "N1LIBRARYNO", detector_Data_Ele.InnerText, tag_obid); } success = true; g_success = true; } if (success) { fgm_moduler.Update_N2REVGRP(up_cmd, "N1LASTUPDATED", "date", tag_obid); } } //Group Detector 수정날짜 변경 if (e.UpdateValues.Count > 0) { if (g_success) { fgm_moduler.Update_N2REVGRP(up_cmd, "N1LASTUPDATED", "date", Detector_obid); fgm_moduler.Update_N2REVGRP(up_cmd, "", "version", Detector_obid); makeViewGridGroupDetail(Detector_obid); } } } catch (Exception ex) { (sender as ASPxGridView).JSProperties["cpConfirmationMessage"] = ex.ToString(); } e.Handled = true; }
protected void UiVistaVendedoresOficina_OnBatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var idOficina = 0; if (UiTxtCodigo.Text != "") { idOficina = int.Parse(UiTxtCodigo.Text); } if (idOficina != 0) { var listaVendedoresEliminados = new List <Vendedor>(); foreach (var item in e.DeleteValues) { var vendedor = new Vendedor { SELLER_CODE = item.Keys["SELLER_CODE"].ToString() }; listaVendedoresEliminados.Add(vendedor); } if (listaVendedoresEliminados.Count > 0) { foreach (var item in listaVendedoresEliminados) { UsuarioDeseaEliminarVendedorALaOficinaDeVentas?.Invoke(sender, new OficinaDeVentaArgumento { OficinaDeVenta = new OficinaDeVenta { SALES_OFFICE_ID = idOficina } , Vendedor = item }); } } e.Handled = true; UiVistaVendedoresOficina.JSProperties.Add("cpTerminoBatch", "Enabled"); } else { var listaNueva = VendedoresAsociados ?? new List <Vendedor>(); foreach (var item in e.DeleteValues) { var tmp = (List <Vendedor>)listaNueva; tmp.RemoveAll(x => x.SELLER_CODE == item.Keys["SELLER_CODE"].ToString()); listaNueva = tmp; } VendedoresAsociados = listaNueva; e.Handled = true; var res = VendedoresNoAsociados.Where( s => VendedoresAsociados.All(s2 => s2.SELLER_CODE != s.SELLER_CODE)).ToList(); VendedoresNoAsociados = res; UiVistaVendedoresOficina.JSProperties.Add("cpTerminoBatchNuevoCombo", "Enabled"); } }
/// <summary> /// Actualiza o elimina nuestros skus asociados a la promo /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void UiVistaSkusAsociadosADescuentoPorPrecioEspecial_OnBatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { if (!ValidarConexionYUsuarioLogueado(sender)) { return; } #region Actualizar var ListaDeSkusModificados = new List <DescuentosPorPrecioEspecial>(); foreach (var item in e.UpdateValues) { var SkuACambiar = SkusAsociadosAPromo.FirstOrDefault(p => p.SPECIAL_PRICE_LIST_BY_SCALE_ID == int.Parse(item.Keys["SPECIAL_PRICE_LIST_BY_SCALE_ID"].ToString())); if (SkuACambiar == null) { continue; } SkuACambiar.SPECIAL_PRICE_LIST_BY_SCALE_ID = SkuACambiar.SPECIAL_PRICE_LIST_BY_SCALE_ID; SkuACambiar.INCLUDE_DISCOUNT = int.Parse(item.NewValues["INCLUDE_DISCOUNT"].ToString()); SkuACambiar.PRICE = Decimal.Parse(item.NewValues["PRICE"].ToString()); ListaDeSkusModificados.Add(SkuACambiar); } if (ListaDeSkusModificados.Count > 0 || e.DeleteValues.Count > 0) { foreach (var skuUpdate in ListaDeSkusModificados) { UsuarioDeseaActualizarSkusAPromo?.Invoke(sender, new PromoArgumento { DescuentoPorPrecioEspecial = new DescuentosPorPrecioEspecial { SPECIAL_PRICE_LIST_BY_SCALE_ID = skuUpdate.SPECIAL_PRICE_LIST_BY_SCALE_ID, INCLUDE_DISCOUNT = skuUpdate.INCLUDE_DISCOUNT, PRICE = skuUpdate.PRICE }, Promo = new Promo { PROMO_ID = int.Parse(UiTxtCodigoDePromocionDeDescuentoPorPrecioEspecial.Value.ToString()) } }); } } else { EstablecerError(Enums.GetStringValue(ErrorEnPreciosEspeciales.SinRegistrosAActualizar), sender); } #endregion #region Eliminar foreach (var item in e.DeleteValues) { var SkuAEliminar = SkusAsociadosAPromo.FirstOrDefault(p => p.SPECIAL_PRICE_LIST_BY_SCALE_ID == int.Parse(item.Keys["SPECIAL_PRICE_LIST_BY_SCALE_ID"].ToString())); if (SkuAEliminar == null) { continue; } UsuarioDeseaEliminarSkusAPromo?.Invoke(sender, new PromoArgumento { Promo = new Promo { PROMO_ID = int.Parse(UiTxtCodigoDePromocionDeDescuentoPorPrecioEspecial.Value.ToString()) }, DescuentoPorPrecioEspecial = new DescuentosPorPrecioEspecial { SPECIAL_PRICE_LIST_BY_SCALE_ID = SkuAEliminar.SPECIAL_PRICE_LIST_BY_SCALE_ID } }); } #endregion e.Handled = true; }
protected void UiVistaSkusCombo_OnBatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { var idCombo = 0; if (UiTxtCodigo.Text != "") { idCombo = int.Parse(UiTxtCodigo.Text); } if (idCombo != 0) { var listaSkuPorCombos = new List <SkuPorCombo>(); var listaSkuPorComboEliminados = new List <SkuPorCombo>(); foreach (var item in e.UpdateValues) { var skuPorCombo = new SkuPorCombo { COMBO_ID = idCombo , CODE_SKU = item.Keys["CODE_SKU"].ToString() , PACK_UNIT = int.Parse(item.Keys["PACK_UNIT"].ToString()) , QTY = int.Parse(item.NewValues["QTY"].ToString()) }; listaSkuPorCombos.Add(skuPorCombo); skuPorCombo = null; } if (listaSkuPorCombos.Count > 0) { UsuarioDeseaActualizarProductoDelCombo?.Invoke(sender, new ComboArgumento { Combo = new Combo { COMBO_ID = idCombo } , ProductosDeComboQueCambiaron = listaSkuPorCombos }); } foreach (var item in e.DeleteValues) { var skuPorCombo = new SkuPorCombo { COMBO_ID = idCombo , CODE_SKU = item.Keys["CODE_SKU"].ToString() , PACK_UNIT = int.Parse(item.Keys["PACK_UNIT"].ToString()) }; listaSkuPorComboEliminados.Add(skuPorCombo); skuPorCombo = null; } if (listaSkuPorComboEliminados.Count > 0) { UsuarioDeseaEliminarProductoAlCombo?.Invoke(sender, new ComboArgumento { Combo = new Combo { COMBO_ID = idCombo , SkusPorCombo = listaSkuPorComboEliminados } }); } e.Handled = true; UiVistaSkusCombo.JSProperties.Add("cpTerminoBatch", "Enabled"); } else { var listaNueva = ProductosDeCombo ?? new List <SkuPorCombo>(); foreach (var item in e.UpdateValues) { listaNueva.Where(w => w.CODE_SKU == item.Keys["CODE_SKU"].ToString() && w.PACK_UNIT == int.Parse(item.Keys["PACK_UNIT"].ToString())).ToList().ForEach(i => i.QTY = int.Parse(item.NewValues["QTY"].ToString())); } foreach (var item in e.DeleteValues) { var tmp = (List <SkuPorCombo>)listaNueva; tmp.RemoveAll(x => x.CODE_SKU == item.Keys["CODE_SKU"].ToString() && x.PACK_UNIT == int.Parse(item.Keys["PACK_UNIT"].ToString())); listaNueva = tmp; } ProductosDeCombo = listaNueva; e.Handled = true; var res = ProductosNoAsociadosAlCombo.Where( s => ProductosDeCombo.All(s2 => s2.CODE_SKU != s.CODE_SKU && s2.PACK_UNIT != s.PACK_UNIT)).ToList(); ProductosNoAsociadosAlCombo = res; UiVistaSkusCombo.JSProperties.Add("cpTerminoBatchNuevoCombo", "Enabled"); } }
protected void Detail_BatchUpdate(object sender, ASPxDataBatchUpdateEventArgs e) { DataTable dt = new DataTable(); foreach (var args in e.UpdateValues) { string OBID = args.Keys[0].ToString(); string loc1_new = args.NewValues[0].ToString(); string loc2_new = args.NewValues[1].ToString(); string desc_new = args.NewValues[2].ToString(); string qry = " UPDATE TBLSYSTEM_TEMPLATE SET DESCRIPTION = '" + desc_new + "', LOC1 = '" + loc1_new + "' , LOC2 = '" + loc2_new + "'"; qry = qry + " WHERE OBID = '" + OBID + "' "; SqlCommand cmd; cmd = new SqlCommand(qry, fgm_moduler.func_Class.conn); cmd.ExecuteNonQuery(); } }