public bool DeleteUser(int userid) { DBFoodDataContext db = new DBFoodDataContext(); UserProfile userinfo = db.UserProfiles.FirstOrDefault(x => x.UserId == userid); if (userinfo == null) { return(false); } db.UserProfiles.DeleteOnSubmit(userinfo); db.SubmitChanges(); return(true); }
public bool DeleteFood(int id) { DBFoodDataContext db = new DBFoodDataContext(); Food food = db.Foods.FirstOrDefault(x => x.id == id); if (food == null) { return(false); } db.Foods.DeleteOnSubmit(food); db.SubmitChanges(); return(true); }
public bool InsertNewFood(string name, string type, int price) { try { DBFoodDataContext db = new DBFoodDataContext(); Food food = new Food(); food.name = name; food.type = type; food.price = price; db.Foods.InsertOnSubmit(food); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool AddUser(string username, string password, bool isactive) { try { DBFoodDataContext db = new DBFoodDataContext(); UserProfile userinfo = new UserProfile(); userinfo.UserName = username; userinfo.Password = password.Encrypt(); userinfo.IsActive = isactive; db.UserProfiles.InsertOnSubmit(userinfo); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool UpdateFood(int id, string name, string type, int price) { try { DBFoodDataContext db = new DBFoodDataContext(); Food food = db.Foods.FirstOrDefault(x => x.id == id); if (food == null) { return(false); } food.name = name; food.type = type; food.price = price; db.SubmitChanges(); return(true); } catch { return(false); } }
public bool UpdateUser(int userid, string username, string password, bool isactive) { try { DBFoodDataContext db = new DBFoodDataContext(); UserProfile userinfo = db.UserProfiles.FirstOrDefault(x => x.UserId == userid); if (userinfo == null) { return(false); } userinfo.UserName = username; userinfo.Password = password; userinfo.IsActive = isactive; db.SubmitChanges(); return(true); } catch { return(false); } }
public bool Login(string username, string password) { try { DBFoodDataContext db = new DBFoodDataContext(); UserProfile userinfo = db.UserProfiles.FirstOrDefault(x => x.UserName == username); if (userinfo == null) { return(false); } if (userinfo.Password == password.Encrypt()) { return(true); } else { return(false); } } catch { return(false); } }
public Food GetFood(int id) { DBFoodDataContext db = new DBFoodDataContext(); return(db.Foods.FirstOrDefault(x => x.id == id)); }
public List <Food> GetFoodList() { DBFoodDataContext db = new DBFoodDataContext(); return(db.Foods.ToList()); }
public UserProfile GetUser(int id) { DBFoodDataContext db = new DBFoodDataContext(); return(db.UserProfiles.FirstOrDefault(x => x.UserId == id)); }
public List <UserProfile> GetAllUser() { DBFoodDataContext db = new DBFoodDataContext(); return(db.UserProfiles.ToList()); }