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