public static M_UserViewModel GetById(int id)
{
M_UserViewModel result = new M_UserViewModel();
using (var db = new MarcomContext())
{
result = (from u in db.m_user
join r in db.m_role on
u.m_role_id equals r.id
join e in db.m_employee on
u.m_employee_id equals e.id
join c in db.m_company on
e.m_company_id equals c.id
where u.id == id
select new M_UserViewModel
{
Id = u.id,
Username = u.username,
Password = u.password,
MRoleId = u.m_role_id,
RoleName = r.name,
MEmployeeId = e.id,
FirstName = e.first_name,
MCompanyId = c.id,
CompanyName = c.name,
CreatedBy = u.created_by,
CreatedDate = u.created_date,
IsDelete = false
}).FirstOrDefault();
}
return(result);
}
public static Responses Update(M_UserViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_user mUser = db.m_user.Where(u => u.id == entity.Id).FirstOrDefault();
if (mUser != null)
{
mUser.username = entity.Username;
mUser.password = entity.Password;
mUser.m_employee_id = entity.MEmployeeId;
mUser.m_role_id = entity.MRoleId;
mUser.updated_by = "Admin";
mUser.updated_date = DateTime.Now;
mUser.is_delete = false;
db.SaveChanges();
}
}
else
{
m_user mUser = new m_user();
mUser.username = entity.Username;
mUser.password = entity.Password;
mUser.m_employee_id = entity.MEmployeeId;
mUser.m_role_id = entity.MRoleId;
mUser.created_by = "Admin";
mUser.created_date = DateTime.Now;
mUser.is_delete = false;
db.m_user.Add(mUser);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
// PUT: api/M_Users/5
public Responses Put(int id, [FromBody] M_UserViewModel entity)
{
entity.Id = id;
return(M_UserRepo.Update(entity));
}
// POST: api/M_Users
public Responses Post([FromBody] M_UserViewModel entity)
{
return(M_UserRepo.Update(entity));
}
