public int InsertUserDetails(MODEL.User user)
{
using (dbcontext)
{
dbcontext.Users.Add(new Datalayer.User()
{
Last_Name = user.LastName,
First_Name = user.FirstName,
Employee_ID = user.EmployeeId
});
return(dbcontext.SaveChanges());
}
}
public int DeleteUserDetails(MODEL.User user)
{
using (dbcontext)
{
var editDetails = (from editUser in dbcontext.Users
where editUser.User_ID == user.UserId
select editUser).First();
if (editDetails != null)
{
dbcontext.Users.Remove(editDetails);
}
return(dbcontext.SaveChanges());
}
}
public int UpdateUserDetails(MODEL.User user)
{
using (dbcontext)
{
var editDetails = (from editUser in dbcontext.Users
where editUser.User_ID == user.UserId
select editUser).First();
//if data exists update
if (editDetails != null)
{
editDetails.First_Name = user.FirstName;
editDetails.Last_Name = user.LastName;
editDetails.Employee_ID = user.EmployeeId;
}
return(dbcontext.SaveChanges());
}
}
