protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(User.Identity.Name))
{
FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();
}
else
{
if (!IsPostBack && !IsCallback)
{
var obec = ((BEParameters)Session["InitPar"]);
/*if (obec.Permition != "002")
* {
* FormsAuthentication.SignOut();
* FormsAuthentication.RedirectToLoginPage();
* }
* else
* {*/
gdvdln1.Columns[10].Visible = true;
gdvdln1.Columns[11].Visible = true;
//gdvdln1.Columns[12].Visible = true;
Set_Permissions();
Session["odln"] = new List <BEDocument>();
Session["dln1"] = new List <BEDocumentLine>();
Session["ordr"] = new List <BEDocument>();
Session["rdr1"] = new List <BEDocumentLine>();
Session["ocrd"] = new List <BEClient>();
Session["oitm"] = new List <BEProduct>();
hdfTemp.Add("theme", ASPxWebControl.GlobalTheme);
hdfTemp.Add("_emid", obec.U_BF_EMID);
hdfTemp.Add("_soci", obec.Socied);
hdfTemp.Add("_proj", obec.Project);
hdfTemp.Add("Reserve", string.Empty);
if (Session["cnoi"] != null)
{
ocno = (BEDocument)Session["cnoi"];
var i = 1;
ocno.Lines.ForEach(item =>
{
item.LineNum = i;
i += 1;
});
hdfTemp.Set("Reserve", ocno.Reserve);
Session["dln1"] = ocno.Lines;
gdvdln1.DataSource = ocno.Lines;
gdvdln1.DataBind();
Session["cnoi"] = null;
}
var _sd = obec.RAZON_SOCIAL;
((HtmlAnchor)BSFindControl.FindControlRecursive(Master, "Socied")).InnerText = _sd;
((HtmlAnchor)BSFindControl.FindControlRecursive(Master, "Local")).InnerText = obec.DscpLocal;
((ASPxLabel)BSFindControl.FindControlRecursive(Master, "lblTypeChange")).Text = "Tipo de Cambio: " + obec.Rate.ToString("c3");
//}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(User.Identity.Name))
{
FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();
}
else
{
if (!IsPostBack && !IsCallback)
{
var obec = ((BEParameters)Session["InitPar"]);
if (obec.Permition == "001")
{
FormsAuthentication.SignOut();
FormsAuthentication.RedirectToLoginPage();
}
else
{
Session["dln1"] = new List<BEDocumentLine>();
Session["ocrd"] = new List<BEClient>();
Session["oitm"] = new List<BEProduct>();
hdfTemp.Add("theme", ASPxWebControl.GlobalTheme);
hdfTemp.Add("_emid", obec.U_BF_EMID);
hdfTemp.Add("_soci", obec.Socied);
hdfTemp.Add("_proj", obec.Project);
hdfTemp.Add("Reserve", string.Empty);
hdfTemp.Add("_distri", string.Empty);
hdfTemp.Add("_xmsg", string.Empty);
if (Session["cnoi"] != null)
{
ocno = (BEDocument)Session["cnoi"];
var i = 1;
ocno.Lines.ForEach(item =>
{
item.LineNum = i;
i += 1;
});
hdfTemp.Set("Reserve", ocno.Reserve);
Session["dln1"] = ocno.Lines;
Session["cnoi"] = null;
}
//Init_VarSessions();
Set_Permissions();
var mmp = ((ASPxNavBar)Master.FindControl("nvbMain"));
var _sd = ((string.Compare(obec.Socied, "BT", false) == 0) ? "Botica Francesa" : "Belmay");
((HtmlAnchor)BSFindControl.FindControlRecursive(Master, "Socied")).InnerText = _sd;
((HtmlAnchor)BSFindControl.FindControlRecursive(Master, "Local")).InnerText = obec.DscpLocal;
((ASPxLabel)BSFindControl.FindControlRecursive(Master, "lblTypeChange")).Text = "Tipo de Cambio: " + obec.Rate.ToString("c3");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["print"] != null)
{
ocno = (BEDocument)Session["print"];
var obec = ((BEParameters)Session["InitPar"]);
var obrd = new BRDocument();
ReportDocument cryRpt = new ReportDocument();
var list = obrd.DXP_GET_URL_FORMATOIMPRESION(new BEParameters()
{
Socied = obec.Socied
});
//
list.Where(item => item.U_DXP_NOMBRE_PARAMET == ocno.formatoImpresion).ToList().ForEach(i =>
{
cryRpt.Load(i.U_DXP_VALOR_PARAMETR);
});
string var1 = ocno.DocEntry.ToString();//Request.QueryString["docEnry"];
String strServer = "SRV-SQL01";
String strDatabase = obec.CompanyDB;
String strUserID = "sa";
String strPwd = "MPP@SW0RD";
CrystalReportViewer1.Width = new Unit("2000px");
CrystalReportViewer1.Height = new Unit("2000px");
cryRpt.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd);
cryRpt.SetParameterValue(0, var1);
CrystalReportViewer1.ReportSource = cryRpt;
cryRpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Crystal");
Response.End();
}
///////////////////////////////////////////////////////////////////////
//ReportDocument cryRpt = new ReportDocument();
////string rpt = Request.QueryString["rpt"];
//cryRpt.Load(Server.MapPath("FacturaOdex.rpt"));
//string var1 = "18";//Request.QueryString["docEnry"];
//String strServer = "SRV-SQL01";
//String strDatabase = "SBO_DEXO";
//String strUserID = "sa";
//String strPwd = "MPP@SW0RD";
//CrystalReportViewer1.Width = new Unit("2000px");
//CrystalReportViewer1.Height = new Unit("2000px");
//cryRpt.DataSourceConnections[0].SetConnection(strServer, strDatabase, strUserID, strPwd);
//cryRpt.SetParameterValue(0, var1);
//CrystalReportViewer1.ReportSource = cryRpt;
//cryRpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, "Crystal");
//Response.End();
}
private string Save()
{
var _err = string.Empty;
if (((List <BEDocumentLine>)Session["rin1"]).Count == 0)
{
_err = BSMessage.MsExLinesCount;
}
//if (cbeOwnerCode.Value == null)
// _err = BSMessage.MsExLinesCount;
if (string.IsNullOrWhiteSpace(_err))
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
obj.Socied = obec.Socied;
obj.DocDate = Convert.ToDateTime(dteDocDate.Text);
obj.CardCode = txtCardCode.Text;
obj.CardName = bteCardName.Text.Trim();
obj.LicTradNum = bteLicTradNum.Text.Trim();
obj.U_BPP_MDTD = cbbU_BPP_MDTD.Value.ToString();
obj.U_BPP_MDSD = txtU_BPP_MDSD.Text;
obj.U_BPP_MDCD = txtU_BPP_MDCD.Text;
obj.NumAtCard = NumAtCard.Text;
obj.Currency = cbbDocCur.Value.ToString();
obj.DiscPrcntTotal = Convert.ToDecimal(alphanumeric(txtDiscPrcntTotal.Value.ToString()));
obj.TotalExpns = Convert.ToDecimal(alphanumeric(txtTotalExpns.Value.ToString()));
obj.SlpCode = Convert.ToInt16(cbeSalesPerson.Value);
obj.OwnerCode = Convert.ToInt32(cbeOwnerCode.Value);
obj.GroupNum = Convert.ToInt16(cbbGroupNum.Value);
obj.Comments = mmoComments.Text;
if (string.IsNullOrEmpty(cbbPersonContact.Value.ToString()))
{
obj.CntctCode = 0;
}
else
{
obj.CntctCode = Convert.ToInt32(cbbPersonContact.Value.ToString());
}
//obj.U_BF_PED_ORIG = txtU_BF_PED_ORIG0.Text;
obj.Project = ((BEParameters)Session["InitPar"]).Project;
//obj.U_BF_PickRmrk = User.Identity.Name;
//Qua_BatchNum();
obj.Lines = ((List <BEDocumentLine>)Session["rin1"]);
obj.Reserve = hdfTemp.Get("Reserve").ToString();
using (var obrd = new BRDocument())
{
obrd.SavePurchaseCreditNote(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
_err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKS#{0}#{1}", obj.DocEntry, obj.DocNum);
}
return(_err);
}
private string Cancel()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
obj.Socied = obec.Socied;
obj.DocEntry = Convert.ToInt32(txtDocEntry.Text);
using (var obrd = new BRDocument())
{
obrd.CancelDeliveryNote(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "OKOC";
return(_err);
}
private string Save()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
obj.CardCode = bteCustomer.Text;
obj.DocDate = Convert.ToDateTime(txtcreateDate1.Text);
obj.Lineas = ((List <BEDocument>)Session["jdt1"]);
obj.Credit = Convert.ToDecimal(txtCred.Text);
obj.Debit = Convert.ToDecimal(txtDeb.Text);
obj.Socied = obec.Socied;
using (var obrd = new BRDocument())
{
obrd.SaveRecon(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "OKBP";
return(_err);
}
private string Payment(int DocEntry)
{
var obec = ((BEParameters)Session["InitPar"]);
var item = ((List <BEDocument>)Session["dvpp"]).Where(i => i.DocEntry == DocEntry).ElementAt(0);
var obj = new BEDocument();
obj.Socied = obec.Socied;
obj.DocEntry = DocEntry;
obj.DocDate = DateTime.Today;
obj.CardCode = item.CardCode;
obj.CardName = item.CardName;
if (pgcPayment.ActiveTabIndex == 0)
{
obj.MedPayment = "EF";
obj.CashAccount = (obec.Socied == "BT") ? "_SYS00000003803" : "_SYS00000003232";
obj.CashSum = Convert.ToDecimal(txtSalEfe.Value);
}
else
{
obj.MedPayment = "TC";
var _stc = cbbCreditCard.Value.ToString().Split('_');
obj.CreditCard = Convert.ToInt16(_stc[0]);
obj.CashAccount = "_" + _stc[1];
obj.CashSum = Convert.ToDecimal(txtSalTacre.Value);
var _ccn = ("0000000000000" + txtCardNum.Text);
obj.CreditCardNumber = Right(_ccn, 13);
obj.VoucherNum = txtCardNum.Text;
}
obj.Project = ((BEParameters)Session["InitPar"]).Project;
obj.PaidToDate = item.PaidToDate + obj.CashSum;
obj.PendingBal = item.DocTotal - obj.PaidToDate;
using (var obrd = new BRDocument())
{
obrd.SavePayment(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKP#{0}#{1}#{2}", DocEntry, obj.PaidToDate, obj.PendingBal);
return(_err);
}
private string Save()
{
var _err = string.Empty;
var MSJ = "";
var band = false;
if (((List <BEDocumentLine>)Session["dln1"]).Count == 0)
{
_err = BSMessage.MsExLinesCount;
}
if (string.IsNullOrWhiteSpace(_err))
{
var day = DateTime.Today;
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
obj.Socied = obec.Socied;
obj.DocDate = Convert.ToDateTime(day);
obj.TaxDate = Convert.ToDateTime(day);
obj.CardCode = bteCustomer.Text;
obj.CardName = txtCustomerName.Text;
obj.U_BPP_MDTO = txtidllamada.Text;
obj.Project = ((BEParameters)Session["InitPar"]).Project;
List <BEProduct> listSN = SerialNumber();
obj.Lines = ((List <BEDocumentLine>)Session["dln1"]);
using (var obrd = new BRDocument())
{
obrd.SaveDeliveryNote2(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
_err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKS#{0}#{1}", obj.DocEntry, obj.DocNum);
}
return(_err);
}
private string Payment()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
obj.Socied = obec.Socied;
obj.DocEntry = Convert.ToInt32(txtDocEntry.Value);
obj.DocDate = DateTime.Today;
obj.CardCode = txtCardCode.Text;
obj.CardName = bteCardName.Text.Trim();
if (pgcPayment.ActiveTabIndex == 0)
{
obj.MedPayment = "EF";
obj.CashAccount = "_SYS00000003803";
obj.CashSum = Convert.ToDecimal(txtSalEfe.Value);
}
else
{
obj.MedPayment = "TC";
var _stc = cbbCreditCard.Value.ToString().Split('_');
obj.CreditCard = Convert.ToInt16(_stc[0]);
obj.CashAccount = "_" + _stc[1];
obj.CashSum = Convert.ToDecimal(txtSalTacre.Value);
var _ccn = ("0000000000000" + txtCardNum.Text);
obj.CreditCardNumber = Right(_ccn, 13);
obj.VoucherNum = txtCardNum.Text;
}
obj.Project = ((BEParameters)Session["InitPar"]).Project;
obj.PaidToDate = Convert.ToDecimal(txtPaidToDate.Value) + obj.CashSum;
obj.PendingBal = Convert.ToDecimal(txtDocTotal.Value) - obj.PaidToDate;
using (var obrd = new BRDocument())
{
obrd.SavePayment(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKP#{0}#{1}", obj.PaidToDate, obj.PendingBal);
return(_err);
}
private string Cancel()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
if (rbtnType.Value.ToString() == "Y")
{
obj.DocEntry = Convert.ToInt32(txtDocNum.Text);
}
else
{
obj.DocEntry = Convert.ToInt32(txtDocNum2.Text);
}
using (var obrd = new BRDocument())
{
obrd.CancelPayment(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "CANC";
//Init_VarSessions();
return(_err);
}
private string Notes(string par)
{
var obj = new BEDocument();
obj.DocEntry = Convert.ToInt32(txtDocEntry.Value);
obj.DocNum = Convert.ToInt32(txtDocNum.Value);
obj.DocDate = Convert.ToDateTime(dteDocDate.Text);
obj.CardCode = txtCardCode.Text;
obj.CardName = bteCardName.Text.Trim();
obj.LicTradNum = bteLicTradNum.Text.Trim();
obj.NumAtCard = txtNumAtCard.Text;
obj.DiscPrcntTotal = Convert.ToDecimal(txtDiscPrcntTotal.Value);
obj.TotalExpns = Convert.ToDecimal(txtTotalExpns.Value);
obj.SlpCode = Convert.ToInt16(cbeSalesPerson.Value);
obj.OwnerCode = Convert.ToInt32(cbeOwnerCode.Value);
obj.GroupNum = Convert.ToInt16(cbbGroupNum.Value);
obj.Comments = mmoComments.Text;
obj.Reserve = "Y";
obj.Lines = ((List <BEDocumentLine>)Session["inv1"]).Where(i => i.LineStatus != "C").ToList();
obj.Lines.ForEach(item =>
{
item.Quantity = item.OpenQty;
item.BaseType = Convert.ToInt32(item.ObjType);
item.BaseEntry = item.DocEntry;
item.BaseLine = item.LineNum - 1;
item._Quantity = item.Quantity;
item.BatchNum = item.BatchNums;
});
Session["cnoi"] = obj;
var _msg = "OKCN";
if (par == "DlNote")
{
_msg = "OKDN";
}
return(_msg);
}
private string SaveTS()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEDocument();
obj.CardCode = bteCustomer.Text;
obj.CardName = txtCustomerName.Text;
obj.Address = txtAddress.Text;
obj.DocDate = Convert.ToDateTime(txtcreateDate1.Text);
obj.SlpCode = Convert.ToInt32(cbeOwnerCode.Value);
obj.AlmacenO = cbbalmacenorigen.Value.ToString();
obj.AlmacenD = cbbalmacendestino.Value.ToString();
obj.Lines = ((List <BEDocumentLine>)Session["wtr1"]);
using (var obrd = new BRDocument())
{
obrd.SaveTransferenciaStock(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKBP#{0}#{1}", obj.DocEntry, obj.DocNum);
//Init_VarSessions();
return(_err);
}
public static bool Get_Mobility(BEDocument obj, List <BEParMovility> prmv)
{
bool mvl = false;
if (string.Compare(obj.U_BIZ_LUEN, "006", false) == 0 && obj.DocTotal > 0)
{
var count = prmv.Where(lobj => string.Compare(lobj.U_BF_CODI, obj.U_BIZ_CODI, false) == 0 &&
string.Compare(lobj.U_BF_DIA, "Vacio", false) == 0 && obj.DocTotal >= lobj.U_BF_TOTA).Count();
if (count == 0)
{
var per = CultureInfo.GetCultureInfo("es-PE");
int day = (int)obj.DocDueDate.DayOfWeek;
string dayn = per.DateTimeFormat.DayNames[day];
count = prmv.Where(lobj => string.Compare(lobj.U_BF_CODI, obj.U_BIZ_CODI, false) == 0 &&
string.Compare(lobj.U_BF_DIA.ToUpper(), dayn.ToUpper(), false) == 0 && obj.DocTotal > 0 && obj.DocTotal < 200).Count();
if (count == 0)
{
mvl = true;
}
}
}
return(mvl);
}
protected void gdvrin1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("QK"))
{
var obep = new BEParameters()
{
Socied = obec.Socied,
CardCode = txtCardCode.Text,
PriceList = Convert.ToInt16(cbbListNum.Value),
WhsCode = obec.WhsCode,
ParValue = e.Parameters.Replace("QK:", "").ToUpper().Replace("K", "").Trim(),
ColumnIndex = 0,
Sw = 2
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_KITS(obep);
var _qtk = (chkKit.Checked) ? Convert.ToInt32(txtQuantityKit.Text) : Convert.ToInt32(txtQKit.Text);
olst.ForEach(item =>
{
var line = new BEDocumentLine()
{
ItemCode = item.ItemCode,
ItemName = item.ItemName,
Quantity = _qtk,
PriceBefDi = item.PriceBefDi,
DiscPrcnt = item.DiscPrcnt,
Price = item.Price,
LineTotal = Convert.ToDecimal(_qtk * item.Price),
GTotal = Convert.ToDecimal(_qtk * item.PriceVat),
BatchNum = item.BatchNum,
WhsCode = obec.WhsCode,
U_BF_CodKit = item.U_BF_CodKit
};
((List <BEDocumentLine>)Session["rin1"]).Add(line);
});
Set_LineNum();
}
else if (e.Parameters.Contains("UPDTPRICE"))
{
var _spl = e.Parameters.Split(':');
((List <BEDocumentLine>)Session["rin1"]).Where(i => (i.TreeType == "N" && i.Father == _spl[5]))
.ToList().ForEach(item =>
{
item.PriceBefDi = Convert.ToDecimal(_spl[1]);
item.Price = Convert.ToDecimal(_spl[2]);
item.LineTotal = Convert.ToDecimal(_spl[3]);
item.GTotal = Convert.ToDecimal(_spl[4]);
item.Quantity = Convert.ToInt32(_spl[6]);
});
}
else if (e.Parameters.Contains("CLR"))
{
Session["cnoi"] = null;
ocno = new BEDocument();
((List <BEDocumentLine>)Session["rin1"]).Clear();
}
else if (e.Parameters.Contains("LM"))
{
var band = true;
var suprimir = "";
var _spl = e.Parameters.Split(':');
var padre = _spl[1].Split(',');
var obep = new BEParameters()
{
Socied = obec.Socied,
ItemCode = Convert.ToString(padre[0])
};
var obrd = new BRDocument();
var olist = obrd.Get_ListdeMateriales(obep);
if (olist.Count != 0)
{
olist.ForEach(item =>
{
obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = "",
PriceList = Convert.ToInt16(_spl[2]),
WhsCode = item.Warehouse,
ParValue = item.Code,
ColumnIndex = 0,
Sw = 2,
Kit = false
};
var olst = obrd.Get_OSCSP_OITM_P(obep);
var line = new BEDocumentLine();
if (band)
{
line.ItemCode = padre[0];
line.ItemName = padre[1];
line.PriceBefDi = Convert.ToDecimal(padre[3]);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(padre[4]);
line.Price = Convert.ToDecimal(padre[5]);
line.LineTotal = Convert.ToDecimal(padre[5]);
line.GTotal = Convert.ToDecimal(padre[6]);
line.IssueMthd = padre[7];
line.WhsCode = obec.WhsCode;
line.TreeType = "S";
line.Father = padre[0];
line.NumInSale = Convert.ToInt32(padre[8]);
band = false;
suprimir = item.SUPRIMIR_MATERIALES;
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
}
olst.ForEach(a =>
{
var line2 = new BEDocumentLine();
line2.ItemCode = a.ItemCode;
line2.ItemName = a.ItemName;
line2.PriceBefDi = a.PriceBefDi;
line2.Quantity = item.Quantity;
line2.DiscPrcnt = a.DiscPrcnt;
line2.Price = a.PriceBefDi - ((a.PriceBefDi * a.DiscPrcnt) / 100);
line2.LineTotal = item.Quantity * a.Price;
line2.GTotal = item.Quantity * a.PriceVat;
line2.IssueMthd = a.IssueMthd;
line2.WhsCode = obec.WhsCode;
line2.TreeType = "I";
line2.Father = padre[0];
line2.NumInSale = item.Quantity;
((List <BEDocumentLine>)Session["rin1"]).Add(line2);
Set_LineNum();
});
});
if (suprimir == "N")
{
((List <BEDocumentLine>)Session["rin1"]).Where(i => i.TreeType == "S" && i.Father == padre[0]).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
else if (suprimir == "Y")
{
((List <BEDocumentLine>)Session["rin1"]).Where(i => i.TreeType == "I" && i.Father == padre[0]).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
}
else
{
var line = new BEDocumentLine();
//return;
line.ItemCode = padre[0];
line.ItemName = padre[1];
line.PriceBefDi = Convert.ToDecimal(padre[3]);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(padre[4]);
line.Price = Convert.ToDecimal(padre[5]);
line.LineTotal = Convert.ToDecimal(padre[5]);
line.GTotal = Convert.ToDecimal(padre[6]);
line.IssueMthd = padre[7];
line.WhsCode = obec.WhsCode;
line.TreeType = "N";
line.Father = padre[0];
line.NumInSale = Convert.ToInt32(padre[8]);
band = false;
//suprimir = item.SUPRIMIR_MATERIALES;
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
}
}
else if (e.Parameters.Contains("QTY"))
{
var _spl = e.Parameters.Split(':');
var band = true;
((List <BEDocumentLine>)Session["rin1"]).Where(i => ((i.TreeType == "I" || i.TreeType == "S" || i.TreeType == "N") && i.Father == _spl[2]))
.ToList().ForEach(item =>
{
band = false;
if (item.TreeType == "N")
{
item.Quantity = Convert.ToInt32(_spl[1]);
item.LineTotal = item.Quantity * item.Price;
item.GTotal = item.LineTotal * Convert.ToDecimal(1.18);
}
else if (item.TreeType == "S" || item.TreeType == "I")
{
if (item.TreeType == "S")
{
item.Quantity = Convert.ToInt32(_spl[1]);
item.LineTotal = item.Quantity * item.Price;
item.GTotal = item.LineTotal * Convert.ToDecimal(1.18);
}
else if (item.TreeType == "I")
{
item.Quantity = Convert.ToInt32(item.NumInSale) * Convert.ToInt32(_spl[1]);
item.LineTotal = item.Quantity * item.Price;
item.GTotal = item.LineTotal * Convert.ToDecimal(1.18);
}
}
});
if (band)
{
return;
}
}
else if (e.Parameters.Contains("ADDPRODUCT"))
{
var _spl = e.Parameters.Split(':');
var obep = new BEParameters();
var obrd = new BRDocument();
var suprimir = "";
obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = "",
PriceList = Convert.ToInt16(_spl[2]),
WhsCode = obec.WhsCode,
ParValue = _spl[1],
ColumnIndex = 0,
Sw = 2,
Kit = false,
ItemCode = _spl[1]
};
var articulo = obrd.Get_OSCSP_OITM_P(obep);
var listamateriales = obrd.Get_ListdeMateriales(obep);
if (listamateriales.Count == 0)
{
articulo.ForEach(item =>
{
var line = new BEDocumentLine();
line.ItemCode = item.ItemCode;
line.ItemName = item.ItemName;
line.PriceBefDi = Convert.ToDecimal(item.PriceBefDi);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(item.DiscPrcnt);
line.Price = Convert.ToDecimal(item.Price);
line.LineTotal = Convert.ToDecimal(item.Price);
line.GTotal = Convert.ToDecimal(item.PriceVat);
line.IssueMthd = item.IssueMthd;
line.WhsCode = obec.WhsCode;
line.TreeType = "N";
line.Father = item.ItemCode;
line.NumInSale = Convert.ToInt32(item.NumInSale);
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
});
}
else
{
articulo.ForEach(i =>
{
var line = new BEDocumentLine();
line.ItemCode = i.ItemCode;
line.ItemName = i.ItemName;
line.PriceBefDi = Convert.ToDecimal(i.PriceBefDi);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(i.DiscPrcnt);
line.Price = Convert.ToDecimal(i.Price);
line.LineTotal = Convert.ToDecimal(i.Price);
line.GTotal = Convert.ToDecimal(i.PriceVat);
line.IssueMthd = i.IssueMthd;
line.WhsCode = obec.WhsCode;
line.TreeType = "S";
line.Father = i.ItemCode;
line.NumInSale = Convert.ToInt32(i.NumInSale);
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
listamateriales.ForEach(j =>
{
obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = "",
PriceList = Convert.ToInt16(_spl[2]),
WhsCode = obec.WhsCode,
ParValue = j.Code,
ColumnIndex = 0,
Sw = 2,
Kit = false
};
var articulosdelista = obrd.Get_OSCSP_OITM_P(obep);
suprimir = j.SUPRIMIR_MATERIALES;
articulosdelista.ForEach(a =>
{
var line2 = new BEDocumentLine();
line2.ItemCode = a.ItemCode;
line2.ItemName = a.ItemName;
line2.PriceBefDi = a.PriceBefDi;
line2.Quantity = j.Quantity;
line2.DiscPrcnt = a.DiscPrcnt;
line2.Price = a.PriceBefDi - ((a.PriceBefDi * a.DiscPrcnt) / 100);
line2.LineTotal = j.Quantity * a.Price;
line2.GTotal = j.Quantity * a.PriceVat;
line2.IssueMthd = a.IssueMthd;
line2.WhsCode = obec.WhsCode;
line2.TreeType = "I";
line2.Father = i.ItemCode;
line2.NumInSale = j.Quantity;
((List <BEDocumentLine>)Session["rin1"]).Add(line2);
Set_LineNum();
});
});
if (suprimir == "N")
{
((List <BEDocumentLine>)Session["rin1"]).Where(a => (a.TreeType == "S" && a.Father == i.ItemCode)).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
else if (suprimir == "Y")
{
((List <BEDocumentLine>)Session["rin1"]).Where(a => (a.TreeType == "I" && a.Father == i.ItemCode)).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
});
}
}
else if (e.Parameters.Contains("SRCH"))
{
var obep = new BEParameters()
{
Socied = obec.Socied,
DocEntry = Convert.ToInt32(txtDocEntry.Text)
};
var obrd = new BRDocument();
Session["rin1"] = obrd.Get_OSCSP_SRCH_RPC1(obep);
}
gdvrin1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["rin1"]).Sum(item => Math.Round(item.LineTotal, 2));
gdvrin1.CancelEdit();
gdvrin1.DataSource = ((List <BEDocumentLine>)Session["rin1"]);
gdvrin1.DataBind();
}
protected void gdvrin1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("UPDTPRICE"))
{
var _spl = e.Parameters.Split(':');
((List <BEDocumentLine>)Session["rin1"]).Where(i => (i.TreeType == "N" && i.Father == _spl[5]))
.ToList().ForEach(item =>
{
item.PriceBefDi = Convert.ToDecimal(_spl[1]);
item.Price = Convert.ToDecimal(_spl[2]);
item.LineTotal = Convert.ToDecimal(_spl[3]);
item.GTotal = Convert.ToDecimal(_spl[4]);
item.Quantity = Convert.ToDecimal(_spl[6]);
});
}
else if (e.Parameters.Contains("CLR"))
{
Session["cnoi"] = null;
ocno = new BEDocument();
((List <BEDocumentLine>)Session["rin1"]).Clear();
}
else if (e.Parameters.Contains("LM"))
{
var band = true;
var suprimir = "";
var _spl = e.Parameters.Split(':');
var padre = _spl[1].Split(',');
var obep = new BEParameters()
{
Socied = obec.Socied,
ItemCode = Convert.ToString(padre[0])
};
var obrd = new BRDocument();
var olist = obrd.Get_ListdeMateriales(obep);
if (olist.Count != 0)
{
olist.ForEach(item =>
{
obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = "",
PriceList = Convert.ToInt16(_spl[2]),
WhsCode = cbbWareHouse.Value.ToString(),
ParValue = item.Code,
ColumnIndex = 0,
Sw = 2,
Kit = false,
Moneda = cbbDocCur.Value.ToString(),
DateIn = Convert.ToDateTime(dteDocDate.Text),
Descripcion = "",
SerieMaqr = ""
};
var olst = obrd.Get_OSCSP_OITM_P(obep);
var line = new BEDocumentLine();
if (band)
{
line.ItemCode = padre[0];
line.ItemName = padre[1];
line.PriceBefDi = Convert.ToDecimal(padre[3]);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(padre[4]);
line.Price = Convert.ToDecimal(padre[5]);
line.LineTotal = Convert.ToDecimal(padre[5]);
line.GTotal = Convert.ToDecimal(padre[6]);
line.IssueMthd = padre[7];
line.WhsCode = obec.WhsCode;
line.TreeType = "S";
line.Father = padre[0];
line.NumInBuy = Convert.ToInt32(padre[8]);
line.ActivoC = padre[9];
line.ActivoS = padre[10];
line.InvntItem = padre[11];
line.LastPurCur = padre[12];
band = false;
suprimir = item.SUPRIMIR_MATERIALES;
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
}
olst.ForEach(a =>
{
var line2 = new BEDocumentLine();
line2.ItemCode = a.ItemCode;
line2.ItemName = a.ItemName;
line2.PriceBefDi = a.PriceBefDi;
line2.Quantity = item.Quantity;
line2.DiscPrcnt = a.DiscPrcnt;
line2.Price = a.PriceBefDi - ((a.PriceBefDi * a.DiscPrcnt) / 100);
line2.LineTotal = item.Quantity * a.Price;
line2.GTotal = item.Quantity * a.PriceVat;
line2.IssueMthd = a.IssueMthd;
line2.WhsCode = obec.WhsCode;
line2.TreeType = "I";
line2.Father = padre[0];
line2.NumInBuy = item.Quantity;
line2.ActivoC = a.ActivoC;
line2.ActivoS = a.ActivoS;
line2.InvntItem = a.InvntItem;
line2.LastPurCur = a.LastPurCur;
((List <BEDocumentLine>)Session["rin1"]).Add(line2);
Set_LineNum();
});
});
if (suprimir == "N")
{
((List <BEDocumentLine>)Session["rin1"]).Where(i => i.TreeType == "S" && i.Father == padre[0]).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
else if (suprimir == "Y")
{
((List <BEDocumentLine>)Session["rin1"]).Where(i => i.TreeType == "I" && i.Father == padre[0]).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
}
else
{
var line = new BEDocumentLine();
//return;
line.ItemCode = padre[0];
line.ItemName = padre[1];
line.PriceBefDi = Convert.ToDecimal(padre[3]);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(padre[4]);
line.Price = Convert.ToDecimal(padre[5]);
line.LineTotal = Convert.ToDecimal(padre[5]);
line.GTotal = Convert.ToDecimal(padre[6]);
line.IssueMthd = padre[7];
line.WhsCode = obec.WhsCode;
line.TreeType = "N";
line.Father = padre[0];
line.NumInBuy = Convert.ToInt32(padre[8]);
line.ActivoC = padre[9];
line.ActivoS = padre[10];
line.InvntItem = padre[11];
line.LastPurCur = padre[12];
band = false;
//suprimir = item.SUPRIMIR_MATERIALES;
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
}
}
else if (e.Parameters.Contains("QTY"))
{
var _spl = e.Parameters.Split(':');
var band = true;
((List <BEDocumentLine>)Session["rin1"]).Where(i => ((i.TreeType == "I" || i.TreeType == "S" || i.TreeType == "N") && i.Father == _spl[2]))
.ToList().ForEach(item =>
{
band = false;
if (item.TreeType == "N")
{
item.Quantity = Convert.ToDecimal(_spl[1]);
item.LineTotal = item.Quantity * item.Price;
item.GTotal = item.LineTotal * Convert.ToDecimal(1.18);
}
else if (item.TreeType == "S" || item.TreeType == "I")
{
if (item.TreeType == "S")
{
item.Quantity = Convert.ToDecimal(_spl[1]);
item.LineTotal = item.Quantity * item.Price;
item.GTotal = item.LineTotal * Convert.ToDecimal(1.18);
}
else if (item.TreeType == "I")
{
item.Quantity = Convert.ToDecimal(item.NumInBuy) * Convert.ToDecimal(_spl[1]);
item.LineTotal = item.Quantity * item.Price;
item.GTotal = item.LineTotal * Convert.ToDecimal(1.18);
}
}
});
if (band)
{
return;
}
}
else if (e.Parameters.Contains("ADDPRODUCT"))
{
var _spl = e.Parameters.Split(':');
var obep = new BEParameters();
var obrd = new BRDocument();
var suprimir = "";
obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = "",
PriceList = Convert.ToInt16(_spl[2]),
WhsCode = cbbWareHouse.Value.ToString(),
ParValue = _spl[1],
ColumnIndex = 0,
Sw = 2,
Kit = false,
ItemCode = _spl[1],
Moneda = cbbDocCur.Value.ToString(),
DateIn = Convert.ToDateTime(dteDocDate.Text),
Descripcion = "",
SerieMaqr = ""
};
var articulo = obrd.Get_OSCSP_OITM_P(obep);
var listamateriales = obrd.Get_ListdeMateriales(obep);
if (listamateriales.Count == 0)
{
articulo.ForEach(item =>
{
var line = new BEDocumentLine();
line.ItemCode = item.ItemCode;
line.ItemName = item.ItemName;
line.PriceBefDi = Convert.ToDecimal(item.PriceBefDi);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(item.DiscPrcnt);
line.Price = Convert.ToDecimal(item.Price);
line.LineTotal = Convert.ToDecimal(item.Price);
line.GTotal = Convert.ToDecimal(item.PriceVat);
line.IssueMthd = item.IssueMthd;
line.WhsCode = obec.WhsCode;
line.TreeType = "N";
line.Father = item.ItemCode;
line.NumInBuy = Convert.ToInt32(item.NumInBuy);
line.ActivoC = item.ActivoC;
line.ActivoS = item.ActivoS;
line.InvntItem = item.InvntItem;
line.LastPurCur = item.LastPurCur;
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
});
}
else
{
articulo.ForEach(i =>
{
var line = new BEDocumentLine();
line.ItemCode = i.ItemCode;
line.ItemName = i.ItemName;
line.PriceBefDi = Convert.ToDecimal(i.PriceBefDi);
line.Quantity = 1;
line.DiscPrcnt = Convert.ToDecimal(i.DiscPrcnt);
line.Price = Convert.ToDecimal(i.Price);
line.LineTotal = Convert.ToDecimal(i.Price);
line.GTotal = Convert.ToDecimal(i.PriceVat);
line.IssueMthd = i.IssueMthd;
line.WhsCode = obec.WhsCode;
line.TreeType = "S";
line.Father = i.ItemCode;
line.NumInBuy = Convert.ToInt32(i.NumInBuy);
line.ActivoC = i.ActivoC;
line.ActivoS = i.ActivoS;
line.InvntItem = i.InvntItem;
line.LastPurCur = i.LastPurCur;
((List <BEDocumentLine>)Session["rin1"]).Add(line);
Set_LineNum();
listamateriales.ForEach(j =>
{
obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = "",
PriceList = Convert.ToInt16(_spl[2]),
WhsCode = cbbWareHouse.Value.ToString(),
ParValue = j.Code,
ColumnIndex = 0,
Sw = 2,
Kit = false,
Moneda = cbbDocCur.Value.ToString(),
DateIn = Convert.ToDateTime(dteDocDate.Text),
Descripcion = "",
SerieMaqr = ""
};
var articulosdelista = obrd.Get_OSCSP_OITM_P(obep);
suprimir = j.SUPRIMIR_MATERIALES;
articulosdelista.ForEach(a =>
{
var line2 = new BEDocumentLine();
line2.ItemCode = a.ItemCode;
line2.ItemName = a.ItemName;
line2.PriceBefDi = a.PriceBefDi;
line2.Quantity = j.Quantity;
line2.DiscPrcnt = a.DiscPrcnt;
line2.Price = a.PriceBefDi - ((a.PriceBefDi * a.DiscPrcnt) / 100);
line2.LineTotal = j.Quantity * a.Price;
line2.GTotal = j.Quantity * a.PriceVat;
line2.IssueMthd = a.IssueMthd;
line2.WhsCode = obec.WhsCode;
line2.TreeType = "I";
line2.Father = i.ItemCode;
line2.NumInBuy = j.Quantity;
line2.ActivoC = a.ActivoC;
line2.ActivoS = a.ActivoS;
line2.InvntItem = a.InvntItem;
line2.LastPurCur = a.LastPurCur;
((List <BEDocumentLine>)Session["rin1"]).Add(line2);
Set_LineNum();
});
});
if (suprimir == "N")
{
((List <BEDocumentLine>)Session["rin1"]).Where(a => (a.TreeType == "S" && a.Father == i.ItemCode)).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
else if (suprimir == "Y")
{
((List <BEDocumentLine>)Session["rin1"]).Where(a => (a.TreeType == "I" && a.Father == i.ItemCode)).ToList().ForEach(x =>
{
x.PriceBefDi = Convert.ToDecimal(0.00);
x.Price = Convert.ToDecimal(0.00);
x.LineTotal = Convert.ToDecimal(0.00);
x.GTotal = Convert.ToDecimal(0.00);
});
}
});
}
}
else if (e.Parameters.Contains("SRCH"))
{
var obep = new BEParameters()
{
Socied = obec.Socied,
DocEntry = Convert.ToInt32(txtDocEntry.Text)
};
var obrd = new BRDocument();
Session["rin1"] = obrd.Get_OSCSP_SRCH_RPC1(obep);
}
gdvrin1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["rin1"]).Sum(item => Math.Round(item.LineTotal, 2));
gdvrin1.CancelEdit();
gdvrin1.DataSource = ((List <BEDocumentLine>)Session["rin1"]);
gdvrin1.DataBind();
}
private string Payment()
{
var obec = ((BEParameters)Session["InitPar"]);
var obrd = new BRDocument();
var obj = new BEDocument();
obj.Socied = obec.Socied;
obj.Comments = rbtnType.Value.ToString();
obj.DocEntry = Convert.ToInt32(txtNroOperacion.Value);
obj.TaxDate = Convert.ToDateTime(txtdocDate1.Text);
obj.DocDueDate = Convert.ToDateTime(txtcloseDate1.Text);
obj.DocDate = Convert.ToDateTime(txtcreateDate1.Text);
obj.CardCode = bteCustomer.Text;
obj.CardName = txtCustomerName.Text.Trim();
obj.CntctCode = Convert.ToInt32(txtcontctCode1.Value);
obj.Project = cbbProyecto.Value.ToString();
obj.Address2 = cbbMedioPago.Value.ToString();
obj.Address = cbbAddress.Text;
obj.DocCur = cbbDocCur.Value.ToString();
obj.Active = checkPagoCuenta.Value.ToString();
obj.DiscSum = Convert.ToDecimal(txtDocTotalCP.Text);
obj.DiscPrcntTotal = Convert.ToDecimal(txtimportetotal.Text);
obj.DpmAmnt = Convert.ToDecimal(txtimportetotal2.Text);
//obj.Project = ((BEParameters)Session["InitPar"]).Project;
obj.Lineas = ((List <BEDocument>)Session["tecn"]);
obj.CuentasPago = ((List <BECuentasPago>)Session["rct4"]);
var obep = new BEParameters()
{
Socied = obec.Socied
};
var olst = obrd.GET_CUENTAS_PAGO(obep);
if (checkpagoefe.Value.ToString() == "Y")
{
olst.Where(i => i.Project == obec.Project).ToList().ForEach(item => {
if (cbbCurPagoEfe.Value.ToString() == item.ActCurr)
{
obj.CashAccount = item.AcctCode;
}
});
obj.MedPayment = "EF";
obj.DocCur = cbbCurPagoEfe.Value.ToString();
obj.CashSum = Convert.ToDecimal(txtSalEfe2.Value);
}
if (checkpagotar.Value.ToString() == "Y")
{
obj.MedPayment2 = "TC";
obj.DocDate1 = Convert.ToDateTime(dteDocDateTarj.Text);
var _stc = cbbCreditCard1.Value.ToString().Split('_');
obj.CreditCard = Convert.ToInt16(_stc[0]);
obj.NumAtCard = txtNumOperacion.Text;
obj.CashAccount2 = _stc[1];
obj.CashSum2 = Convert.ToDecimal(txtSalTar2.Value);
var _ccn = ("0000000000000" + txtNumTarjeta.Text);
obj.DocCur2 = cbbCurPagoTar.Value.ToString();
obj.CreditCardNumber = Right(_ccn, 13);
obj.VoucherNum = txtNumTarjeta.Text;
}
if (checkpagotrans.Value.ToString() == "Y")
{
obj.MedPayment3 = "TR";
obj.DocCur3 = cbbCurPagoTrans.Value.ToString();
obj.CashAccount3 = cbbCuentaTrans.Value.ToString();;
obj.CashSum3 = Convert.ToDecimal(txtSalTrans2.Value);
obj.DocDate3 = Convert.ToDateTime(dteDocDateTrans.Text);
obj.NumAtCard3 = txtNumOperacion2.Text;
}
obrd.SavePayment2(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKBP#{0}#{1}", obj.DocNum, obj.DocEntry);
return(_err);
}