public ActionResult CrucePago()
{
Ent_Usuario _usuario = (Ent_Usuario)Session[Ent_Constantes.NameSessionUser];
string actionName = this.ControllerContext.RouteData.GetRequiredString("action");
string controllerName = this.ControllerContext.RouteData.GetRequiredString("controller");
string return_view = actionName + "|" + controllerName;
if (_usuario == null)
{
return(RedirectToAction("Login", "Control", new { returnUrl = return_view }));
}
else
{
#region <VALIDACION DE ROLES DE USUARIO>
Boolean valida_rol = true;
Basico valida_controller = new Basico();
List <Ent_Menu_Items> menu = (List <Ent_Menu_Items>)Session[Ent_Global._session_menu_user];
valida_rol = valida_controller.AccesoMenu(menu, this);
#endregion
if (valida_rol)
{
Session[_sessionPagsLiqs] = null;
//Ent_Usuario _usuario = (Ent_Usuario)Session[Ent_Constantes.NameSessionUser];
Ent_Pedido_Maestro maestros = datPedido.Listar_Maestros_Pedido(_usuario.usu_id, _usuario.usu_postPago, "");
ViewBag.listPromotor = maestros.combo_ListPromotor;
ViewBag.usutipo = _usuario.usu_tip_id.ToString();
return(View());
}
else
{
return(RedirectToAction("Login", "Control", new { returnUrl = return_view }));
}
}
}
public ActionResult Index()
{
Session[_session_listDocDev_private] = null;
Ent_Pedido_Maestro maestros = datPedido.Listar_Maestros_Pedido(1, "", "");
ViewBag.listPromotor = maestros.combo_ListPromotor;
return(View());
}
public Ent_Pedido_Persona BuscarPersonaPedido(int basId)
{
DataSet dsReturn = new DataSet();
string sqlquery = "USP_LEER_PERSONA_USUARIO_MVC";
Ent_Pedido_Maestro Maestro = new Ent_Pedido_Maestro();
List <Ent_Pedido_Persona> ListPersona = null;
Ent_Pedido_Persona entPersona = null;
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
SqlParameter oDocumento = cmd.Parameters.Add("@bas_id", SqlDbType.VarChar);
oDocumento.Direction = ParameterDirection.Input;
oDocumento.Value = basId;
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsReturn);
ListPersona = new List <Ent_Pedido_Persona>();
ListPersona = (from DataRow dr in dsReturn.Tables[0].Rows
select new Ent_Pedido_Persona()
{
comision = Convert.ToDecimal(dr["Con_Fig_PorcDesc"]),
idCust = Convert.ToDecimal(dr["bas_id"]),
taxRate = Convert.ToDecimal(dr["Con_Fig_Igv"]),
commission_POS_visaUnica = Convert.ToDecimal(dr["Con_Fig_PorcDescPos"]),
percepcion = Convert.ToDecimal(dr["Con_Fig_Percepcion"]),
email = dr["bas_correo"].ToString(),
nombrecompleto = dr["nombrecompleto"].ToString(),
premio = dr["Premio"].ToString(),
aplica_percepcion = Convert.ToBoolean(dr["aplica_percepcion"].ToString()),
cant_nota = Convert.ToDecimal(dr["cant_Nota"]),
}).ToList();
}
}
}
entPersona = ListPersona.ElementAt(0);
}
catch (Exception exc)
{
entPersona = null;
}
return(entPersona);
}
public Ent_Pedido_Maestro Listar_Maestros_Pedido(decimal usuarioId, string usu_postPago, string IdCustomer)
{
DataSet dsReturn = new DataSet();
string sqlquery = "USP_LEER_MAESTROS_PEDIDO_MVC";
List <Ent_Combo> ListPromotor = null;
List <Ent_Combo> ListFormaPago = null;
Ent_Pedido_Maestro Maestro = new Ent_Pedido_Maestro();
if (IdCustomer == "")
{
IdCustomer = "0";
}
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
SqlParameter oCodUsuario = cmd.Parameters.Add("@IdUsuario", SqlDbType.Decimal);
oCodUsuario.Direction = ParameterDirection.Input;
oCodUsuario.Value = usuarioId;
SqlParameter oCodPost = cmd.Parameters.Add("@post", SqlDbType.VarChar);
oCodPost.Direction = ParameterDirection.Input;
oCodPost.Value = usu_postPago;
SqlParameter oCustt = cmd.Parameters.Add("@customer", SqlDbType.Decimal);
oCustt.Direction = ParameterDirection.Input;
oCustt.Value = Convert.ToDecimal(IdCustomer);
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dsReturn);
ListFormaPago = new List <Ent_Combo>();
ListFormaPago = (from DataRow dr in dsReturn.Tables[0].Rows
select new Ent_Combo()
{
codigo = dr["Con_Id"].ToString(),
descripcion = dr["Con_Descripcion"].ToString(),
}).ToList();
ListPromotor = new List <Ent_Combo>();
ListPromotor = (from DataRow dr in dsReturn.Tables[1].Rows
select new Ent_Combo()
{
codigo = dr["bas_id"].ToString(),
descripcion = dr["Nombres"].ToString().Replace(" ", " "),
}).ToList();
}
}
}
Maestro.combo_ListPromotor = ListPromotor;
Maestro.combo_ListFormaPago = ListFormaPago;
}
catch (Exception exc)
{
Maestro = null;
}
return(Maestro);
}