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();
}
}
