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