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