void cargarDasboard(BEParameters obep)
{
var obrd = new BRDocument();
var oVentas = obrd.Get_DS_OSCSP_SRCH_OINV(obep);
Session["Ventas"] = oVentas;
var oProducto = obrd.Get_DS_OSCSP_SRCH_INV1(obep);
Session["Producto"] = oProducto;
var oOrden = obrd.Get_DS_OSCSP_SRCH_ORDR(obep);
Session["Orden"] = oOrden;
var oCotizacion = obrd.Get_DS_OSCSP_SRCH_OQUT(obep);
Session["Cotizacion"] = oOrden;
}
public static List <BEProduct> Get_OneProduct(string socied, string project, string whscode, string cardcode, string pricelist, string itemcode)
{
var obep = new BEParameters()
{
Socied = socied,
Project = project,
CardCode = cardcode,
PriceList = Convert.ToInt16(pricelist),
WhsCode = whscode,
ParValue = itemcode,
ColumnIndex = 0,
Sw = 1,
Kit = false
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_OITM(obep);
return(olst);
}
protected void gdvDepartamento_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,
departamento = spl[1],
};
var obrd = new BRDocument();
var olst = obrd.GET_DEPARTAMENTOS(obj);
Session["drcn"] = olst;
gdvDepartamento.DataSource = olst;
gdvDepartamento.DataBind();
}
}
protected void gdvOinvSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEParameters()
{
Socied = obec.Socied,
DateIn = (DateTime?)dteDateIn.Value,
DateFi = (DateTime?)dteDateFi.Value,
NumAtCard = txtNumAtCards.Text,
Project = obec.Project,
Reserve = "Y"
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_SRCH_OINV(obj);
Session["oinv"] = olst;
gdvOinvSearch.DataSource = olst;
gdvOinvSearch.DataBind();
}
protected void gdvClientSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var Detalle = "";
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEParameters();
obj.Socied = obec.Socied;
obj.CardCode = txtcode.Text;
obj.CardName = txtrason.Text;
obj.Project = obec.Project;
obj.Id_Dire = txtidir.Text;
obj.Contrato = txtcontratobus.Text;
var obrd = new BRDocument();
var olst = obrd.DXP_GET_CLIENTE_ESTADO_CUENTA(obj);
olst.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["cliente"] = olst;
gdvClientSearch.DataSource = olst;
gdvClientSearch.DataBind();
}
protected void gdvLotes_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GETLOTE"))
{
var spl = e.Parameters.Split(':');
var obj = new BEParameters()
{
Socied = obec.Socied,
ItemCode = spl[1],
};
var obrd = new BRDocument();
Session["lote"] = obrd.Get_LotesNumber(obj);
}
//Session["lote"] = olst;
gdvLotes.DataSource = Session["lote"];
gdvLotes.DataBind();
}
protected void gdvPermisos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GET"))
{
var obj = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
UserName = cbbUsuario.Text
};
var obrd = new BRDocument();
var olst = obrd.PERMISOS(obj);
Session["perm"] = olst.Where(i => i.LOCAL == obec.Project).ToList();
gdvPermisos.DataSource = olst;
gdvPermisos.DataBind();
}
}
/// <summary>
/// Insertar Local
/// </summary>
/// <param name="obep"></param>
/// <param name="permi"></param>
public void SET_SP_INSERTAR_LOCAL(BEParameters obep, bool permi)
{
try
{
odb = DatabaseFactory.CreateDatabase("ApplicationServices");
ocn = odb.CreateConnection();
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
var ocmd = odb.GetStoredProcCommand("SP_INSERTAR_LOCAL", obep.UserName, obep.Socied, obep.Project, permi);
ocmd.CommandTimeout = 2000;
var ord = odb.ExecuteNonQuery(ocmd);
Dispose(false);
}
finally
{
ocn.Close();
}
}
protected void gdvTarjeta_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("GET"))
{
var obj = new BEParameters()
{
Socied = obec.Socied,
ItemCode = txtProducto.Text,
CardCode = txtCliente.Text,
SerieMaqr = txtSerie.Text
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_TARJETAEQUIPO(obj);
Session["oins"] = olst;
gdvTarjeta.DataSource = olst;
gdvTarjeta.DataBind();
}
}
protected void gdvCards_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 = bteCustomer.Text,
ItemCode = txtitemCode.Text,
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_CARDS(obj);
Session["oitm"] = olst;
gdvCards.DataSource = olst;
gdvCards.DataBind();
}
}
public IDataReader GET_PERMISOS(BEParameters obep)
{
try
{
odb = DatabaseFactory.CreateDatabase("ApplicationServices");
ocn = odb.CreateConnection();
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
var ocmd = odb.GetStoredProcCommand("DXP_GET_PERMISOS", obep.UserName, obep.Socied, obep.Project);
ocmd.CommandTimeout = 2000;
var ord = odb.ExecuteReader(ocmd);
Dispose(false);
return(ord);
}
finally
{
ocn.Close();
}
}
protected void gdvCuentassrch_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,
Code = txtCuenta.Text,
Currency = cbbDocCur.Value.ToString(),
//ItemCode = txtitemCode.Text,
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_CUENTASGENERAL(obj);
Session["oact"] = olst;
gdvCuentassrch.DataSource = olst;
gdvCuentassrch.DataBind();
}
}
protected void gdvPR_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 = txtCliente.Text,
Internal = txtnrodoc.Text,
DateIn = Convert.ToDateTime(dteFecha.Text),
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_PAGOR(obj);
Session["oscl"] = olst;
gdvPR.DataSource = olst;
gdvPR.DataBind();
}
}
protected void gdvServicio_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("INIT"))
{
var spl = e.Parameters.Split(':');
var obep = new BEParameters()
{
Socied = obec.Socied,
DocNum = Convert.ToInt32(spl[1]),
CardCode = spl[2],
ObjType = 17
};
var obrd = new BRDocument();
var olst = obrd.DXP_GETDETALLE_BORRADOR_OV(obep);
Session["drf1"] = olst;
gdvServicio.DataSource = Session["drf1"];
gdvServicio.DataBind();
}
}
/// <summary>
/// LISTA LOS LOCALES
/// </summary>
/// <param name="obep"></param>
/// <returns></returns>
public IDataReader Get_SCSP_LSPJ_OPRJ(BEParameters obep)
{
try
{
odb = DatabaseFactory.CreateDatabase(obep.Socied);
ocn = odb.CreateConnection();
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
var ocmd = odb.GetStoredProcCommand("SCSP_LSPJ_OPRJ", obep.RUC);
ocmd.CommandTimeout = 2000;
var ord = odb.ExecuteReader(ocmd);
Dispose(false);
return(ord);
}
finally
{
ocn.Close();
}
}
/// <summary>
/// RETORNA EL CODIGO DE EMPLEADO LOGUEADO
/// </summary>
/// <param name="obep"></param>
/// <returns></returns>
public string Get_OSCSP_IDOH(BEParameters obep)
{
try
{
odb = DatabaseFactory.CreateDatabase(obep.Socied);
ocn = odb.CreateConnection();
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
var ocmd = odb.GetStoredProcCommand("OSCSP_IDOH", obep.UserName);
ocmd.CommandTimeout = 2000;
var scl = (string)odb.ExecuteScalar(ocmd);
Dispose(false);
return(scl);
}
finally
{
ocn.Close();
}
}
/// <summary>
/// LISTA LOS LOCALES VALIDADOS POR USUARIO
/// </summary>
/// <param name="obep"></param>
/// <returns></returns>
public IDataReader Get_SP_LISTARLOCALVAL(BEParameters obep)
{
try
{
odb = DatabaseFactory.CreateDatabase("ApplicationServices");
ocn = odb.CreateConnection();
if (ocn.State == ConnectionState.Closed)
{
ocn.Open();
}
var ocmd = odb.GetStoredProcCommand("SP_LISTVAL", obep.UserName);
ocmd.CommandTimeout = 2000;
var ord = odb.ExecuteReader(ocmd);
Dispose(false);
return(ord);
}
finally
{
ocn.Close();
}
}
protected void gdvWhsCodeSearch1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("ALMCN"))
{
var splt = e.Parameters.Split(':');
var obj = new BEParameters()
{
Socied = obec.Socied,
ParValue = txtParAlmacen.Text.Trim(),
ColumnIndex = ((GridViewDataColumn)gdvWhsCodeSearch1.GetSortedColumns().ElementAt(0)).VisibleIndex,
ItemCode = splt[1],
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_OITW(obj);
Session["owhs"] = olst;
gdvWhsCodeSearch1.DataSource = olst;
gdvWhsCodeSearch1.DataBind();
}
}
protected void grdvInfiltrados_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("INIT"))
{
//var spl = e.Parameters.Split(':');
var obep = new BEParameters()
{
Socied = obec.Socied,
U_DXP_COD_ABONADO = txtCliente.Text,
U_DXP_SEDE = obec.U_DXP_SEDE
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_ISP_INFILTRADOS(obep);
Session["DXP_ISP_INFILTRADOS"] = olst;
grdvInfiltrados.DataSource = olst;
grdvInfiltrados.DataBind();
}
if (e.Parameters.Contains("CHANGE"))
{
var sede = cbbssede.Value.ToString().Split('$');
var obep = new BEParameters()
{
Socied = obec.Socied,
U_DXP_COD_ABONADO = txtCliente.Text,
DIRECCIONIP = sede[0],
PASSWORDMKT = sede[1],
USUARIOMKT = sede[2],
U_DXP_SEDE = cbbssede.Text
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_ISP_INFILTRADOS(obep);
Session["DXP_ISP_INFILTRADOS"] = olst;
grdvInfiltrados.DataSource = olst;
grdvInfiltrados.DataBind();
}
}
/// <summary>
/// LISTA LOS PRODUCTOS
/// </summary>
/// <returns></returns>
protected void gdvProductSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obep = new BEParameters()
{
Socied = obec.Socied,
Project = obec.Project,
CardCode = txtCardCode.Text,
PriceList = Convert.ToInt16(cbbListNum.Value),
WhsCode = obec.WhsCode,
ParValue = txtParProduct.Text.Trim(),
ColumnIndex = ((GridViewDataColumn)gdvProductSearch.GetSortedColumns().ElementAt(0)).VisibleIndex,
Sw = 2,
Kit = chkKit.Checked
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_OITM_P(obep);
Session["oitm"] = olst;
gdvProductSearch.DataSource = olst;
gdvProductSearch.DataBind();
}
protected void gdvTipoCambio_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
((List <BETipoCambio>)Session["ortt"]).Clear();
if (e.Parameters.Contains("INIT"))
{
var spl = e.Parameters.Split(':');
var listdias = GetDates(Convert.ToInt32(spl[1]), Convert.ToInt32(spl[2]));
var obep = new BEParameters()
{
Socied = obec.Socied,
mes = Convert.ToInt32(spl[1]),
año = Convert.ToInt32(spl[2]),
};
var obrd = new BRDocument();
var olst = obrd.DXP_GET_TIPOCAMBIO(obep);
listdias.ForEach(i => {
BETipoCambio tp = new BETipoCambio();
tp.RateDate = i;
((List <BETipoCambio>)Session["ortt"]).Add(tp);
});
olst.ForEach(item => {
((List <BETipoCambio>)Session["ortt"]).Where(tp => tp.RateDate == item.RateDate).ToList().ForEach(x => {
if (item.Currency == "USD")
{
x.RateUSD = item.Rate;
}
else if (item.Currency == "EUR")
{
x.RateEUR = item.Rate;
}
});
});
gdvTipoCambio.DataSource = Session["ortt"];
gdvTipoCambio.DataBind();
}
}
protected void UpdateButton_Click(object sender, EventArgs e)
{
BEParameters obep = (BEParameters)Session["obep"];
if (navigateComboBox.Value.ToString() == "-")
{
obrl = new BRLogin();
List <BELogin> olst = obrl.Get_DS_SCSP_LSPJ_OPRJ(obep);
var str = String.Join(",", olst.Select(p => p.PrjCode));
obep.Project = str;
}
else
{
obep.Project = navigateComboBox.Value.ToString();
}
obep.DateIn = (DateTime)caleInicio.Value;
obep.DateFi = (DateTime)caleFin.Value;
hffechaInicio.Value = ((DateTime)caleInicio.Value).ToString("dd/MM/yyyy");
hffechaFin.Value = ((DateTime)caleFin.Value).ToString("dd/MM/yyyy");
cargarDasboard(obep);
}
protected void gdvOrinSearch_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obj = new BEParameters()
{
Socied = obec.Socied,
DateIn = (DateTime?)dteDateIn.Value,
DateFi = (DateTime?)dteDateFi.Value,
NumAtCard = txtNumAtCards.Text,
CardCode = txtsCardCode.Text,
CardName = txtsCardName.Text,
Id_Dire = txtdirec.Text,
Project = obec.Project,
Code = txtCorrelativo.Text
};
var obrd = new BRDocument();
var olst = obrd.Get_OSCSP_SRCH_ORPC(obj);
Session["Orin"] = olst;
gdvOrinSearch.DataSource = olst;
gdvOrinSearch.DataBind();
}
private List <BEProduct> SerialNumber()
{
var obec = ((BEParameters)Session["InitPar"]);
var olist = new List <BEProduct>();
var listaSN = new List <BEProduct>();
((List <BEDocumentLine>)Session["dln1"]).ForEach(item =>
{
var obj = new BEParameters()
{
Socied = obec.Socied,
ItemCode = item.ItemCode
};
using (var obrd = new BRDocument())
{
olist = obrd.Get_SerialNumber(obj);
}
listaSN.AddRange(olist);
});
return(listaSN);
}
private void Init_VarSessions()
{
var obec = ((BEParameters)Session["InitPar"]);
Session["orcp"] = new List <BEContratos>();
Session["DXP_ISP_REGISTRO"] = new List <BEAbonado>();
Session["odrf"] = new List <BEDocument>();
Session["orcl"] = new List <BEWhsCode>();
Session["DXP_IP_POOL"] = new List <BETipoPlan>();
hdfTemp.Add("IP", obec.DIRECCIONIP);
hdfTemp.Add("Sociedad", obec.Socied);
hdfTemp.Add("UNMK", obec.USUARIOMKT);
hdfTemp.Add("PSWMK", obec.PASSWORDMKT);
hdfTemp.Add("SEDE", obec.U_DXP_SEDE);
if (obec.Band)
{
var obep = new BEParameters()
{
Socied = obec.Socied,
//U_DXP_COD_ABONADO = txtCliente.Text,
//U_DXP_DIREC_ABO = txtDireccion.Text,
DIRECCIONIP = obec.DIRECCIONIP,
PASSWORDMKT = obec.PASSWORDMKT,
USUARIOMKT = obec.USUARIOMKT,
};
var obrd = new BRDocument();
((BEParameters)Session["InitPar"]).Band = false;
// obrd.Leer_Mikrotik_Active(obep, obec.objSapSbo);
}
//hdfTemp.Add("_proj", obec.Project);
//hdfTemp.Add("_whsc", obec.WhsCode);
//hdfTemp.Add("_cpnadd", obec.CompanyAddress.ToUpper());
//hdfTemp.Add("_phone", obec.Phone);
//hdfTemp.Add("_SerieM", obec.SerieMaqr);
}
void cargarDasboard(BEParameters obep)
{
var obrd = new BRDocument();
var oVentas = obrd.Get_DS_OSCSP_SRCH_OPCH(obep);
Session["Ventas"] = oVentas;
var oProducto = obrd.Get_DS_OSCSP_SRCH_PCH1(obep);
Session["Producto"] = oProducto;
var oOrden = obrd.Get_DS_OSCSP_SRCH_OPOR(obep);
Session["Orden"] = oOrden;
var oOrden2 = obrd.Get_DS_OSCSP_SRCH_OPOR2(obep);
Session["Orden2"] = oOrden2;
var oGuia = obrd.Get_DS_OSCSP_SRCH_OPDN(obep);
Session["Guia"] = oGuia;
}
protected void gdvArticulos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("ADD"))
{
var spl = e.Parameters.Split(':');
var line = new BEDocumentLine();
line.ItemCode = spl[1];
line.ItemName = spl[2];
line.Quantity = 1;
line.WhsCode = cbbalmacenorigen.Value.ToString();
line.WareHouse = cbbalmacendestino.Value.ToString();
line.IssueMthd = spl[3];
line.Serie = "";
((List <BEDocumentLine>)Session["wtr1"]).Add(line);
}
else if (e.Parameters.Contains("GET"))
{
var _spl = e.Parameters.Split(':');
var obep = new BEParameters()
{
Socied = obec.Socied,
DocEntry = Convert.ToInt32(_spl[1]),
};
var obrd = new BRDocument();
var list = obrd.DXP_GET_TRANSTOCK_DETALLE(obep);
Session["wtr1"] = list;
}
else if (e.Parameters.Contains("CLR"))
{
((List <BEDocumentLine>)Session["wtr1"]).Clear();
}
gdvArticulos.DataSource = ((List <BEDocumentLine>)Session["wtr1"]);
gdvArticulos.DataBind();
Set_LineNum();
}
protected void grdvConsumos_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
var obec = ((BEParameters)Session["InitPar"]);
if (e.Parameters.Contains("INIT"))
{
//var spl = e.Parameters.Split(':');
var obep = new BEParameters()
{
Socied = obec.Socied,
U_DXP_COD_ABONADO = txtCliente.Text,
DIRECCIONIP = obec.DIRECCIONIP,
USUARIOMKT = obec.USUARIOMKT,
PASSWORDMKT = obec.PASSWORDMKT,
};
var obrd = new BRDocument();
var olst = obrd.Leer_Mikrotik_Consumos(obep);
Session["DXP_ISP_REGISTRO"] = olst;
grdvConsumos.DataSource = olst;
grdvConsumos.DataBind();
}
}
protected void cbbCuentaTrans_Callback(object sender, CallbackEventArgsBase e)
{
var obec = ((BEParameters)Session["InitPar"]);
var obep = new BEParameters()
{
Socied = obec.Socied
};
var obrd = new BRDocument();
var olst = obrd.GET_CUENTAS_PAGO(obep);
if (olst.Count != 0)
{
olst.Where(i => i.Clave == "SC").ToList().ForEach(item =>
{
cbbCuentaTrans.Items.Add(item.AcctName, item.AcctCode);
});
cbbCuentaTrans.SelectedIndex = 0;
}
else
{
cbbCuentaTrans.Items.Add("", 0);
cbbCuentaTrans.SelectedIndex = 0;
}
}
protected void btnEnviarTodo_Click(object sender, EventArgs e)
{
var obrd = new BRDocument();
var obec = ((BEParameters)Session["InitPar"]);
var sede = cbbssede.Value.ToString().Split('$');
var ob = new BEParameters()
{
Socied = obec.Socied,
DIRECCIONIP = sede[0],
USUARIOMKT = sede[1],
PASSWORDMKT = sede[2],
U_DXP_COD_ABONADO = "",
U_DXP_SEDE = cbbssede.Text,
};
var mensaje = obrd.Enviar_pendientes(ob, obec.objSapSbo);
//var mensaje = "hola mundo";
//hdfTemp.Set("Band", true);
//hdfTemp.Set("Msg", mensaje);
grdvPendientes.DataSource = ((List <BEAbonado>)Session["DXP_ISP_REGISTRO"]);
grdvPendientes.DataBind();
}
