public void QueryDeleteUser(int UserID)
{
using (CompanyEntities db = new CompanyEntities())
{
db.Users_Delete(UserID);
}
}
public void QuerySaveUser(User user)
{
using (CompanyEntities db = new CompanyEntities())
{
db.Users_Insert(user.UserFirstName, user.UserLastName);
}
}
public void QueryEditUser(User user)
{
using (CompanyEntities db = new CompanyEntities())
{
db.Users_Update(user.UserID, user.UserFirstName, user.UserLastName);
}
}
public List <User> QueryGetUserList()
{
using (CompanyEntities db = new CompanyEntities())
{
IEnumerable <Users_SelectAll_Result> model = db.Users_SelectAll();
List <User> lstUsers = new List <User>();
foreach (var us in model)
{
User user = new User();
user.UserID = us.UserID;
user.UserFirstName = us.UserFirstName;
user.UserLastName = us.UserLastName;
lstUsers.Add(user);
}
return(lstUsers);
}
}
