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)); }