public bool ValidarMembresia(MasterTwo conexion, string[] parametros)
{
blMaster bl = new blMaster();
Transaction transaction = Helper.InitTransaction();
return(true);
//List<object> parametros = new List<object>();
//return bl.ListarMasterTen("", parametros, out transaction);
}
public string AprobarOperacionesTesoreria(string Op, string Bd, string Clave)
{
Usuario user = (Usuario)System.Web.HttpContext.Current.Session[Constant.nameUser];
blMaster bl = new blMaster();
Transaction transaction = Helper.InitTransaction();
List <object> parametros = new List <object>();
parametros.Add("CtasCtes");
parametros.Add(Convert.ToInt32(Op));
parametros.Add(user.Alias);
parametros.Add(Clave);
if (Bd == "sil")
{
/*
* bl.EjecutarTransaccion("REC_Sil..VBG01076_VALUSUA", parametros, out transaction);
*/
bl.EjecutarTransaccion("Silvestre_Peru_SAC..VBG01076_VALUSUA", parametros, out transaction);
}
else if (Bd == "neo")
{
bl.EjecutarTransaccion("NeoAgrum_SAC..VBG01076_VALUSUA", parametros, out transaction);
}
else if (Bd == "ina")
{
bl.EjecutarTransaccion("Inatec_Peru_SAC..VBG01076_VALUSUA", parametros, out transaction);
}
if (transaction.type == TypeTransaction.OK)
{
return(Helper.InvokeTextHTML
(
"$('#inPopupOp').html(\"\");" +
"$('#inPopupArea').val(\"\");" +
"$('#inPopupMonto').val(\"\");" +
"$('#inPopupConcepto').val(\"\");" +
"$('#inPopupOp').val(\"\");" +
"$('#inPopupBd').val(\"\");" +
"ListarOperaciones();" +
"$('#confirmaraprobarModal').modal(\"hide\");" +
"showSuccess('Se realizó la 2da aprobación de la Op');"
));
}
else
{
return(Helper.InvokeErrorHTML(transaction.message));
}
//return Common.InvokeErrorHTML(Op + " " + Bd + " " + Clave);
}
public MasterCollection ListarOperacionesTesoreriaEV(string bd, string orden, string fechaini, string fechafin, int check1, int check2)
{
blMaster bl = new blMaster();
Transaction transaction = Helper.InitTransaction();
List <object> parametros = new List <object>();
parametros.Add(orden == string.Empty ? -1 : Convert.ToInt32(orden));
parametros.Add(fechaini == string.Empty ? null : fechaini);
parametros.Add(fechafin == string.Empty ? null : fechafin);
parametros.Add(check1);
parametros.Add(check2);
List <Master> ocol = new List <Master>();
if (bd == "all")
{
/*
* ocol.AddRange(bl.ListarMaster("REC_Sil..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
*/
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
}
else if (bd == "sil")
{
/*return bl.ListarMaster("REC_Sil..VBG00385_GESTIONCHECK", parametros, out transaction);*/
return(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
}
else if (bd == "neo")
{
return(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
}
else if (bd == "ina")
{
return(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
}
else
{
return(new MasterCollection(new List <Master>(), transaction));
}
}
public MasterCollection ListarOperacionesTesoreriaALL(string bd, string documento, string orden, string fechaini, string fechafin, int check1, int check2)
{
blMaster bl = new blMaster();
Transaction transaction = Helper.InitTransaction();
List <object> parametros = new List <object>();
parametros.Add(orden == string.Empty ? -1 : Convert.ToInt32(orden));
parametros.Add(fechaini == string.Empty ? null : fechaini);
parametros.Add(fechafin == string.Empty ? null : fechafin);
parametros.Add(check1);
parametros.Add(check2);
List <Master> ocol = new List <Master>();
switch (bd)
{
case "all":
switch (documento)
{
case "all":
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
case "solegr":
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
case "egrvar":
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
default:
return(new MasterCollection(new List <Master>(), transaction));
}
case "sil":
switch (documento)
{
case "all":
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
case "solegr":
return(bl.ListarMaster("Silvestre_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction));
case "egrvar":
return(bl.ListarMaster("Silvestre_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
default:
return(new MasterCollection(new List <Master>(), transaction));
}
case "neo":
switch (documento)
{
case "all":
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
case "solegr":
return(bl.ListarMaster("NeoAgrum_SAC..VBG00385_GESTIONCHECK", parametros, out transaction));
case "egrvar":
return(bl.ListarMaster("NeoAgrum_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
default:
return(new MasterCollection(new List <Master>(), transaction));
}
case "ina":
switch (documento)
{
case "all":
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction).Rows);
ocol.AddRange(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction).Rows);
return(new MasterCollection(ocol, transaction));
case "solegr":
return(bl.ListarMaster("Inatec_Peru_SAC..VBG00385_GESTIONCHECK", parametros, out transaction));
case "egrvar":
return(bl.ListarMaster("Inatec_Peru_SAC..VBG00414_GESTIONCHECK", parametros, out transaction));
default:
return(new MasterCollection(new List <Master>(), transaction));
}
default:
return(new MasterCollection(new List <Master>(), transaction));
}
}