public bool DeleteInfo(string usernamedelinfo) { DBAlumniDataContext db = new DBAlumniDataContext(); info inf = db.infos.FirstOrDefault(x => x.username == usernamedelinfo); if (inf == null) { return(false); } db.infos.DeleteOnSubmit(inf); db.SubmitChanges(); return(true); }
public bool DeleteAcc(string usernamedelacc) { DBAlumniDataContext db = new DBAlumniDataContext(); account acc = db.accounts.FirstOrDefault(x => x.user == usernamedelacc); if (acc == null) { return(false); } db.accounts.DeleteOnSubmit(acc); DeleteInfo(usernamedelacc); db.SubmitChanges(); return(true); }
public bool InsertAcc(string name, string pass) { try { DBAlumniDataContext db = new DBAlumniDataContext(); account acc = new account(); acc.user = name; acc.passwords = pass; db.accounts.InsertOnSubmit(acc); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool UpdateAcc(string user, string pass) { { try { DBAlumniDataContext db = new DBAlumniDataContext(); //lấy food tồn tại ra account acc = db.accounts.FirstOrDefault(x => x.user == user); if (acc == null) { return(false); //không tồn tại false } acc.passwords = pass; db.SubmitChanges();//xác nhận chỉnh sửa return(true); } catch { return(false); } } }
public bool InsertInfo(string name, string job, int start, int end) { try { DBAlumniDataContext db = new DBAlumniDataContext(); if (db.accounts.FirstOrDefault(x => x.user == name) == null) { return(false); } info inf = new info(); inf.username = name; inf.job = job; inf.startyear = start; inf.endyear = end; db.infos.InsertOnSubmit(inf); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool UpdateInfo(string user, string job, int start, int end) { { try { DBAlumniDataContext db = new DBAlumniDataContext(); info inf = db.infos.FirstOrDefault(x => x.username == user); if (inf == null) { return(false); } inf.job = job; inf.startyear = start; inf.endyear = end; db.SubmitChanges();//xác nhận chỉnh sửa return(true); } catch { return(false); } } }
public info GetInfo(string nameinfo) { DBAlumniDataContext db = new DBAlumniDataContext(); return(db.infos.FirstOrDefault(x => x.username == nameinfo)); }
public account GetAcc(string nameacc) { DBAlumniDataContext db = new DBAlumniDataContext(); return(db.accounts.FirstOrDefault(x => x.user == nameacc)); }
public List <info> GetInfoList(char a) //de phan biet 2 ham getinfo va get acc { DBAlumniDataContext db = new DBAlumniDataContext(); return(db.infos.ToList()); }
public List <account> GetAccList() { DBAlumniDataContext db = new DBAlumniDataContext(); return(db.accounts.ToList()); }