protected void Update(string _tabla, string _rowIdname, object ID, string _Campo, object Valor, bool alert)
{
UpdatePLABALRow update = new UpdatePLABALRow(_tabla, _rowIdname, ID, _Campo, Valor);
if (update.Actualizado)
{
if (alert)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "myalert", "alert('Información actualizada');", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "myalert", "alert('Error al tratar de actualizar la información.');", true);
}
}
protected void BtnEliminarItem_Click(object sender, EventArgs e)
{
string IDENDODET = HdnIDENDODET.Value;
UpdatePLABALRow update;
update = new UpdatePLABALRow("COT_ENDODET", "IDENDODET", IDENDODET, "ESTADO", false);
bool UP1 = update.Actualizado;
update = new UpdatePLABALRow("COT_ENDOSUBDET", "IDENDODET", IDENDODET, "ESTADO", false);
bool UP2 = update.Actualizado;
if (UP1 && UP2)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "myalert", "alert('el item se ha eliminado.'); window.location='" +
Page.ResolveUrl("~/View/Distribuidor/Cotizador/Formulario.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN) + "';", true);
}
}
protected void LinkBtnOrderObs_Click(object sender, EventArgs e)
{
if (LinkBtnOrderObs.Text == "Editar")
{
LinkBtnOrderObs.Text = "Actualizar";
TxtOrderObs.Enabled = true;
}
else
{
LinkBtnOrderObs.Text = "Editar";
TxtOrderObs.Enabled = false;
UpdatePLABALRow update = new UpdatePLABALRow("ECOM_PEDIDOS", "ID", ID, "OBSERVA", TxtOrderObs.Text);
if (update.Actualizado)
{
AlertInfoActualizada();
}
}
}
protected void BtnEditItemGo_Click(object sender, EventArgs e)
{
double Alto;
double Ancho;
int Cant;
bool DoUpdate = true;
if (!double.TryParse(TxtEditAlto.Text, out Alto))
{
DoUpdate = false;
}
if (!double.TryParse(TxtEditAncho.Text, out Ancho))
{
DoUpdate = false;
}
if (!int.TryParse(TxtEditCant.Text, out Cant))
{
DoUpdate = false;
}
if (DoUpdate)
{
object[] Param;
string[] ParamName;
Getm2yPerim getm2 = new Getm2yPerim(Ancho, Alto);
Param = new object[] { TxtEditRef.Text, Cant, Ancho, Alto, HdnIdItemSelected.Value, true, getm2.M2, getm2.M2 *Cant, getm2.Perimetro, getm2.Perimetro *Cant };
ParamName = new string[] { "REFERENCIA", "CANT", "ANCHO", "ALTO", "IDPEDDET", "ESTADO", "M2UN", "M2ITM", "PERIMUN", "PERIMITM" };
UpdateRow update = new UpdateRow("PLABAL", "ECOM_PEDDET", "REFERENCIA=@REFERENCIA,CANT=@CANT,ANCHO=@ANCHO,ALTO=@ALTO,M2UN=@M2UN,M2ITM=@M2ITM,PERIMUN=@PERIMUN,PERIMITM=@PERIMITM", "IDPEDDET=@IDPEDDET AND ESTADO=@ESTADO", Param, ParamName);
if (update.Actualizado)
{
PedDet.GetItem getItem = new PedDet.GetItem(ID, HdnIdItemSelected.Value, true);
if (!string.IsNullOrEmpty(HdnAddTerminologia.Value))
{
string[] Codigos = new string[] { DDLEditCREX.SelectedValue, DDLEditSEP.SelectedValue, DDLEditCRIN.SelectedValue, "909" };
if (ChkAddTerminologia.Checked)
{
/*Agregar al diccionario*/
PedDet.AddDiccionario addDiccionario = new PedDet.AddDiccionario(HdnAddTerminologia.Value, Page.User.Identity.Name, rut, Codigos);
}
/*Ingreso de uno del diccionario*/
PedSubDet.InsertSub insertSub = new PedSubDet.InsertSub(getItem.Item, Codigos, Pedido, Cliente.Margen);
if (insertSub.Insertados)
{
UpdatePLABALRow updatePLABALRow = new UpdatePLABALRow("ECOM_PEDDET", "IDPEDDET", HdnIdItemSelected.Value, "GOTFDICC", true);
}
}
else
{
/*Actualizacion*/
PedSubDet Sub;
bool IsChanged = false;
if (HdnCREXDET.Value != "")
{
IsChanged = true;
PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditCREX.SelectedValue, getItem.Item);
Sub = costos.Subdets.First();
Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETCREEX.Value, Sub.DESCRIPCION };
ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" };
update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName);
}
if (HdnCRINDET.Value != "")
{
IsChanged = true;
PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditCRIN.SelectedValue, getItem.Item);
Sub = costos.Subdets.First();
Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETCRIN.Value, Sub.DESCRIPCION };
ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" };
update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName);
}
if (HdnSEPDET.Value != "")
{
IsChanged = true;
PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditSEP.SelectedValue, getItem.Item);
Sub = costos.Subdets.First();
Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETSEP.Value, Sub.DESCRIPCION };
ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" };
update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName);
}
if (IsChanged)
{
Param = new object[] { HdnIdItemSelected.Value, ID, true };
ParamName = new string[] { "IDPEDDET", "IDPEDIDO", "ESTADO" };
SelectRows select = new SelectRows("PLABAL", "ECOM_PEDSUBDET", "DESCRIPCION", "IDPEDDET=@IDPEDDET AND IDPEDIDO=@IDPEDIDO AND ESTADO=@ESTADO", Param, ParamName);
string[] Descrip = new string[select.Datos.Rows.Count];
for (int i = 0; i < 3; i++)
{
Descrip[i] = select.Datos.Rows[i][0].ToString();
}
UpdatePLABALRow updateP = new UpdatePLABALRow("ECOM_PEDDET", "IDPEDDET", HdnIdItemSelected.Value, "DESCRIPCION", string.Join(" || ", Descrip));
}
PedDet.Calculos calculos = new PedDet.Calculos(getItem.Item, Pedido, Cliente.Margen);
}
Response.Redirect("~/View/Cliente/IngresoPedidos/Termopanel.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN);
}
}
}
