public ResponseMessage DeleteStructureType(int id) { ResponseMessage responseMessage = new ResponseMessage(); try { var structureType = _context.StructureType.Where(x => x.Id == id && x.IsDelete == false).FirstOrDefault(); if (structureType == null) { throw new ValueNotFoundException("Structure Type Id doesnt exist."); } structureType.IsDelete = true; _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "Structure Type", Message = string.Format("Structure Type Deleted Succussfully {0}", structureType.Id), CreatedAt = DateTime.Now, }; _commonRepo.AuditLog(audit); return(responseMessage = new ResponseMessage() { Message = "Structure Type deleted successfully." }); } catch (Exception ex) { throw ex; } }
public ResponseMessage DeleteIC(int id) { ResponseMessage responseMessage = new ResponseMessage(); try { var ic = _context.IndependentCompany.Where(x => x.Id == id && x.IsDelete == false).FirstOrDefault(); if (ic == null) { throw new ValueNotFoundException("Independent Comapany Id doesnt exist."); } ic.IsDelete = true; _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "Independent Comapny", Message = string.Format("Independent Company Deleted Successfully {0}", ic.Id), CreatedAt = DateTime.Now, }; _commonRepo.AuditLog(audit); return(responseMessage = new ResponseMessage() { Message = "Independent Company Deleted successfully." }); } catch (Exception ex) { throw ex; } }
public ResponseMessage DeleteStrategicBusiness(int id) { try { ResponseMessage response = new ResponseMessage(); var sbg = _context.StrategicBusiness.Where(x => x.Id == id && x.IsDelete == false).FirstOrDefault(); if (sbg != null) { sbg.IsDelete = true; _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "Strategic Business", Message = string.Format("Strategic Business Group deleted successfully {0}", sbg.Id), CreatedAt = DateTime.Now }; _commonRepo.AuditLog(audit); response.Message = "Strategic Business Group deleted successfully"; return(response); } else { throw new ValueNotFoundException("Strategic Business Group doenot exist"); } } catch (Exception ex) { throw ex; } }
public ResponseMessage DeleteVendor(int id) { ResponseMessage responseMessage = new ResponseMessage(); try { var vendor = _context.SubContractor.Where(x => x.Id == id && x.IsDelete == false).FirstOrDefault(); if (vendor == null) { throw new ValueNotFoundException("Vendor Id doesnt exist."); } vendor.IsDelete = true; _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "Vendor", Message = string.Format("Vendor Deleted Successfully {0}", vendor.Id), CreatedAt = DateTime.Now, }; _commonRepo.AuditLog(audit); return(responseMessage = new ResponseMessage() { Message = "Vendor deleted successfully." }); } catch (Exception ex) { throw ex; } }
public ResponseMessage CreateBU(AddBusinessUnit businessunit) { try { ResponseMessage responseMessage = new ResponseMessage(); // LoginUser lgnUSer = WebHelpers.GetLoggedUser(); using (var transaction = _context.Database.BeginTransaction()) { try { foreach (var item in businessunit.lstBussUnit) { if (_context.BusinessUnit.Where(x => x.Name == item.Name && x.IsDelete == false).Count() > 0) { throw new ValueNotFoundException("Business Unit Name already exist."); } BusinessUnit bizzUnit = new BusinessUnit(); bizzUnit.IcId = businessunit.IcId; bizzUnit.SbgId = businessunit.SbgId; bizzUnit.Name = item.Name; bizzUnit.IsActive = true; bizzUnit.IsDelete = false; bizzUnit.CreatedAt = DateTime.Now; bizzUnit.CreatedBy = 1; //TODO lgnUSer.Id; _context.BusinessUnit.Add(bizzUnit); } _context.SaveChanges(); responseMessage.Message = "Business Unit created sucessfully"; AuditLogs audit = new AuditLogs() { Action = "Business Unit", Message = string.Format("Business Unit Added Successfully"), CreatedAt = DateTime.Now, }; _commonRepo.AuditLog(audit); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } return(responseMessage); } catch (Exception ex) { throw ex; } }
public ResponseMessage UpdatePageAccess(List <PageAccess> pageAccessDetails) { ResponseMessage responseMessage = new ResponseMessage(); try { foreach (PageAccess pageAccess in pageAccessDetails) { var pageAccessFromDB = _context.RolesApplicationforms.Where(x => x.FormId == pageAccess.PageDetailId && x.RoleId == pageAccess.RoleId).FirstOrDefault(); pageAccessFromDB.IsAdd = pageAccess.PageDetail.IsAdd; pageAccessFromDB.IsDelete = pageAccess.PageDetail.IsDelete; pageAccessFromDB.IsUpdate = pageAccess.PageDetail.IsUpdate; pageAccessFromDB.IsView = pageAccess.PageDetail.IsView; _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "Role Management", Message = "PageAccess Updated Succussfully", CreatedAt = DateTime.Now, }; _commonRepo.AuditLog(audit); } return(responseMessage = new ResponseMessage() { Message = "Page Access updated successfully." }); } catch (Exception ex) { throw ex; } }
public ResponseMessage BulkInsertWBS(List <AddWorkBreakDown> lstWorkBreakDown) { try { foreach (AddWorkBreakDown wbs in lstWorkBreakDown) { WorkBreakdown wbData = new WorkBreakdown(); WorkBreakdown wbData1 = _context.WorkBreakdown.Where(x => x.WbsId == wbs.WorkBreakDownCode && x.ProjectId == wbs.ProjectId && x.Segment == wbs.Segment && x.SubSegment == wbs.SubSegment && x.Elements == wbs.Element && x.IsDelete == false).FirstOrDefault(); if (wbData1 == null) { wbData.WbsId = wbs.WorkBreakDownCode; wbData.Segment = wbs.Segment; wbData.SubSegment = wbs.SubSegment; wbData.Elements = wbs.Element; wbData.ProjectId = wbs.ProjectId; wbData.CreatedAt = DateTime.Now; wbData.CreatedBy = 1; //to do _context.WorkBreakdown.Add(wbData); _context.SaveChanges(); } } AuditLogs audit = new AuditLogs() { Action = "WBS Insert", Message = string.Format("WBS BulkUpload completed Succussfully"), CreatedBy = null, //TODO:will get from session }; _commonRepo.AuditLog(audit); return(new ResponseMessage() { Message = "WBS Bulk Upload Completed successfully.", }); } catch (Exception ex) { throw ex; } }
public ResponseMessage AddUser(UserDetails userDetails) { ResponseMessage responseMessage = new ResponseMessage(); try { userDetails.userId = 0; if (_context.Users.Where(x => x.Email == userDetails.email && x.IsDelete == false).Count() > 0) { throw new ValueNotFoundException("Email Id already exist."); } else if (_context.Users.Where(x => x.PsNo == userDetails.userName && x.IsDelete == false).Count() > 0) { throw new ValueNotFoundException("UserName already exist."); } else { Users userDtls = _mapper.Map <Users> (userDetails); userDtls.IsActive = true; _context.Users.Add(userDtls); _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "User", Message = string.Format("New User added Succussfully {0}", userDetails.userName), CreatedAt = DateTime.Now, CreatedBy = userDetails.createdBy }; _commonRepo.AuditLog(audit); return(responseMessage = new ResponseMessage() { Message = "User added successfully." }); } } catch (Exception ex) { throw ex; } }
public ResponseMessage UpdateScrapStructure(AddScrapStructure scrapStructure, int id) { ResponseMessage responseMessage = new ResponseMessage(); try { var scrapStructureDB = _context.ScrapStructure.Where(x => x.Id == id && x.IsDelete == false).FirstOrDefault(); if (scrapStructureDB != null) { scrapStructureDB.SubconId = scrapStructure.SubconId; scrapStructureDB.ProjStructId = scrapStructure.ProjStructId; scrapStructureDB.ScrapRate = scrapStructure.ScrapRate; scrapStructureDB.AuctionId = scrapStructure.AuctionId; scrapStructureDB.Status = commonEnum.ScrapStatus.SCRAPPED.ToString(); scrapStructureDB.UpdatedBy = 1; //TODO scrapStructureDB.UpdatedAt = DateTime.Now; _context.SaveChanges(); var projStruct = _context.ProjectStructure.Where(x => x.Id == scrapStructure.ProjStructId).FirstOrDefault(); projStruct.CurrentStatus = Util.GetDescription(commonEnum.StructureInternalStatus.SCRAPPED).ToString(); projStruct.UpdatedAt = DateTime.Now; projStruct.UpdatedBy = 1;//TODO _context.SaveChanges(); AuditLogs audit = new AuditLogs() { Action = "Scrap Structure", Message = string.Format("Scrap Structure Updated Successfully {0}", id), CreatedAt = DateTime.Now, CreatedBy = 1 //TODO }; _commonRepo.AuditLog(audit); return(responseMessage = new ResponseMessage() { Message = "Scrap Structure updated successfully.", }); } else { throw new ValueNotFoundException("Scrap Structure not available."); } } catch (Exception ex) { throw ex; } }