public DataTable InsertTticol088(Ent_tticol088 obj088, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add(":T$ORNO", obj088.orno);
paramList.Add(":T$PONO", obj088.pono);
paramList.Add(":T$ITEM", obj088.item);
paramList.Add(":T$QUNE", obj088.qune);
paramList.Add(":T$LOGN", obj088.logn);
paramList.Add(":T$DATE", obj088.date);
paramList.Add(":T$PROC", obj088.proc);
paramList.Add(":T$REFCNTD", obj088.refcntd);
paramList.Add(":T$REFCNTU", obj088.refcntu);
paramList.Add(":T$OORG", obj088.oorg);
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList, 1);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "there are not results for item";
}
//return consulta;
}
catch (Exception ex)
{
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public DataTable InsertTticol088(Ent_tticol088 obj088, ref string strError)
{
DataTable retorno;
try
{
retorno = dal.InsertTticol088(obj088, ref strError);
return(retorno);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
lblError.Text = String.Empty;
lblConfirm.Text = String.Empty;
List <MyLioEntidad> LstTable = new List <MyLioEntidad>();
LstTable = (List <MyLioEntidad>)Session["LstTable"];
Session["numReg"] = LstTable.Count();
for (int i = 0; i < LstTable.Count; i++)
{
bool tticol088 = false;
var txtQuantity = Request.Form["txtQuantity-" + i].ToString().Trim();
var txtQuantityHidden = Request.Form["txtQuantityHidden-" + i].ToString().Trim();
if ((txtQuantity.Trim() != string.Empty && txtQuantity.Trim() != "0") || (txtQuantityHidden.Trim() != string.Empty && txtQuantityHidden.Trim() != "0"))
{
var orno = Convert.ToString(Session["orno"]);
var qune = double.Parse((txtQuantity.Trim() == "" ? "0" : txtQuantity.Trim()), CultureInfo.InvariantCulture.NumberFormat) == 0 ? double.Parse(txtQuantityHidden, CultureInfo.InvariantCulture.NumberFormat) : double.Parse(txtQuantity, CultureInfo.InvariantCulture.NumberFormat);
var pono = LstTable[i].PONO.ToString().Trim();
var item = LstTable[i].SITM.ToString().Trim();
var cwar = LstTable[i].CWAR.ToString().Trim();
var iswh = LstTable[i].ISWH.ToString().Trim();
var actcant = LstTable[i].ACT_CANT.ToString().Trim();
var stock = LstTable[i].STOCK.ToString().Trim();
var consultaRegistro = _idaltticol080.findRecordByOrnoPono(ref orno, ref pono, ref strError);
Ent_tticol080 data080 = new Ent_tticol080()
{
orno = orno,
pono = Convert.ToInt32(pono),
item = " " + item,
cwar = cwar,
qune = Convert.ToDecimal(qune),
logn = _operator,
proc = 2,
refcntd = 0,
refcntu = 0,
clot = " ",
oorg = "4",
pick = 1
};
Ent_tticol088 data088 = new Ent_tticol088()
{
orno = orno,
pono = Convert.ToInt32(pono),
item = " " + item,
cwar = cwar,
qune = Convert.ToDecimal(qune),
logn = _operator,
proc = 1,
refcntd = 0,
refcntu = 0,
oorg = "4"
};
if ((Convert.ToDecimal(stock.Trim()) - Convert.ToDecimal(iswh.Trim())) < Convert.ToDecimal(txtQuantityHidden.Trim()))
{
_idaltticol090.InsertTticol088(data088, ref strError);
lblError.Text += "[" + item + "] Available quantity not enough for your request <br/>";
tticol088 = true;
}
if (tticol088 == false)
{
List <Ent_tticol080> lista = new List <Ent_tticol080>();
lista.Add(data080);
var tag = String.Empty;
if (consultaRegistro.Rows.Count > 0)
{
var validUpdate = _idaltticol080.ActualizarRegistros(ref lista, ref strError, ref tag);
if (validUpdate > 0)
{
lblConfirm.Text += "[" + item + "]" + mensajes("msjupdate") + "<br/>";
divBtnGuardar.Visible = false;
}
else
{
lblError.Text += "[" + item + "]" + mensajes("errorsave") + "<br/>";
}
}
else
{
var validInsert = _idaltticol080.insertarRegistro(ref lista, ref strError, ref tag);
if (validInsert > 0)
{
lblConfirm.Text += "[" + item + "]" + mensajes("msjsave") + "<br/>";
divBtnGuardar.Visible = false;
}
else
{
lblError.Text += "[" + item + "]" + mensajes("errorsave") + "<br/>";
}
}
//}
}
}
}
txtOrder.Text = String.Empty;
divTable.InnerHtml = String.Empty;
}
