public IHttpActionResult PosttblUserManagement(tblUserManagement tblUserManagement) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } bool traceID = db.tblEmployeesInfoes.Any(k => k.EmpId == tblUserManagement.UsersId); var preuser = db.tblEmployeesInfoes.ToList(); var exist = db.tblUserManagements.Where(u => u.UsersId == tblUserManagement.UsersId); if (preuser.Count() <= 0 || !traceID) { return(Json("no user")); } if (exist.Count() > 0) { return(Json("exist")); } else { tblUserManagement.CreatedBy = "CRTBY"; tblUserManagement.DateCreated = DateTime.Now; tblUserManagement.Status = 0; var data = db.tblEmployeesInfoes.Where(e => e.EmpId == tblUserManagement.UsersId).FirstOrDefault(); data.Status = 1; var aRole = db.tblUserManagements.Add(tblUserManagement); db.SaveChanges(); return(Json("good")); } //return CreatedAtRoute("DefaultApi", new { id = tblUserManagement.recNo }, tblUserManagement); }
public IHttpActionResult PuttblUserManagement(int id, tblUserManagement tblUserManagement) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblUserManagement.recNo) { return(BadRequest()); } db.Entry(tblUserManagement).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblUserManagementExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostAddCompany(Company comp) { //checking sa username var userExist = db.tblUserManagements.Where(u => u.UserName == comp.Username); if (userExist.Count() > 0) { return(BadRequest()); } else { tblUserManagement user = new tblUserManagement(); user.UserName = comp.Username; user.Password = comp.Password; user.RoleId = "2"; user.UsersId = Guid.NewGuid().ToString("N").Substring(0, 5).ToUpper(); user.DateCreated = DateTime.Now; user.Status = 1; db.Entry(user).State = EntityState.Added; tblBranchShop branch = new tblBranchShop(); branch.BranchName = comp.BranchName; branch.EmailAddress = comp.EmailAddress; branch.Address = comp.Address; branch.userID = user.UsersId; branch.BranchId = Guid.NewGuid().ToString("N").Substring(0, 5).ToUpper(); db.Entry(branch).State = EntityState.Added; db.SaveChanges(); return(Ok()); } }
public IHttpActionResult PutuRolechangeName(tblUserManagement tblUserManagement) { tblUserManagement.UpdatedBy = "UPDBY"; tblUserManagement.DateUpdated = DateTime.Now; db.Entry(tblUserManagement).State = EntityState.Modified; db.SaveChanges(); return(Json("success")); }
public IHttpActionResult GettblUserManagement(int id) { tblUserManagement tblUserManagement = db.tblUserManagements.Find(id); if (tblUserManagement == null) { return(NotFound()); } return(Ok(tblUserManagement)); }
public IHttpActionResult DeletetblUserManagement(int id) { tblUserManagement tblUserManagement = db.tblUserManagements.Find(id); if (tblUserManagement == null) { return(NotFound()); } db.tblUserManagements.Remove(tblUserManagement); db.SaveChanges(); return(Ok(tblUserManagement)); }
public IHttpActionResult PutsStatus(tblUserManagement tblUserManagement) { if (tblUserManagement.Status != 1) { tblUserManagement.Status = 1; } else { tblUserManagement.Status = 0; } tblUserManagement.UpdatedBy = "UPDBY"; tblUserManagement.DateUpdated = DateTime.Now; var switchery = db.Entry(tblUserManagement).State = EntityState.Modified; db.SaveChanges(); return(Json("success")); }