public static AspNetUsers getProfile(string userID)
{
using (var db = new bygnuEntities())
{
return(db.AspNetUsers.Find(userID));
}
}
public static IList <product> searchProducts(string searchStr)
{
using (var db = new bygnuEntities())
{
return(db.product
.OrderBy(x => x.name)
.Where(x => x.name.Contains(searchStr))
.ToList());
}
}
public static IList <product> getDiscounted()
{
using (var db = new bygnuEntities())
{
return(db.product
.OrderBy(x => x.name)
.Where(x => x.isDiscounted == true)
.Take(6)
.ToList());
}
}
public static IList <product> getTopOffers()
{
using (var db = new bygnuEntities())
{
return(db.product
.OrderBy(x => x.name)
.Where(x => x.isTopOffer == true)
.Take(2)
.ToList());
}
}
public static IList <product> getProductList(int starting, int limit, string category)
{
using (var db = new bygnuEntities())
{
return(db.product
.Include("category")
.OrderBy(x => x.name)
.Where(x => x.category.name.Equals(category))
.Skip(starting)
.Take(limit)
.ToList());
}
}
public static void updateProfile(AspNetUsers user)
{
using (var db = new bygnuEntities())
{
AspNetUsers UserRecord = db.AspNetUsers.Find(user.Id);
UserRecord.FirstName = user.FirstName;
UserRecord.LastName = user.LastName;
UserRecord.Email = user.Email;
UserRecord.PhoneNumber = user.PhoneNumber;
UserRecord.CompanyName = user.CompanyName;
db.SaveChanges();
}
}
public static ICollection <category> getCategoryList()
{
using (var db = new bygnuEntities()) {
return(db.category.ToList());
}
}