public bool DeleteFood(String name)
{
DBUnblockMeDataContext db = new DBUnblockMeDataContext();
//lấy food tồn tại ra
account acc = db.accounts.FirstOrDefault(x => x.username == name);
if (acc == null)
{
return(false);
}
db.accounts.DeleteOnSubmit(acc);
db.SubmitChanges();
return(true);
}
public bool InsertNewAcc(string username, string password)
{
try
{
DBUnblockMeDataContext db = new DBUnblockMeDataContext();
account acc = new account();
acc.username = username;
acc.password = password;
acc.level = 1;
db.accounts.InsertOnSubmit(acc);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateLevel(string name, int level)
{
try
{
DBUnblockMeDataContext db = new DBUnblockMeDataContext();
//lấy food tồn tại ra
account acc = db.accounts.FirstOrDefault(x => x.username == name);
if (acc == null)
{
return(false); //không tồn tại false
}
acc.username = name;
acc.level = level;
db.SubmitChanges();//xác nhận chỉnh sửa
return(true);
}
catch
{
return(false);
}
}
public account GetAcc(String username)
{
DBUnblockMeDataContext db = new DBUnblockMeDataContext();
return(db.accounts.FirstOrDefault(x => x.username == username));
}
public List <account> GetAccLists()
{
DBUnblockMeDataContext db = new DBUnblockMeDataContext();
return(db.accounts.ToList());
}
