public UserInformation GetUserInformation(int userId)
{
using (GainCallDBEntities gainCallDbEntities = new GainCallDBEntities())
{
return(gainCallDbEntities.UserInformations.FirstOrDefault(user => user.UserId == userId));
}
}
public List <ProductType> GetProductTypes()
{
using (GainCallDBEntities gainCallDBEntities = new GainCallDBEntities())
{
return(gainCallDBEntities.ProductTypes.ToList());
}
}
public State GetState(int stateId)
{
using (GainCallDBEntities dbEntities = new GainCallDBEntities())
{
return(dbEntities.States.FirstOrDefault(state => state.StateId == stateId));
}
}
public List <State> GetStates()
{
using (GainCallDBEntities dbEntities = new GainCallDBEntities())
{
return(dbEntities.States.ToList());
}
}
public List <Product> GetProductDetails()
{
using (GainCallDBEntities gainCallDbEntities = new GainCallDBEntities())
{
return(gainCallDbEntities.Products.ToList());
}
}
public List <Product> GetSearchProducts()
{
using (GainCallDBEntities gainCallDBEntities = new GainCallDBEntities())
{
return(gainCallDBEntities.Products.ToList());
}
}
public List <Gender> Getgender()
{
using (GainCallDBEntities gainCallDBEntities = new GainCallDBEntities())
{
return(gainCallDBEntities.Genders.ToList());
}
}
public List<City> GetCities( int stateId)
{
using(GainCallDBEntities gainCallDBEntities=new GainCallDBEntities())
{
return gainCallDBEntities.Cities.Where(city => city.StateId == stateId).ToList();
}
}
