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