protected void cbbUsuario_Callback(object sender, CallbackEventArgsBase e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameter.Contains("GET"))
{
var obj = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
U_DXP_SEDE = obec.U_DXP_SEDE,
};
var obrd = new BRDocument();
var olst = obrd.USUARIOS(obj);
if (olst.Count != 0)
{
cbbUsuario.Items.Add("", 0);
olst.ForEach(ite =>
{
cbbUsuario.Items.Add(ite.UserName, ite.UserName);
});
}
else
{
cbbUsuario.Items.Add("", 0);
cbbUsuario.SelectedIndex = 0;
}
}
}
protected void gvcontacto_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GET"))
{
var splv = e.Parameters.Split(':');
var obj = new BEParameters()
{
Socied = obec.Socied,
CardCode = splv[1],
accion = 2,
};
var obrd = new BRDocument();
var olst = obrd.GET_CLIENTES_CONTACTOS(obj);
Session["crd1"] = olst;
gvcontacto.DataSource = olst;
gvcontacto.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEContactLines>)Session["crd1"]).Clear();
gvcontacto.DataSource = Session["crd1"];
gvcontacto.DataBind();
}
}
protected void gdvQutSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEParameters();
obj.Socied = obec.Socied;
if (chkqDocEntry.Checked)
{
obj.Internal = txtqDocEntry.Text.Trim();
}
if (chkqCreateDate.Checked)
{
obj.DateIn = dteqCreateDate.Date;
}
if (chkqCardCode.Checked)
{
obj.CardCode = txtqCardCode.Text.Trim();
}
if (chkqCardName.Checked)
{
obj.CardName = txtqCardName.Text.Trim();
}
if (chkqActives.Checked)
{
obj.Actives = txtqActives.Text.Trim();
}
var obrd = new BRDocument();
Session["qut"] = obrd.Get_OSCSP_SRCH_QUTT(obj);
gdvQutSearch.DataSource = Session["qut"];
gdvQutSearch.DataBind();
}
private string SaveTarjeta()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BETarjetaEquipo();
obj.CardCode = bteCustomer.Text;
obj.CardName = txtcustmrName.Text;
obj.Status = cbbstatus.Value.ToString();
obj.ItemCode = bteitemCode.Text;
obj.ItemName = txtitemName.Text;
obj.manufSN = txtmanufSN.Text;
obj.internalSN = txtinternalSN.Text;
obj.instLction = cbbAddress.Text;
obj.street = txtStreets1.Text;
obj.county = txtDistrito1.Text;
obj.state = txtDepartamento1.Text;
obj.U_GOS_MARCA = txtMarca.Text;
obj.U_GOS_MODELO = txtModelo.Text;
//obj.ContactPerson = Convert.ToString(txtcontctCode1.Value);
using (var obrd = new BRDocument())
{
obrd.SaveTarjeta(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : string.Format("OKBP#{0}", obj.insID);
//Init_VarSessions();
return(_err);
}
protected void grdvLlamada_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GET"))
{
var spl = e.Parameters.Split(':');
var obj = new BEParameters()
{
Socied = obec.Socied,
ItemCode = spl[2],
CardCode = spl[1],
SerieMaqr = spl[3]
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_SERVICIO_TJ(obj);
Session["oscl"] = olst;
grdvLlamada.DataSource = olst;
grdvLlamada.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BELlamadaServicio>)Session["oscl"]).Clear();
grdvLlamada.DataSource = Session["oscl"];
grdvLlamada.DataBind();
}
}
protected void gdvdln1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obep = new BEParameters();
if (e.Parameters.Contains("GET"))
{
var spl = e.Parameters.Split(':');
if (spl[1] != "" && spl[1] != null)
{
obep.Socied = obec.Socied;
obep.DocNum = Convert.ToInt32(spl[1]);
var olst = new List <BEDocumentLine>();
var obrd = new BRDocument();
olst = obrd.DXP_GET_GUIA_LLAMADA(obep);
Session["dln1"] = olst;
gdvdln1.DataSource = ((List <BEDocumentLine>)Session["dln1"]);
gdvdln1.DataBind();
}
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEDocumentLine>)Session["dln1"]).Clear();
gdvdln1.DataSource = Session["dln1"];
gdvdln1.DataBind();
}
}
protected void gdvGrupoArt_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEParameters()
{
Socied = obec.Socied,
Descripcion = txtnombregrupo.Text,
};
if (e.Parameters.Contains("SRCH"))
{
var obrd = new BRDocument();
var olst = obrd.DXP_GET_GRUPO_ART(obj);
Session["grupo"] = olst;
gdvGrupoArt.DataSource = olst;
gdvGrupoArt.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEGrupoArt>)Session["grupo"]).Clear();
gdvGrupoArt.DataSource = Session["grupo"];
gdvGrupoArt.DataBind();
}
}
protected void gdvTipoCambio_RowUpdating(object sender, ASPxDataUpdatingEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var index = gdvTipoCambio.EditingRowVisibleIndex;
//if(((List<BEAlmacen>)Session["oitw"])[index].Tiempo == "Existente")
((List <BETipoCambio>)Session["ortt"])[index].RateUSD = Convert.ToDecimal(e.NewValues["RateUSD"]);
((List <BETipoCambio>)Session["ortt"])[index].RateEUR = Convert.ToDecimal(e.NewValues["RateEUR"]);
BETipoCambio tp = new BETipoCambio();
tp.RateDate = Convert.ToDateTime(e.NewValues["RateDate"]);
tp.RateUSD = Convert.ToDecimal(e.NewValues["RateUSD"]);
tp.RateEUR = Convert.ToDecimal(e.NewValues["RateEUR"]);
gdvTipoCambio.CancelEdit();
e.Cancel = true;
gdvTipoCambio.DataSource = ((List <BETipoCambio>)Session["ortt"]);
gdvTipoCambio.DataBind();
using (var obrd = new BRDocument())
{
obrd.SaveCurrencyDates(tp, ((BEParameters)Session["InitPar"]).objSapSbo);
((BEParameters)Session["InitPar"]).Rate = tp.RateUSD;
((BEParameters)Session["InitPar"]).RateEur = tp.RateEUR;
//Rate1 = tp.RateUSD;
}
}
/// <summary>
/// LISTA LOS CLIENTES
/// </summary>
/// <returns></returns>
protected void gdvClientSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("SRCH"))
{
var obj = new BEParameters()
{
Socied = obec.Socied,
ParValue = txtParClient.Text.Trim(),
CardName = txtRazonS.Text,
ColumnIndex = ((GridViewDataColumn)gdvClientSearch.GetSortedColumns().ElementAt(0)).VisibleIndex
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_OCRD(obj);
Session["ocrd"] = olst;
gdvClientSearch.DataSource = olst;
gdvClientSearch.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEClient>)Session["ocrd"]).Clear();
gdvClientSearch.DataSource = Session["ocrd"];
gdvClientSearch.DataBind();
}
}
private string Modify()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEBusinessPartner();
obj.Socied = obec.Socied;
obj.CardCode = txtCrCardCode.Text;
obj.CardName = txtCrCardName.Text;
//cbbCrDocumentType
obj.LicTradNum = txtCrLicTradNum.Text;
//obj.GroupCode =
obj.Phone1 = txtCrPhone1.Text;
obj.Cellular = txtCrCellular.Text;
obj.E_Mail = txtCrE_Mail.Text;
obj.U_PN_FecNac = dteCrU_PN_FecNac.Text;
obj.U_BPP_BPTP = Convert.ToString(cbbCrPersonType.Value);
obj.U_BPP_BPTD = Convert.ToString(cbbCrDocumentType.Value);
obj.GroupNum = Convert.ToString(GroupNum.Value);
obj.Currency = Convert.ToString(cbbCurrency.Value);
obj.ListNum = Convert.ToString(ListNum.Value);
obj.Active = Convert.ToString(rbtnestado.SelectedItem.Value);
obj.Lines = ((List <BEContactLines>)Session["crd1"]);
obj.Lines2 = ((List <BEClientAddress>)Session["dire"]);
using (var obrd = new BRDocument())
{
obrd.UpdateBusinessPartner(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "OKUPDBP";
//Init_VarSessions();
return(_err);
}
/// <summary>
/// LISTA LOS PRODUCTOS
/// </summary>
/// <returns></returns>
protected void gdvProductSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("BUSCAR"))
{
var obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = txtCardCode.Text,
PriceList = Convert.ToInt16(cbbListNum.Value),
WhsCode = "",
ParValue = txtParProduct.Text.Trim(),
ColumnIndex = ((GridViewDataColumn)gdvProductSearch.GetSortedColumns().ElementAt(0)).VisibleIndex,
Sw = 2,
Kit = false,
Moneda = cbbDocCur.Value.ToString(),
DateIn = Convert.ToDateTime(dteDocDate.Text),
Descripcion = txtDescription.Text,
SerieMaqr = txtMarca.Text
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_OITM_P(obep);
Session["oitm"] = olst;
gdvProductSearch.DataSource = olst;
gdvProductSearch.DataBind();
}
else if (e.Parameters.Contains("CLEAR"))
{
((List <BEProduct>)Session["oitm"]).Clear();
gdvProductSearch.DataSource = Session["oitm"];
gdvProductSearch.DataBind();
}
}
protected void cbbAddress_Callback(object sender, CallbackEventArgsBase e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameter.Contains("GET"))
{
var splv = e.Parameter.Split(':');
var obj = new BEParameters()
{
Socied = obec.Socied,
CardCode = splv[1],
accion = 3,
};
var obrd = new BRDocument();
var olst = obrd.GET_CLIENTES_DIRECCIONES(obj);
if (olst.Count != 0)
{
cbbAddress.Items.Add("", 0);
olst.Where(i => i.AdresType != "B").ToList().ForEach(ite =>
{
cbbAddress.Items.Add(ite.Address, ite.Street + "$" + ite.StateName + "$" + ite.U_DXP_BIZ_PROV + "$" + ite.U_DXP_BIZ_DIST + "$" + ite.AdresType);
});
//cbbAddress.SelectedIndex = 0;
}
else
{
cbbAddress.Items.Add("", 0);
cbbAddress.SelectedIndex = 0;
}
}
}
private string SaveItem()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BETipoCambio();
//obj.RateDate = Convert.ToDateTime(dteFecha.Text);
//obj.UserSing = obec.CardName;
//if(txtDolar.Text != "0.00")
//{
// obj.CurrencyUSD = "USD";
// obj.RateUSD = Convert.ToDecimal(txtDolar.Text);
//}
//if (txtEuro.Text != "0.00")
//{
// obj.CurrencyEUR = "EUR";
// obj.RateEUR = Convert.ToDecimal(txtDolar.Text);
//}
using (var obrd = new BRDocument())
{
obrd.SaveCurrencyDates(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "OKBP";
//Init_VarSessions();
return(_err);
}
protected void gvDirecciones_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GET"))
{
var splv = e.Parameters.Split(':');
var obj = new BEParameters()
{
Socied = obec.Socied,
CardCode = splv[1],
accion = 3,
};
var obrd = new BRDocument();
var olst = obrd.GET_CLIENTES_DIRECCIONES(obj);
Session["dire"] = olst;
gvDirecciones.DataSource = olst;
gvDirecciones.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEClientAddress>)Session["dire"]).Clear();
gvDirecciones.DataSource = Session["dire"];
gvDirecciones.DataBind();
}
}
private void Init_VarSessions()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
U_DXP_SEDE = obec.U_DXP_SEDE,
};
var obrd = new BRDocument();
var olst = obrd.USUARIOS(obj);
if (olst.Count != 0)
{
cbbUsuario.Items.Add("", 0);
olst.ForEach(ite =>
{
cbbUsuario.Items.Add(ite.UserName, ite.UserName);
});
}
else
{
cbbUsuario.Items.Add("", 0);
cbbUsuario.SelectedIndex = 0;
}
}
protected void txtcontctCode1_Callback(object sender, CallbackEventArgsBase e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameter.Contains("INICIAR"))
{
var x = e.Parameter.Split(':');
var olst = new List <BEContactLines>();
var obj = new BEParameters()
{
Socied = obec.Socied,
CardCode = x[1],
};
var obrd = new BRDocument();
olst = obrd.Get_Contact_Person(obj);
if (olst.Count != 0)
{
olst.ForEach(ite =>
{
txtcontctCode1.Items.Add(ite.Name, ite.CntctCode);
});
txtcontctCode1.SelectedIndex = 0;
}
else
{
txtcontctCode1.Items.Add("", 0);
txtcontctCode1.SelectedIndex = 0;
}
}
}
protected void gdvdln1_RowInserting(object sender, ASPxDataInsertingEventArgs e)
{
var beNe = new BRDocument();
gdvdln1.DoRowValidation();
var obec = ((BEParameters)Session["InitPar"]);
string almacen = "";
/*if (obec.Socied == "BM")
* {
* if (beNe.getStockAlmacen(Convert.ToString(e.NewValues["ItemCode"])) <= 0)
* almacen = "BL010";
* else
* almacen = obec.WhsCode;
* }
* if (obec.Socied == "BT")
* {*/
almacen = obec.WhsCode;
//}
var line = new BEDocumentLine()
{
ItemCode = Convert.ToString(e.NewValues["ItemCode"]),
ItemName = Convert.ToString(e.NewValues["ItemName"]),
Quantity = Convert.ToInt32(e.NewValues["Quantity"]),
PriceBefDi = Convert.ToDecimal(e.NewValues["PriceBefDi"]),
DiscPrcnt = Convert.ToDecimal(e.NewValues["DiscPrcnt"]),
Price = Convert.ToDecimal(e.NewValues["Price"]),
LineTotal = Convert.ToDecimal(e.NewValues["LineTotal"]),
GTotal = Convert.ToDecimal(e.NewValues["GTotal"]),
IssueMthd = Convert.ToString(e.NewValues["IssueMthd"]),
WhsCode = almacen,
U_StoDiBE = Convert.ToDecimal(e.NewValues["U_StoDiBE"]),
U_BF_StoDiYo = Convert.ToDecimal(e.NewValues["U_BF_StoDiYo"]),
//BL050 = Convert.ToDecimal(e.NewValues["BL050"]),
//BL010 = Convert.ToDecimal(e.NewValues["BL010"]),
//U_U_BF_CompTot = Convert.ToDecimal(e.NewValues["U_U_BF_CompTot"]),
//U_BIZ_DREC = Convert.ToString(e.NewValues["U_BIZ_DREC"]),
//U_BIZ_FFAR = Convert.ToString(e.NewValues["U_BIZ_FFAR"]),
//U_BIZ_CANT = Convert.ToDecimal(e.NewValues["U_BIZ_CANT"]),
//U_BF_FECH_EXPE = DateTime.Today.ToShortDateString(),
//U_BF_FECH_VENC = DateTime.Today.AddDays(90).ToShortDateString(),
//U_BF_CodKit = string.Empty,
OItemCode = Convert.ToString(e.NewValues["OItemCode"]),
OnDscOrg = Convert.ToDecimal(e.NewValues["OnDscOrg"]),
Serie = Convert.ToString(e.NewValues["Serie"])
//PASAR EL SERIALNUMBER PARA LUEGO HACER EL DATASOURCE AL DETALLE
};
line.InDscOrg = (line.OnDscOrg == 0) ? 1 : 0;
((List <BEDocumentLine>)Session["dln1"]).Add(line);
//Set_Promotion();
Set_LineNum();
gdvdln1.JSProperties["cpSubTotal"] = ((List <BEDocumentLine>)Session["dln1"]).Sum(item => Math.Round(item.LineTotal, 2));
gdvdln1.CancelEdit();
e.Cancel = true;
gdvdln1.DataSource = ((List <BEDocumentLine>)Session["dln1"]);
gdvdln1.DataBind();
}
protected void clbSession_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e)
{
try
{
e.Result = string.Empty;
var obrd = new BRLogin();
var brdoc = new BRDocument();
var obec = ((BEParameters)Session["InitPar"]);
var obep = new BEParameters();
obep.UserName = UserName.Text;
obep.Password = Password.Text;
obep.SAPPASSWORD = tbPasswordConfirm.Text;
List <BEParameters> lval = obrd.Get_val_usu(obep.UserName.Trim(), obec.Socied, obec.U_DXP_SEDE);
if (obep.Password != obep.SAPPASSWORD)
{
throw new KeyNotFoundException();
}
else if (lval.Count == 0)
{
throw new KeyNotFoundException();
}
else
{
brdoc.Recoverer(obep);
e.Result = "PERM#" + "Cambio Exitoso";
}
}
catch (KeyNotFoundException ex)
{
e.Result = ex.Message;
}
}
protected void gdvProductSearch3_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GENERAL"))
{
var obep = new BEParameters()
{
Socied = obec.Socied,
ItemCode = txtParProduct3.Text.Trim(),
WhsCode = obec.WhsCode,
VALOR = txtmarc3.Text,
Descripcion = txtdescrip3.Text
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_ITEM_SEGUN_ALMACEN(obep);
Session["oitt"] = olst;
gdvProductSearch3.DataSource = olst;
gdvProductSearch3.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEProduct>)Session["oitt"]).Clear();
gdvProductSearch3.DataSource = Session["oitt"];
gdvProductSearch3.DataBind();
}
}
public static List <BEAdministrator> getdatos()
{
var obrd = new BRDocument();
var list = obrd.Get_list_user_admin();
return(list);
}
protected void gdvTipoPlan_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var spl = e.Parameters.Split(':');
if (e.Parameters.Contains("SRCH"))
{
var obj = new BEParameters()
{
Socied = obec.Socied,
Code = spl[1],
U_DXP_SEDE = cbbssede.Text
};
var obrd = new BRDocument();
if (obj.U_DXP_SEDE == "CE JULIACA")
{
obj.U_DXP_SEDE = "02";
}
else if (obj.U_DXP_SEDE == "CE PUNO")
{
obj.U_DXP_SEDE = "01";
}
var olst = obrd.GET_TIPOPLAN(obj);
Session["DXP_IP_POOL"] = olst;
gdvTipoPlan.DataSource = olst;
gdvTipoPlan.DataBind();
}
}
protected void gdvAsiento_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obep = new BEParameters();
if (e.Parameters.Contains("SRCH"))
{
obep.Socied = obec.Socied;
obep.TransId = Convert.ToInt32(txtTransId.Text);
var olst = new List <BEDocumentLine>();
var obrd = new BRDocument();
olst = obrd.Get_OSCSP_SRCH_JDT1(obep);
Session["asientoPrinc"] = olst;
gdvAsiento.DataSource = ((List <BEDocumentLine>)Session["asientoPrinc"]);
gdvAsiento.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEDocumentLine>)Session["asientoPrinc"]).Clear();
gdvAsiento.DataSource = Session["asientoPrinc"];
gdvAsiento.DataBind();
}
}
private string UpdtAsiento()
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEAsiento();
obj.Series = cbbnumero.Text;
obj.TransId = Convert.ToInt32(txtTransId.Text);
obj.DueDate = Convert.ToDateTime(txtDueDate.Value);
obj.Memo = txtmemo.Text;
obj.Indicator = Convert.ToString(cbbIndicator.Value);
obj.Project = bteProject.Text;
obj.TransCode = Convert.ToString(cbbTransCode.Value);
obj.Ref1 = txtRef1.Text;
obj.Ref2 = txtRef2.Text;
obj.Ref3 = txtRef3.Text;
obj.TipoC = Convert.ToString(chktipocamb.Value);
obj.AutoStorno = Convert.ToString(chkanular.Value);
obj.StornoDate = Convert.ToDateTime(txtanular.Value);
obj.AdjTran = Convert.ToString(chkajuste.Value);
obj.U_GOS_ESTDOC_LE = Convert.ToString(cbbestadodoc.Value);
obj.U_GOS_FECHA_LE = txtlibroelec.Text;
obj.U_MSS_TransIdAD = Convert.ToInt32(txtdocdes.Text);
obj.Lines = ((List <BEDocumentLine>)Session["asientoPrinc"]);
using (var obrd = new BRDocument())
{
obrd.UpdtAsiento(obj, ((BEParameters)Session["InitPar"]).objSapSbo);
}
var _err = !string.IsNullOrWhiteSpace(obj.Msg) ? obj.Msg : "IKCC";
//Init_VarSessions();
return(_err);
}
protected void grdvRecurso_CustomButtonCallback(object sender, ASPxGridViewCustomButtonCallbackEventArgs e)
{
var obrd = new BRDocument();
var obec = ((BEParameters)Session["InitPar"]);
if (e.ButtonID != "Enviar")
{
return;
}
Hashtable copiedValues = null;
string[] copiedFields = new string[] { "PrjName", "DIRECCIONIP", "USUARIOMKT", "PASSWORDMKT" };
copiedValues = new Hashtable();
foreach (string fieldName in copiedFields)
{
copiedValues[fieldName] = grdvRecurso.GetRowValues(e.VisibleIndex, fieldName);
}
var obj = new BEParameters()
{
U_DXP_SEDE = Convert.ToString(copiedValues["PrjName"]),
//PrjName = Convert.ToString(copiedValues["PrjName"]),
DIRECCIONIP = Convert.ToString(copiedValues["DIRECCIONIP"]),
USUARIOMKT = Convert.ToString(copiedValues["USUARIOMKT"]),
PASSWORDMKT = Convert.ToString(copiedValues["PASSWORDMKT"]),
Socied = obec.Socied,
};
obrd.Leer_Mikrotik_Abonados(obj, obec.objSapSbo);
}
protected void gdvProductSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GENERAL"))
{
var obep = new BEParameters()
{
Socied = obec.Socied,
accion = 1,
ItemCode = txtParProduct.Text.Trim(),
VALOR = txtmarc.Text,
Descripcion = txtdescrip.Text
};
var obrd = new BRDocument();
var olst = obrd.GET_ARTICULOS_GENERAL(obep);
Session["oitm"] = olst;
gdvProductSearch.DataSource = olst;
gdvProductSearch.DataBind();
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEProduct>)Session["oitm"]).Clear();
gdvProductSearch.DataSource = Session["oitm"];
gdvProductSearch.DataBind();
}
}
protected void grdvContratos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var Detalle = "";
if (e.Parameters.Contains("INIT"))
{
//var spl = e.Parameters.Split(':');
var obep1 = new BEParameters();
obep1.Socied = obec.Socied;
obep1.CardCode = txtCliente.Text;
obep1.Id_Dire = txtIdDirec.Text;
obep1.Code = txtCode.Text;
obep1.LOCAL = txtcalle.Text;
obep1.distrito = txtdistr.Text;
obep1.provincia = txtprovinc.Text;
obep1.Descripcion = txturba.Text;
obep1.Project = obec.Project;
if (string.IsNullOrEmpty(cbbVendedor.Text))
{
obep1.CompanyDB = "";
}
else
{
obep1.CompanyDB = cbbVendedor.Value.ToString();
}
obep1.DateIn = (DateTime?)dtebusqueda.Value;
obep1.DateFi = (DateTime?)dtebusqueda2.Value;
var obrd = new BRDocument();
var olst1 = obrd.DXP_GET_CONTRATOS(obep1);
olst1.ForEach(item =>
{
Detalle = "";
var obep2 = new BEParameters()
{
Socied = obec.Socied,
DocNum = Convert.ToInt32(item.DocNum),
CardCode = item.CardCode,
ObjType = 17
};
var olst2 = obrd.DXP_GETDETALLE_BORRADOR_OV(obep2);
olst2.Where(i => i.ActivoC == "Y").ToList().ForEach(item2 =>
{
Detalle += item2.ItemName + ",";
});
item.Detalle = Detalle.Substring(0, Detalle.Length - 1);
});
Session["orcp"] = olst1;
grdvContratos.DataSource = Session["orcp"];
grdvContratos.DataBind();
}
}
protected void grdvContratos_RowUpdating(object sender, ASPxDataUpdatingEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var index = grdvContratos.EditingRowVisibleIndex;
string[] x = new string[15];
DateTime?fch = new DateTime();
//if(((List<BEAlmacen>)Session["oitw"])[index].Tiempo == "Existente")
((List <BEContratos>)Session["orcp"])[index].Code = Convert.ToString(e.NewValues["Code"]);
((List <BEContratos>)Session["orcp"])[index].Dscription = Convert.ToString(e.NewValues["Dscription"]);
((List <BEContratos>)Session["orcp"])[index].Frequency = Convert.ToString(e.NewValues["Frequency"]);
((List <BEContratos>)Session["orcp"])[index].Remind = Convert.ToInt32(e.NewValues["Remind"]);
((List <BEContratos>)Session["orcp"])[index].DocNum = Convert.ToString(e.NewValues["DocNum"]);
((List <BEContratos>)Session["orcp"])[index].StartDate = Convert.ToDateTime(e.NewValues["StartDate"]);
((List <BEContratos>)Session["orcp"])[index].EndDate = Convert.ToDateTime(e.NewValues["EndDate"]);
((List <BEContratos>)Session["orcp"])[index].EndDate2 = Convert.ToString(e.NewValues["EndDate2"]);
var absentry = 0;
if (((List <BEContratos>)Session["orcp"])[index].EndDate2 == "")
{
fch = null;
}
else
{
x = ((List <BEContratos>)Session["orcp"])[index].EndDate2.Substring(0, 10).Split('/');
fch = Convert.ToDateTime(x[1] + "/" + x[0] + "/" + x[2]);
}
((List <BEContratos>)Session["orcp"]).Where(i => i.Code == Convert.ToString(e.NewValues["Code"]) &&
i.DocNum == Convert.ToString(e.NewValues["DocNum"]) &&
i.CardCode == Convert.ToString(e.NewValues["CardCode"])).ToList().ForEach(item =>
{
absentry = item.AbsEntry;
});
var obep = new BEParameters();
obep.Socied = obec.Socied;
obep.accion = 2;
obep.AbsEntryUpdt = absentry;
obep.FechaUpdt = fch;
obep.Descripcion = ((List <BEContratos>)Session["orcp"])[index].Dscription;
obep.DraftEntry = 0;
var obrd = new BRDocument();
obrd.CRUD_CONTRATO(obep);
var olst = obrd.DXP_GET_CONTRATOS(obep);
grdvContratos.CancelEdit();
e.Cancel = true;
grdvContratos.DataSource = olst;
grdvContratos.DataBind();
}
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();
}
protected void btnAddVistas_Click(object sender, EventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obrd = new BRDocument();
var olst = obrd.VISTAS();
var cant = ((List <BEParameters>)Session["perm"]).Count;
var usuario = cbbUsuario.Text;
var listavistas = new List <BEParameters>();
if (cant == 0)
{
listavistas.Clear();
olst.ForEach(item => {
var linea = new BEParameters();
linea.UserName = usuario;
linea.PERMISO = 1;
linea.Socied = obec.Socied;
linea.Project = obec.Project;
linea.GRUPO_MENU = item.GRUPO_MENU;
linea.PARTICULAR_MENU = item.PARTICULAR_MENU;
linea.NOMBRE_OFICIAL = item.NOMBRE_OFICIAL;
listavistas.Add(linea);
});
}
else
{
listavistas.Clear();
olst.ForEach(item => {
((List <BEParameters>)Session["perm"]).ForEach(it => {
if (item.NOMBRE_OFICIAL == it.NOMBRE_OFICIAL)
{
item.Band = true;
}
});
});
olst.Where(i => i.Band != true).ToList().ForEach(x => {
var linea = new BEParameters();
linea.UserName = usuario;
linea.PERMISO = 1;
linea.Socied = obec.Socied;
linea.Project = obec.Project;
linea.GRUPO_MENU = x.GRUPO_MENU;
linea.PARTICULAR_MENU = x.PARTICULAR_MENU;
linea.NOMBRE_OFICIAL = x.NOMBRE_OFICIAL;
listavistas.Add(linea);
});
}
if (listavistas.Count != 0)
{
listavistas.ForEach(add => {
obrd.DXP_INSERT_VISTA_POR_USUARIO(add);
});
}
}
public static List<BEInitialData> Get_InitialTipClie(string socied)
{
var obep = new BEParameters()
{
Socied = socied,
};
var obrd = new BRDocument();
var olst = obrd.GET_SP_TIP_CLIE(obep);
return (olst);
}
