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