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 AddBranch(InBranchDetails inBranch) { try { int?count = 0; using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context()) { count = db1.ConfigurationMaster.Where(x => x.ConfigId == inBranch.ConfigId).Select(x => x.NoOfBranches).FirstOrDefault(); } InBranch inBranch1 = new InBranch(); using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context()) { var Bcount = db.InBranch.Where(x => x.ConfigId == inBranch.ConfigId && x.EmpId == inBranch.EmpId && x.BranchId != inBranch.BranchId).Where(x => x.IsActive == true).Count(); if (Bcount < count) { inBranch1.BranchName = inBranch.BranchName; inBranch1.Location = inBranch.Location; inBranch1.Address = inBranch.Address; inBranch1.ContactNumber1 = inBranch.ContactNumber1; inBranch1.ContactNumber2 = inBranch.ContactNumber2; inBranch1.Email = inBranch.Email; inBranch1.ContactPerson = inBranch.ContactPerson; inBranch1.BranchCode = inBranch.BranchCode; inBranch1.Gstin = inBranch.Gstin; inBranch1.State = inBranch.State; inBranch1.District = inBranch.District; inBranch1.Smsapiurl = inBranch.Smsapiurl; inBranch1.Apikey = inBranch.Apikey; inBranch1.SenderId = inBranch.SenderId; inBranch1.BranchLogo = inBranch.BranchLogo; inBranch1.PrintHeaderFile = inBranch.PrintHeaderFile; inBranch1.PrintFooterFile = inBranch.PrintFooterFile; inBranch1.CreatedBy = inBranch.CreatedBy; inBranch1.CreatedDate = inBranch.CreatedDate; inBranch1.EmpId = inBranch.EmpId; inBranch1.ConfigId = inBranch.ConfigId; db.InBranch.Add(inBranch1); var result = db.SaveChanges(); if (result == 1) { return(new Result { StatusCode = 1, Message = "Branch Added successfully..!" }); } else { return(new Result { StatusCode = -1, Message = "Branch Failed..!" }); } } else { return(new Result { StatusCode = -1, Message = "Branch count cannot be more than Configuration Count.!" }); } } } catch (Exception ex) { return(new Result { StatusCode = -1, Message = ex.Message }); throw ex; } }