public List<Ent_Combo> get_ListaTipos2()
{
List<Ent_Combo> list = null;
string sqlquery = "USP_GET_CONCEPTO_MOVLAM";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0) cn.Open();
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List<Ent_Combo>();
while (dr.Read())
{
Ent_Combo combo = new Ent_Combo();
combo.cbo_codigo = dr["CON_ID"].ToString();
combo.cbo_descripcion = dr["CON_DES"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return list;
}
public ActionResult Index()
{
List <Ent_Combo> list = new List <Ent_Combo>();
Ent_Combo entCombo = new Ent_Combo();
entCombo.cbo_codigo = "0";
entCombo.cbo_descripcion = "----Todos----";
list.Add(entCombo);
ViewBag.Title = "Reporte de Planilla";
ViewBag.Grupo = datCbo.get_ListaGrupo();
ViewBag.Estado = datCbo.get_ListaEstado();
//VLADIMIR
ViewBag.Tienda = datCbo.get_ListaTiendaXstore(Session["PAIS"].ToString());
//VLADIMIR ENBD
ViewBag.Categoria = list;
string strJson = "";
JsonResult jRespuesta = null;
var serializer = new JavaScriptSerializer();
strJson = datCbo.listarStr_ListaCategoria("");
jRespuesta = Json(serializer.Deserialize <List <Ent_Combo> >(strJson), JsonRequestBehavior.AllowGet);
ViewBag.ClCategoria = jRespuesta;
strJson = datCbo.listarStr_ListaSubCategoria("");
jRespuesta = Json(serializer.Deserialize <List <Ent_Combo> >(strJson), JsonRequestBehavior.AllowGet);
ViewBag.ClSBCategoria = jRespuesta;
return(View());
}
public ActionResult VentaHistorica(string cod_Tda, string descTienda)
{
Ent_Combo cbo = new Ent_Combo();
cbo.cbo_codigo = cod_Tda;
cbo.cbo_descripcion = descTienda;
return(View(cbo));
}
public ActionResult Nuevo()
{
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)
{
Ent_Promotor_Maestros maestros = datUtil.ListarEnt_Maestros_Promotor(_usuario.usu_id);
List <Ent_Combo> listobj = new List <Ent_Combo>();
Ent_Combo cbo = new Ent_Combo();
cbo.codigo = "-1";
cbo.descripcion = "------Selecccione------";
listobj.Add(cbo);
ViewBag.listDepartamento = maestros.combo_ListDepartamento;
ViewBag.listLider = maestros.combo_ListLider;
ViewBag.listTipoDoc = maestros.combo_ListTipoDoc;
ViewBag.listTipoPersona = maestros.combo_ListTipoPersona;
ViewBag.listTipoUsuario = maestros.combo_ListTipoUsuario;
ViewBag.General = listobj;
return(View());
}
else
{
return(RedirectToAction("Login", "Control", new { returnUrl = return_view }));
}
}
}
/*lista xstore Bata Ecuador*/
public List<Ent_Combo> get_ListaTiendaXstore_EC(string Pais)
{
List<Ent_Combo> list = null;
string sqlquery = "USP_LISTAR_TIENDA_XSTORE";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0) cn.Open();
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pais", Pais);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List<Ent_Combo>();
Ent_Combo combo = new Ent_Combo();
//if (_selecciona)
//{
// combo.cbo_codigo = "-1";
// combo.cbo_descripcion = "--SELECCIONAR--";
// list.Add(combo);
//}
while (dr.Read())
{
combo = new Ent_Combo();
combo.cbo_codigo = dr["codigo"].ToString();
combo.cbo_descripcion = dr["descrip"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return list;
}
public List <Ent_Combo> get_lista_Distrito(string cod_dep, string cod_prv)
{
List <Ent_Combo> list = null;
string sqlquery = "USP_Leer_Distrito";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cod_dep", cod_dep);
cmd.Parameters.AddWithValue("@cod_prv", cod_prv);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
Ent_Combo dis = new Ent_Combo();
//dis.dis_cod = "0";
//dis.dis_descripcion = "--Ninguno--";
//list.Add(dis);
while (dr.Read())
{
dis = new Ent_Combo();
dis.cbo_codigo = dr["DIS_COD"].ToString();
dis.cbo_descripcion = dr["DIS_DESCRIPCION"].ToString();
list.Add(dis);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
public List <Ent_Combo> get_ListaTienda(string codTienda, int ind_, string pais)
{
List <Ent_Combo> list = null;
string sqlquery = "USP_LISTAR_TIENDA";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexionEcommerce))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codTienda", codTienda);
cmd.Parameters.AddWithValue("@ind_", ind_);
cmd.Parameters.AddWithValue("@pais", pais);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
Ent_Combo combo = new Ent_Combo();
while (dr.Read())
{
combo = new Ent_Combo();
combo.cbo_codigo = dr["cod_entid"].ToString();
combo.cbo_descripcion = dr["des_entid"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception ex)
{
list = null;
}
return(list);
}
public List<Ent_Combo> get_ListaTiendaXstoreActivo(string pais,string codTda = "")
{
List<Ent_Combo> list = null;
string sqlquery = "USP_LISTAR_TIENDA_XSTORE_ACTIVA";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0) cn.Open();
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter otda = cmd.Parameters.Add("@COD_TDA", SqlDbType.VarChar);
cmd.Parameters.AddWithValue("@pais", pais);
otda.Direction = ParameterDirection.Input;
otda.Value = codTda;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List<Ent_Combo>();
while (dr.Read())
{
Ent_Combo combo = new Ent_Combo();
combo.cbo_codigo = dr["CODIGO"].ToString();
combo.cbo_descripcion = dr["DESCRIP"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return list;
}
public List <Ent_Combo> get_ListaAlmacen_Apoyo()
{
List <Ent_Combo> list = null;
string sqlquery = "USP_ECOMMERCE_ALMACEN_APOYO";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexionPosPeru))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@codTienda", codTienda);
//cmd.Parameters.AddWithValue("@ind_", ind_);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
Ent_Combo combo = new Ent_Combo();
while (dr.Read())
{
combo = new Ent_Combo();
combo.cbo_codigo = dr["cod_almac"].ToString();
combo.cbo_descripcion = dr["des_cadena"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception ex)
{
list = null;
}
return(list);
}
public List <Ent_Combo> get_atributos()
{
List <Ent_Combo> list = null;
string sqlquery = "USP_ORCE_GET_ATRIBUTOS";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
Ent_Combo combo = new Ent_Combo();
combo.cbo_codigo = "-1";
combo.cbo_descripcion = "---Seleccione---";
list.Add(combo);
while (dr.Read())
{
combo = new Ent_Combo();
combo.cbo_codigo = dr["COD_ATR"].ToString();
combo.cbo_descripcion = dr["DES_ATR"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
public List <Ent_Combo> get_lista_Departamento()
{
List <Ent_Combo> list = null;
string sqlquery = "USP_Leer_Departamento";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
Ent_Combo dep = new Ent_Combo();
//dep.dep_id = "0";
//dep.dep_descripcion = "--Ninguno--";
//list.Add(dep);
while (dr.Read())
{
dep = new Ent_Combo();
dep.cbo_codigo = dr["DEP_ID"].ToString();
dep.cbo_descripcion = dr["DEP_DESCRIPCION"].ToString();
list.Add(dep);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
public List <Ent_Combo> get_tda_cadena(string cadena, int todos = 0)
{
List <Ent_Combo> list = null;
string sqlquery = "USP_ORCE_GET_TDA_CADENA";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@COD_CADENA", cadena);
cmd.Parameters.AddWithValue("@TODOS", todos);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
while (dr.Read())
{
Ent_Combo combo = new Ent_Combo();
combo.cbo_codigo = dr["COD_ENTID"].ToString();
combo.cbo_descripcion = dr["DES_ENTID"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
public List <Ent_Combo> get_ListaMeses()
{
List <Ent_Combo> list = null;
string sqlquery = "USP_BATACLUB_LISTA_MESES";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List <Ent_Combo>();
Ent_Combo cup = new Ent_Combo();
while (dr.Read())
{
cup = new Ent_Combo();
cup.cbo_codigo = dr["MesInt"].ToString();
cup.cbo_descripcion = dr["MesStr"].ToString();
list.Add(cup);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return(list);
}
public List<Ent_Combo> get_ListaSubCategoria(string strCate)
{
List<Ent_Combo> list = null;
string sqlquery = "Leer_SubCategoria";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0) cn.Open();
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Categoria", strCate);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List<Ent_Combo>();
while (dr.Read())
{
Ent_Combo combo = new Ent_Combo();
combo.cbo_codigo = dr["cod_subc3"].ToString();
combo.cbo_descripcion = dr["des_subc3"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return list;
}
public List<Ent_Combo> get_lista_anios( int a_inicio)
{
List<Ent_Combo> list = null;
string sqlquery = "USP_GET_LISTA_ANIOS";
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
if (cn.State == 0) cn.Open();
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ANIO_INICIO", a_inicio);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
list = new List<Ent_Combo>();
while (dr.Read())
{
Ent_Combo combo = new Ent_Combo();
combo.cbo_codigo = dr["cod"].ToString();
combo.cbo_descripcion = dr["anio"].ToString();
list.Add(combo);
}
}
}
}
}
catch (Exception)
{
list = null;
}
return list;
}
public ActionResult Index()
{
string usuario_nom = "";
string usuario_con = "";
Boolean _acceso = false;
Boolean _accesoMenu = true;
Ent_Usuario _usuario = (Ent_Usuario)Session[Ent_Constantes.NameSessionUser];
try
{
if (!DBNull.Value.Equals(Request.Cookies["User"].Value) && _usuario == null)
{
usuario_nom = Request.Cookies["User"].Value;
usuario_con = Request.Cookies["Pass"].Value;
string _error_con = "";
_acceso = IsValid(usuario_nom, usuario_con, ref _error_con);
if (_acceso)
{
_usuario = (Ent_Usuario)Session[Ent_Constantes.NameSessionUser];
}
_accesoMenu = false;
}
}
catch (Exception ex) {
_acceso = false;
}
string actionName = this.ControllerContext.RouteData.GetRequiredString("action");
string controllerName = this.ControllerContext.RouteData.GetRequiredString("controller");
string return_view = actionName + "|" + controllerName;
List <Ent_Combo> list = new List <Ent_Combo>();
Ent_Combo entCombo = new Ent_Combo();
if ((_usuario == null && _acceso == false) || (_usuario == null && _accesoMenu == true))
{
return(RedirectToAction("Login", "Control", new { returnUrl = return_view }));
}
else
{
if (_accesoMenu == true)
{
var distrito = datArticuloStock.listar_distrito(Session["PAIS"].ToString()); /*Filtra por pais -bataweb ecuador*/
var lista = datArticuloStock.listar_Departamento();
var obj = lista[0];
List <Departamento> listobj = new List <Departamento>();
listobj.Add(obj);
ViewBag.listDepartamento = lista;
ViewBag.General = listobj;
ViewBag.Usuario = _usuario.usu_nombre;
ViewBag.distrito = distrito;
Dat_Orce get_orc = new Dat_Orce();
ViewBag.cadena = get_orc.lista_cadena(true);
list = new List <Ent_Combo>();
entCombo = new Ent_Combo();
entCombo.cbo_codigo = "0";
entCombo.cbo_descripcion = "POR DEFECTO";
list.Add(entCombo);
entCombo = new Ent_Combo();
entCombo.cbo_codigo = "1";
entCombo.cbo_descripcion = "POR VENTA ACUMULADA ASCENDENTE";
list.Add(entCombo);
entCombo = new Ent_Combo();
entCombo.cbo_codigo = "2";
entCombo.cbo_descripcion = "POR VENTA ACUMULADA DESCENDENTE";
list.Add(entCombo);
ViewBag.TipoReporte = list;
ViewBag.Pais = Session["PAIS"];
return(View());
}
else
{
var data = new Dat_Menu();
var items = data.navbarItems(_usuario.usu_id).ToList();
Session[Ent_Global._session_menu_user] = items;
#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)
{
var distrito = datArticuloStock.listar_distrito(Session["PAIS"].ToString());/*Filtra por pais -bataweb ecuador*/
var lista = datArticuloStock.listar_Departamento();
var obj = lista[0];
List <Departamento> listobj = new List <Departamento>();
listobj.Add(obj);
ViewBag.listDepartamento = lista;
ViewBag.General = listobj;
ViewBag.Usuario = _usuario.usu_nombre;
Dat_Orce get_orc = new Dat_Orce();
ViewBag.cadena = get_orc.lista_cadena(true);
ViewBag.distrito = distrito;
list = new List <Ent_Combo>();
entCombo = new Ent_Combo();
entCombo.cbo_codigo = "0";
entCombo.cbo_descripcion = "POR DEFECTO";
list.Add(entCombo);
entCombo = new Ent_Combo();
entCombo.cbo_codigo = "1";
entCombo.cbo_descripcion = "ASCENDENTE";
list.Add(entCombo);
entCombo = new Ent_Combo();
entCombo.cbo_codigo = "2";
entCombo.cbo_descripcion = "DESCENDENTE";
list.Add(entCombo);
ViewBag.TipoReporte = list;
return(View());
}
else
{
return(RedirectToAction("Login", "Control", new { returnUrl = return_view }));
}
}
}
}
