// 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); }