public void CreateUser(AdminCreateUserViewModel user)
{
try
{
User newuser = new User()
{
First_Name = user.First_Name,
Last_Name = user.Last_Name,
Email = user.Email,
Password = user.Password,
Reg_Date = DateTime.Now,
Last_Date = DateTime.Now,
Delete_Date = DateTime.MaxValue,
Status = 0,
};
db.User.InsertOnSubmit(newuser);
db.SubmitChanges();
User_in_Role usinrole = new User_in_Role()
{
User_id = newuser.id,
Role_id = (from r in db.Role where r.Role_Name == user.Role select r.id).First()
};
db.UserInRole.InsertOnSubmit(usinrole);
db.SubmitChanges();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
public void CreateUser(User user, int role_id)
{
try
{
db.User.InsertOnSubmit(user);
db.SubmitChanges();
User_in_Role usinrole = new User_in_Role()
{
User_id = user.id, Role_id = role_id
};
db.UserInRole.InsertOnSubmit(usinrole);
db.SubmitChanges();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
public void SaveChanges(AdminPanelViewModel user)
{
try
{
User us = (from u in db.User where user.id == u.id select u).First();
us.First_Name = user.First_Name;
us.Last_Name = user.Last_Name;
us.Email = user.Email;
db.SubmitChanges();
User_in_Role uir = (from i in db.UserInRole where user.id == i.User_id select i).First();
uir.Role_id = (from r in db.Role where r.Role_Name == user.Role select r.id).First();
db.SubmitChanges();
}
catch (Exception ex)
{
logger.Error(ex.Message + " for user:" + user.id);
}
}
