public TblUser GetUserById(int UserId)
{
using (var context = new DryFruitsServicesDBContext())
{
var user = context.TblUser.Where(x => x.UserId == UserId).FirstOrDefault();
return(user);
}
}
public List <TblUser> GetAllUsers()
{
using (var context = new DryFruitsServicesDBContext())
{
var users = context.TblUser.ToList();
return(users);
}
}
public void AddUser(TblUser user)
{
using (var context = new DryFruitsServicesDBContext())
{
context.TblUser.Add(user);
context.SaveChanges();
}
}
public void DeleteUser(int userId)
{
using (var context = new DryFruitsServicesDBContext())
{
var user = context.TblUser.Find(userId);
context.TblUser.Remove(user);
context.SaveChanges();
}
}
public void UpdateUser(TblUser user)
{
using (var context = new DryFruitsServicesDBContext())
{
var updateUser = context.TblUser.Find(user.UserId);
updateUser.UserMobileNumber = user.UserMobileNumber;
updateUser.UserEmail = user.UserEmail;
updateUser.UserIsActive = user.UserIsActive;
updateUser.UserUpdated = DateTime.Now;
updateUser.UserPassword = user.UserPassword;
//context.Update(updateUser);
context.SaveChanges();
}
}
