// GET: Orce
public ActionResult Promotion()
{
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
{
Ent_Promotion_Orce_Lista param = new Ent_Promotion_Orce_Lista();
param = promo.lista_tipo_param();
ViewBag.estado = param.Promotion_Orce_Status;
ViewBag.tipo = param.Promotion_Orce_Type;
ViewBag.usuario = param.Promotion_Orce_User;
}
return(View());
}
public Ent_Promotion_Orce_Lista lista_tipo_param()
{
Ent_Promotion_Orce_Lista lista_param = null;
string sqlquery = "USP_ORCE_GET_FILTROS_PROMOS";
DataTable dt = null;
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
try
{
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
dt = new DataTable();
da.Fill(dt);
//List<Ent_Promotion_Orce_Filtros> lista_filtros = new List<Ent_Promotion_Orce_Filtros>();
//lista_filtros = (from DataRow fila in dt.Rows
// select new Ent_Promotion_Orce_Filtros()
// {
// PROMOTION_TYPE=fila["PROMOTION_TYPE"].ToString(),
// CREATE_USER = fila["CREATE_USER"].ToString(),
// STATUS = fila["STATUS"].ToString(),
// }
// ).ToList();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
lista_param = new Ent_Promotion_Orce_Lista();
lista_param.Promotion_Orce_Status = (from item in dt.AsEnumerable()
group item by
new
{
CODIGO = item["STATUS"].ToString(),
DESCRIPCION = item["STATUS"].ToString(),
}
into G
select new Ent_Promotion_Orce_Status()
{
codigo = G.Key.CODIGO,
descripcion = G.Key.DESCRIPCION,
}).ToList();
lista_param.Promotion_Orce_Type = (from item in dt.AsEnumerable()
group item by
new
{
CODIGO = item["PROMOTION_TYPE"].ToString(),
DESCRIPCION = item["PROMOTION_TYPE"].ToString(),
}
into G
select new Ent_Promotion_Orce_Type()
{
codigo = G.Key.CODIGO,
descripcion = G.Key.DESCRIPCION,
}).ToList();
lista_param.Promotion_Orce_User = (from item in dt.AsEnumerable()
group item by
new
{
CODIGO = item["CREATE_USER"].ToString(),
DESCRIPCION = item["CREATE_USER"].ToString(),
}
into G
select new Ent_Promotion_Orce_User()
{
codigo = G.Key.CODIGO,
descripcion = G.Key.DESCRIPCION,
}).ToList();
}
}
}
}
}
catch
{
}
}
}
catch
{
}
return(lista_param);
}
