public Result UpdateSubUser(subUserDetails inSubUser) { try { int?count = 0; using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context()) { count = db1.InConfiguration.Where(x => x.ConfId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Select(x => x.Branch).FirstOrDefault(); } InBranch inBranch1 = new InBranch(); using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context()) { var Bcount = db.InSubUser.Where(x => x.ConfigId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId && x.Id != inSubUser.Id).Count(); if (Bcount < count) { var data = db.InSubUser.Where(x => x.Id == inSubUser.Id && x.EmpId == inSubUser.EmpId).FirstOrDefault(); data.ConfigId = inSubUser.ConfigId; data.SubUserName = inSubUser.SubUserName; data.EmpId = inSubUser.EmpId; data.EmailId = inSubUser.EmailId; data.UpdatedBy = inSubUser.CreatedBy; data.UpdatedDate = inSubUser.CreatedDate; var result = db.SaveChanges(); if (result == 1) { return(new Result { StatusCode = 1, Message = "Sub User Updated successfully..!" }); } else { return(new Result { StatusCode = -1, Message = "Sub User Failed..!" }); } } else { return(new Result { StatusCode = -1, Message = "Sub User count cannot be more than Configuration Count.!" }); } } } catch (Exception ex) { return(new Result { StatusCode = -1, Message = ex.Message }); throw ex; } }
public Result AddSubUser(subUserDetails inSubUser) { try { int?count = 0; using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context()) { count = db1.InConfiguration.Where(x => x.ConfId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Select(x => x.UserCount).FirstOrDefault(); } InSubUser inSubUser1 = new InSubUser(); using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context()) { var Bcount = db.InSubUser.Where(x => x.ConfigId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Where(x => x.IsActive == true).Count(); if (Bcount < count) { inSubUser1.ConfigId = inSubUser.ConfigId; inSubUser1.EmpId = inSubUser.EmpId; inSubUser1.SubUserName = inSubUser.SubUserName; inSubUser1.CreatedBy = inSubUser.CreatedBy; inSubUser1.CreatedDate = inSubUser.CreatedDate; inSubUser1.EmailId = inSubUser.EmailId; db.InSubUser.Add(inSubUser1); var result = db.SaveChanges(); if (result == 1) { return(new Result { StatusCode = 1, Message = "Sub User Added successfully..!" }); } else { return(new Result { StatusCode = -1, Message = "Sub User Failed..!" }); } } else { return(new Result { StatusCode = -1, Message = "Sub User count cannot be more than Configuration Count.!" }); } } } catch (Exception ex) { return(new Result { StatusCode = -1, Message = ex.Message }); throw ex; } }
public IActionResult UpdateSubUser([FromBody] PostModel inUsers) { subUserDetails obj = JsonConvert.DeserializeObject <subUserDetails>(inUsers.Key); try { var result = _subUser.UpdateSubUser(obj); return(Ok(result)); } catch (Exception ex) { throw; } }