public virtual int InsertUserDetails(MODEL.User user)
{
using (dbContext)
{
dbContext.Users.Add(new DAC.User()
{
Last_Name = user.LastName,
First_Name = user.FirstName,
Employee_ID = user.EmployeeId
});
return(dbContext.SaveChanges());
}
}
public virtual int DeleteUserDetails(MODEL.User user)
{
using (dbContext)
{
var editDetails = (from editUser in dbContext.Users
where editUser.User_ID == user.UserId
select editUser).First();
// Delete existing record
if (editDetails != null)
{
dbContext.Users.Remove(editDetails);
}
return(dbContext.SaveChanges());
}
}
public virtual int UpdateUserDetails(MODEL.User user)
{
using (dbContext)
{
var editDetails = (from editUser in dbContext.Users
where editUser.User_ID == user.UserId
select editUser).First();
// Modify existing records
if (editDetails != null)
{
editDetails.First_Name = user.FirstName;
editDetails.Last_Name = user.LastName;
editDetails.Employee_ID = user.EmployeeId;
}
return(dbContext.SaveChanges());
}
}
