/// <summary> /// Metodo para obtener la abreviatura del estado /// </summary> /// <param name="StateID">ID del estado</param> /// <returns>String</returns> public static String GetAbrevStateProvince(int StateID) { using (ViperDbContext db = new ViperDbContext()) { var abrev = db.StatesProvince.Where(x => x.Id == StateID).FirstOrDefault().Abrev; return(abrev); } }
/// <summary> /// Metodo para obtener el nombre del municipio /// </summary> /// <param name="cityID">ID Municipio</param> /// <returns>List</returns> public static String GetCityName(int cityID) { using (ViperDbContext db = new ViperDbContext()) { var abrev = db.Cities.Where(x => x.Id == cityID).FirstOrDefault().Description; return(abrev); } }
/// <summary> /// Metodo para obtener los tipos de vialidad /// </summary> /// <returns>List</returns> public static List <RoadType> GetRoadTypeDropDownList() { List <RoadType> items = new List <RoadType>(); using (ViperDbContext db = new ViperDbContext()) { items = db.RoadsType.ToList(); items.Add(new RoadType { Id = -1, Name = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener el estado civil de una persona /// </summary> /// <returns>List</returns> public static List <MaritalStatus> GetMaritalStatusDropDownList() { List <MaritalStatus> items = new List <MaritalStatus>(); using (ViperDbContext db = new ViperDbContext()) { items = db.MaritalsStatus.ToList(); items.Add(new MaritalStatus { Id = -1, Name = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener los proveedores registrados en la base de datos /// </summary> /// <returns>List</returns> public static List <Supplier> GetSupplierDropDownList() { List <Supplier> items = new List <Supplier>(); using (ViperDbContext db = new ViperDbContext()) { items = db.Suppliers.ToList(); items.Add(new Supplier { Id = -1, SupplierName = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener las subcategorias correspondientes a una categoria /// </summary> /// <param name="ProductCategoryID">ID Categoria</param> /// <returns>List</returns> public static List <ProductSubCategory> GetProductSubCategoryDropDownList(int ProductCategoryID) { List <ProductSubCategory> items = new List <ProductSubCategory>(); using (ViperDbContext db = new ViperDbContext()) { items = db.ProductsSubCategory.Where(x => x.ProductCategoryId == ProductCategoryID).ToList(); items.Add(new ProductSubCategory { Id = -1, Name = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener los municipios de Mexico /// </summary> /// <param name="StateProvinceID">ID Estado</param> /// <returns>List</returns> public static List <City> GetCityDropDownList(int StateProvinceID) { List <City> items = new List <City>(); using (ViperDbContext db = new ViperDbContext()) { items = db.Cities.Where(x => x.StateProvinceId == StateProvinceID).ToList(); items.Add(new City { Id = -1, Description = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener los estados de Mexico /// </summary> /// <returns>List</returns> public static List <StateProvince> GetStateProvinceDropDownList() { List <StateProvince> items = new List <StateProvince>(); using (ViperDbContext db = new ViperDbContext()) { items = db.StatesProvince.ToList(); items.Add(new StateProvince { Id = -1, Description = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
public static List <CountryRegion> GetCountryRegionDropDownList() { List <CountryRegion> items = new List <CountryRegion>(); using (ViperDbContext db = new ViperDbContext()) { items = db.CountriesRegion.ToList(); items.Add(new CountryRegion { Id = -1, Description = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener los puestos que puede tener un empleado /// </summary> /// <param name="DepartmentID">ID Departamento</param> /// <returns>List</returns> public static List <JobTitle> GetJobTitleDropDownList(int DepartmentID) { List <JobTitle> items = new List <JobTitle>(); using (ViperDbContext db = new ViperDbContext()) { items = db.JobsTitle.Where(x => x.DepartmentId == DepartmentID).ToList(); items.Add(new JobTitle { Id = -1, Name = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }
/// <summary> /// Metodo para obtener los horarios en los cuales puede trabajar un empleado /// </summary> /// <returns>List</returns> public static List <Shift> GetShiftDropDownList() { List <Shift> items = new List <Shift>(); using (ViperDbContext db = new ViperDbContext()) { items = db.Shifts.ToList(); items.Add(new Shift { Id = -1, Name = "--SELECCIONE--" }); return(items.OrderBy(x => x.Id).ToList()); } }