public List <UserAccount> GetAll() { using (covid19Entities CoVID19db = new covid19Entities()) { return(CoVID19db.UserAccounts.ToList()); } }
public UserAccount GetByID(int id) { using (covid19Entities CoVID19db = new covid19Entities()) { return(CoVID19db.UserAccounts.Find(id)); } }
public void Update(UserAccount UserAccountObj) { using (covid19Entities CoVID19db = new covid19Entities()) { CoVID19db.UserAccounts.Attach(UserAccountObj); CoVID19db.Entry(UserAccountObj).State = System.Data.Entity.EntityState.Modified; CoVID19db.SaveChanges(); } }
public UserAccount Insert(UserAccount UserAccountObj) { using (covid19Entities CoVID19db = new covid19Entities()) { CoVID19db.UserAccounts.Add(UserAccountObj); CoVID19db.SaveChanges(); return(UserAccountObj); } }
public void Delete(UserAccount UserAccountObj) { using (covid19Entities CoVID19db = new covid19Entities()) { CoVID19db.UserAccounts.Attach(UserAccountObj); CoVID19db.UserAccounts.Remove(UserAccountObj); CoVID19db.SaveChanges(); } }