public LoginViewModel Insert(LoginViewModel loginViewModel)
{
try
{
var user = _db.ONNET_USER.FirstOrDefault(u => u.Username == loginViewModel.Username && u.Password == loginViewModel.Password);
if (user == null)
{
var newuser = new ONNET_USER
{
Username = loginViewModel.Username,
//Password = Encrypt(new LoginViewModel
//{
Password = loginViewModel.Password,
//}),
Email = null,
Mobile = null,
Department = null,
Title = null,
Status = null,
RoleId = 3
};
using (MaxisEntities _db = new MaxisEntities())
{
_db.ONNET_USER.Add(newuser);
_db.SaveChanges();
}
var role = (from ep in _db.ONNET_USER
join e in _db.ONNET_USERROLE on ep.RoleId equals e.RoleId
where loginViewModel.Username == ep.Username
select new LoginViewModel()
{
Roles = e.RoleName,
RoleId = e.RoleId
}).Single();
return(role);
}
else
{
var role = (from ep in _db.ONNET_USER
join e in _db.ONNET_USERROLE on ep.RoleId equals e.RoleId
where loginViewModel.Username == ep.Username
select new LoginViewModel()
{
Roles = e.RoleName,
RoleId = e.RoleId
}).Single();
return(role);
}
}
catch (Exception)
{
throw;
}
}
