public ActionResult SaveActivation(JobActivationChecklist model)
{
string errors = String.Empty;
try
{
if (ModelState.IsValid)
{
var result = ChecklistDal.saveJobActivation(model);
if (result > 0)
{
Session["PRJID"] = model.PRJID;
model.recordExists = new Guid().ToString();
LoadActivationLookup(model);
return(View("index", model));
}
}
else
{
errors = GetModelError(errors);
}
LoadActivationLookup(model);
return(View("index", model));
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex.Message + BusinessConstants.contactAdmin);
LoadActivationLookup(model);
return(RedirectToAction("error"));
}
}
public ActionResult JobChecklist(string PRJID)
{
int ProjectHeaderID = 0;
if (!string.IsNullOrWhiteSpace(PRJID) && Int32.TryParse(PRJID, out ProjectHeaderID))
{
Session["PRJID"] = ProjectHeaderID;
}
if (Session["PRJID"] != null)
{
ViewBag.Title = string.Format("{0}", Session["PRJID"]);
var model = new JobActivationChecklist();
if (ProjectHeaderID > 0)
{
model.PRJID = ProjectHeaderID;
model = ChecklistDal.getProjectActivationDetails(model);
LoadActivationLookup(model);
}
return(View("index", model));
}
else
{
return(RedirectToAction("error", new Exception("Data Not Found")));
}
}
public static JobActivationChecklist JobActivationLookup(JobActivationChecklist objActivation)
{
try
{
var resultSet = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure,
"spATL_PRJ_JobActChkLst_LkUp",
new SqlParameter("@PRJID", objActivation.PRJID));
objActivation.ListCustomersTypes = new List <DOC08_CustomerType>();
foreach (DataRow item in resultSet.Tables[0].Rows)
{
var customer = new DOC08_CustomerType();
customer.CustomerTypeID = Convert.ToInt32(item["CustomerTypeId"]);
customer.Description = Convert.ToString(item["Description"]);
objActivation.ListCustomersTypes.Add(customer);
}
objActivation.ListJobTypes = new List <DOC09_JobTypes>();
foreach (DataRow item in resultSet.Tables[1].Rows)
{
var jobType = new DOC09_JobTypes();
jobType.JobTypeId = Convert.ToInt32(item["JobTypeId"]);
jobType.JobTypeDesc = Convert.ToString(item["JobTypeDesc"]);
objActivation.ListJobTypes.Add(jobType);
}
objActivation.ListResponses = new List <DOC10_Responses>();
foreach (DataRow item in resultSet.Tables[2].Rows)
{
var response = new DOC10_Responses();
response.ResponseId = Convert.ToInt32(item["ResponseId"]);
response.Response = Convert.ToString(item["Response"]);
objActivation.ListResponses.Add(response);
}
objActivation.ListLabourTypes = new List <SYS10_MhRates>();
foreach (DataRow item in resultSet.Tables[3].Rows)
{
var labourType = new SYS10_MhRates();
labourType.MhRateId = Convert.ToString(item["MhRateId"]);
labourType.MhRateName = Convert.ToString(item["MhRateName"]);
objActivation.ListLabourTypes.Add(labourType);
}
objActivation.ListUsers = new List <Sys_UsersData>();
foreach (DataRow item in resultSet.Tables[4].Rows)
{
var usersData = new Sys_UsersData();
usersData.UserId = Convert.ToInt32(item["UserId"]);
usersData.Name = Convert.ToString(item["Name"]);
objActivation.ListUsers.Add(usersData);
}
foreach (DataRow item in resultSet.Tables[5].Rows)
{
objActivation.PRJID = Convert.ToInt32(item["ProjectHeaderId"]);
objActivation.projectInformation.JobNumber = Convert.ToString(item["Atlas_Job_Number"]);
objActivation.projectInformation.CompanyName = Convert.ToString(item["Atlas_Company_Name"]);
objActivation.projectInformation.CustomerProfile = new Profile();
objActivation.projectInformation.CustomerProfile.Name = Convert.ToString(item["Contractor_Name"]);
objActivation.projectInformation.CustomerProfile.Address = Convert.ToString(item["Contractor_Address"]);
objActivation.projectInformation.CustomerProfile.City = Convert.ToString(item["Contractor_City"]);
objActivation.projectInformation.CustomerProfile.State = Convert.ToString(item["Contractor_State"]);
objActivation.projectInformation.CustomerProfile.Zip = Convert.ToString(item["Contractor_Zip"]);
objActivation.projectInformation.CustomerProfile.PhoneNumber = Convert.ToString(item["Contractor_Phone"]);
//TODO: Check Ext, Contact
//objActivation.projectInformation.CustomerProfile.Extension = Convert.ToString(item["Contractor_PhoneExt"]);
//objActivation.projectInformation.CustomerProfile.ContactName = Convert.ToString(item["Contractor_Contact"]);
objActivation.projectInformation.ProjectProfile = new Profile();
objActivation.projectInformation.ProjectProfile.Name = Convert.ToString(item["JobName"]);
objActivation.projectInformation.ProjectProfile.Address = Convert.ToString(item["JobAddress"]);
objActivation.projectInformation.ProjectProfile.City = Convert.ToString(item["JobCity"]);
objActivation.projectInformation.ProjectProfile.State = Convert.ToString(item["JobState"]);
objActivation.projectInformation.ProjectProfile.Zip = Convert.ToString(item["JobZip"]);
objActivation.projectInformation.ProjectProfile.PhoneNumber = Convert.ToString(item["JobPhone"]);
//TODO:
//objActivation.projectInformation.ProjectProfile.Extension = Convert.ToString(item["Job_PhoneExt"]);
objActivation.projectInformation.ProjectProfile.ContactName = Convert.ToString(item["JobContact"]);
objActivation.projectInformation.Estimator = Convert.ToString(item["EstimatorsName"]);
}
if (resultSet.Tables[5].Rows.Count == 0)
{
objActivation.PRJID = 0;
}
}
catch (Exception ex)
{
Logger.SaveErr(ex);
throw ex;
}
return(objActivation);
}
internal static int saveJobActivation(JobActivationChecklist model)
{
int result = 0;
try
{
List <SqlParameter> parametersList = new List <SqlParameter>();
parametersList.Add(new SqlParameter("@PRJID", model.PRJID));
parametersList.Add(new SqlParameter("@CustomerTypeID", model.projectInformation.CustomerType));
parametersList.Add(new SqlParameter("@JobTypeId", model.projectInformation.Jobtype));
parametersList.Add(new SqlParameter("@CustomerBid_JobNum", model.projectInformation.CustomerBidReference));
parametersList.Add(new SqlParameter("@Scope", model.projectInformation.ScopeWorkToBePerformed));
parametersList.Add(new SqlParameter("@LabourType", model.projectInformation.TypeOfLabour));
parametersList.Add(new SqlParameter("@Contract", model.contractPaperWork.CopyOfContractorPO));
parametersList.Add(new SqlParameter("@ContractComments", model.contractPaperWork.CopyOfContractorPOComments));
parametersList.Add(new SqlParameter("@ScopePhased", model.contractPaperWork.BrokenScopephases));
parametersList.Add(new SqlParameter("@ScopePhasedComments", model.contractPaperWork.BrokenScopephasesComments));
parametersList.Add(new SqlParameter("@BIRollups", model.contractPaperWork.BidRollUp));
parametersList.Add(new SqlParameter("@BIRollupsComments", model.contractPaperWork.BidRollUpComments));
parametersList.Add(new SqlParameter("@Packslip", model.contractPaperWork.PackCFSPIRollUp));
parametersList.Add(new SqlParameter("@PackslipComments", model.contractPaperWork.PackCFSPIRollUpcomments));
parametersList.Add(new SqlParameter("@Quotes", model.contractPaperWork.ApplicableQuote));
parametersList.Add(new SqlParameter("@QuotesComments", model.contractPaperWork.ApplicableQuoteComments));
parametersList.Add(new SqlParameter("@Drawings", model.contractPaperWork.DrawingConditions));
parametersList.Add(new SqlParameter("@DrawingsComments", model.contractPaperWork.DrawingConditionsComments));
parametersList.Add(new SqlParameter("@Photos", model.contractPaperWork.SitePhotos));
parametersList.Add(new SqlParameter("@PhotoComments", model.contractPaperWork.SitePhotosComments));
parametersList.Add(new SqlParameter("@HardCard", model.contractPaperWork.HardCard));
parametersList.Add(new SqlParameter("@HardCardComments", model.contractPaperWork.HardCardComments));
parametersList.Add(new SqlParameter("@PayEnvelope", model.contractPaperWork.PayEnvelope));
parametersList.Add(new SqlParameter("@PayEnvelopeComments", model.contractPaperWork.PayEnvelopeComments));
parametersList.Add(new SqlParameter("@Bonding", model.bondingInsurance.InsuranceCertification));
parametersList.Add(new SqlParameter("@BondingComments", model.bondingInsurance.InsuranceCertificationComments));
parametersList.Add(new SqlParameter("@SafetyOfficer", model.safetyRequirements.SafetyOfficer));
parametersList.Add(new SqlParameter("@SafetyOfficerComments", model.safetyRequirements.SafetyOfficerComments));
parametersList.Add(new SqlParameter("@PreStartSafetyMeeting", model.safetyRequirements.SafetyMeeting));
parametersList.Add(new SqlParameter("@PreStartSafetyMeetingComments", model.safetyRequirements.SafetyMeetingComments));
parametersList.Add(new SqlParameter("@DailySafetyMeetings", model.safetyRequirements.DailySafetyMeeting));
parametersList.Add(new SqlParameter("@DailySafetyMeetingComments", model.safetyRequirements.DailySafetyMeetingComments));
parametersList.Add(new SqlParameter("@PPE", model.safetyRequirements.PPENeeded));
parametersList.Add(new SqlParameter("@PPEComments", model.safetyRequirements.PPENeededComments));
parametersList.Add(new SqlParameter("@Fall", model.safetyRequirements.FallProtection));
parametersList.Add(new SqlParameter("@FallComments", model.safetyRequirements.FallProtectionComments));
parametersList.Add(new SqlParameter("@EquipCerts", model.safetyRequirements.EquipmentCertification));
parametersList.Add(new SqlParameter("@EquipCertComments", model.safetyRequirements.EquipmentCertificationComments));
parametersList.Add(new SqlParameter("@OtherHaz", model.safetyRequirements.OtherHazards));
parametersList.Add(new SqlParameter("@OtherHazComments", model.safetyRequirements.OtherHazardsComments));
parametersList.Add(new SqlParameter("@OtherComments", model.otherImportantFactors.OtherPertinentInformation));
parametersList.Add(new SqlParameter("@ApprovedBy", Convert.ToInt32(model.ApprovedBy)));
parametersList.Add(new SqlParameter("@DateCompleted", model.DateCompleted));
parametersList.Add(new SqlParameter("@DateReviewed", model.DateReviewed));
var id = SqlHelper.ExecuteNonQuery(_myConnection, CommandType.StoredProcedure, "spATL_PRJ_JobActChkLst_InsUpd",
parametersList.ToArray());
result = (Convert.ToInt32(id) == -1) ? 1 : result;
}
catch (Exception ex)
{
Logger.SaveErr(ex);
}
return(result);
}
internal static JobActivationChecklist getProjectActivationDetails(JobActivationChecklist objActivation)
{
try
{
var resultSet = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure,
"spATL_PRJ_JobActChkLst_GetDtls",
new SqlParameter("@PRJID", objActivation.PRJID));
objActivation.projectInformation = new ProjectInformation();
objActivation.contractPaperWork = new ContractPaperWork();
objActivation.bondingInsurance = new BondingInsurance();
objActivation.safetyRequirements = new SafetyRequirements();
objActivation.otherImportantFactors = new OtherImportantFactors();
foreach (DataRow item in resultSet.Tables[0].Rows)
{
objActivation.recordExists = new Guid().ToString();
objActivation.projectInformation.CustomerType = Convert.ToString(item["CustomerTypeID"]);
objActivation.projectInformation.Jobtype = Convert.ToString(item["JobTypeId"]);
objActivation.projectInformation.CustomerBidReference = Convert.ToString(item["CustomerBid_JobNum"]);
objActivation.projectInformation.ScopeWorkToBePerformed = Convert.ToString(item["Scope"]);
objActivation.projectInformation.TypeOfLabour = Convert.ToString(item["LabourType"]);
objActivation.contractPaperWork.CopyOfContractorPO = Convert.ToString(item["Contract"]);
objActivation.contractPaperWork.CopyOfContractorPOComments = Convert.ToString(item["ContractComments"]);
objActivation.contractPaperWork.BrokenScopephases = Convert.ToString(item["ScopePhased"]);
objActivation.contractPaperWork.BrokenScopephasesComments = Convert.ToString(item["ScopePhasedComments"]);
objActivation.contractPaperWork.BidRollUp = Convert.ToString(item["BIRollups"]);
objActivation.contractPaperWork.BidRollUpComments = Convert.ToString(item["BIRollupsComments"]);
objActivation.contractPaperWork.PackCFSPIRollUp = Convert.ToString(item["Packslip"]);
objActivation.contractPaperWork.PackCFSPIRollUpcomments = Convert.ToString(item["PackslipComments"]);
objActivation.contractPaperWork.ApplicableQuote = Convert.ToString(item["Quotes"]);
objActivation.contractPaperWork.ApplicableQuoteComments = Convert.ToString(item["QuotesComments"]);
objActivation.contractPaperWork.SitePhotos = Convert.ToString(item["Photos"]);
objActivation.contractPaperWork.SitePhotosComments = Convert.ToString(item["PhotoComments"]);
objActivation.contractPaperWork.DrawingConditions = Convert.ToString(item["Drawings"]);
objActivation.contractPaperWork.DrawingConditionsComments = Convert.ToString(item["DrawingsComments"]);
objActivation.contractPaperWork.HardCard = Convert.ToString(item["HardCard"]);
objActivation.contractPaperWork.HardCardComments = Convert.ToString(item["HardCardComments"]);
objActivation.contractPaperWork.PayEnvelope = Convert.ToString(item["PayEnvelope"]);
objActivation.contractPaperWork.PayEnvelopeComments = Convert.ToString(item["PayEnvelopeComments"]);
objActivation.bondingInsurance.InsuranceCertification = Convert.ToString(item["Bonding"]);
objActivation.bondingInsurance.InsuranceCertificationComments = Convert.ToString(item["BondingComments"]);
objActivation.safetyRequirements.SafetyOfficer = Convert.ToString(item["SafetyOfficer"]);
objActivation.safetyRequirements.SafetyOfficerComments = Convert.ToString(item["SafetyOfficerComments"]);
objActivation.safetyRequirements.SafetyMeeting = Convert.ToString(item["PreStartSafetyMeeting"]);
objActivation.safetyRequirements.SafetyMeetingComments = Convert.ToString(item["PreStartSafetyMeetingComments"]);
objActivation.safetyRequirements.DailySafetyMeeting = Convert.ToString(item["DailySafetyMeetings"]);
objActivation.safetyRequirements.DailySafetyMeetingComments = Convert.ToString(item["DailySafetyMeetingComments"]);
objActivation.safetyRequirements.PPENeeded = Convert.ToString(item["PPE"]);
objActivation.safetyRequirements.PPENeededComments = Convert.ToString(item["PPEComments"]);
objActivation.safetyRequirements.FallProtection = Convert.ToString(item["Fall"]);
objActivation.safetyRequirements.FallProtectionComments = Convert.ToString(item["FallComments"]);
objActivation.safetyRequirements.EquipmentCertification = Convert.ToString(item["EquipCerts"]);
objActivation.safetyRequirements.EquipmentCertificationComments = Convert.ToString(item["EquipCertComments"]);
objActivation.safetyRequirements.OtherHazards = Convert.ToString(item["OtherHaz"]);
objActivation.safetyRequirements.OtherHazardsComments = Convert.ToString(item["OtherHazComments"]);
objActivation.otherImportantFactors.OtherPertinentInformation = Convert.ToString(item["OtherComments"]);
objActivation.ApprovedBy = Convert.ToString(item["Approved"]);
objActivation.DateCompleted = Convert.ToDateTime(item["DateCompleted"]).ToShortDateString();
objActivation.DateReviewed = Convert.ToDateTime(item["ApprovedDate"]).ToShortDateString();
}
}
catch (Exception ex)
{
objActivation.recordExists = string.Empty;
Logger.SaveErr(ex);
}
return(objActivation);
}
public FileStreamResult printJobActivation(string prjid)
{
string title = string.Empty;
var model = new JobActivationChecklist();
model.PRJID = Convert.ToInt32(prjid);
model = ChecklistDal.getProjectActivationDetails(model);
model = ChecklistDal.JobActivationLookup(model);
MemoryStream ms = new MemoryStream();
Document document = new Document(PageSize.A4, 15, 10, 15, 35);
PdfWriter writer = PdfWriter.GetInstance(document, ms);
writer.PageEvent = new PDFReportEventHelper(title);
// Open the PDF document
document.Open();
document.Add(PDFUtil.HeaderSection("Job Activation Checklist"));
var projectTable = PDFUtil.createTableWithHeader("Project Information", new float[] { 3, 6 });
projectTable.AddCell(PDFUtil.CreateCell("Atlas Job Number", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.projectInformation.JobNumber, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Atlas Company Name", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.projectInformation.CompanyName, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Customer/Contractor Name", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.projectInformation.CustomerProfile.Name, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Address, City, State, Zip", PDFUtil.font_body_bold, 2, false));
string CustomerAddr = string.Format("{0} | {1} | {2} | {3}",
model.projectInformation.CustomerProfile.Address ?? "-",
model.projectInformation.CustomerProfile.City ?? "-",
model.projectInformation.CustomerProfile.State ?? "-",
model.projectInformation.CustomerProfile.Zip ?? "-");
projectTable.AddCell(PDFUtil.CreateCell(CustomerAddr, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Phone Number, Extension", PDFUtil.font_body_bold, 2, false));
string CustomerPhone = string.Format("{0} | {1}",
AppUtil.formatPhoneNumber(model.projectInformation.CustomerProfile.PhoneNumber) ?? "-",
AppUtil.formatPhoneNumber(model.projectInformation.CustomerProfile.Extension) ?? "-");
projectTable.AddCell(PDFUtil.CreateCell(CustomerPhone, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Project Name", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.projectInformation.ProjectProfile.Name, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Address, City, State, Zip", PDFUtil.font_body_bold, 2, false));
string ProjectAddr = string.Format("{0} | {1} | {2} | {3}",
model.projectInformation.ProjectProfile.Address ?? "-",
model.projectInformation.ProjectProfile.City ?? "-",
model.projectInformation.ProjectProfile.State ?? "-",
model.projectInformation.ProjectProfile.Zip ?? "-");
projectTable.AddCell(PDFUtil.CreateCell(ProjectAddr, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Contact Name/Phone Number, Ext", PDFUtil.font_body_bold, 2, false));
string ProjectPhone = string.Format("{0} | {1} | {2}",
model.projectInformation.CustomerProfile.ContactName ?? "-",
AppUtil.formatPhoneNumber(model.projectInformation.CustomerProfile.PhoneNumber) ?? "-",
AppUtil.formatPhoneNumber(model.projectInformation.CustomerProfile.Extension) ?? "-");
projectTable.AddCell(PDFUtil.CreateCell(ProjectPhone, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Customer Type", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.ListCustomersTypes.
First(i => i.CustomerTypeID.ToString() == model.projectInformation.CustomerType).Description, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Job Type", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.ListJobTypes.
First(i => i.JobTypeId.ToString() == model.projectInformation.Jobtype).JobTypeDesc, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Customer Bid/Job Reference #", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.projectInformation.CustomerBidReference, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Scope of Work to be performed", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.projectInformation.ScopeWorkToBePerformed, PDFUtil.spanNormalBlack, 0, false));
projectTable.AddCell(PDFUtil.CreateCell("Type of Labor", PDFUtil.font_body_bold, 2, false));
projectTable.AddCell(PDFUtil.CreateCell(model.ListLabourTypes.First(i => i.MhRateId.ToString() == model.projectInformation.TypeOfLabour).MhRateName, PDFUtil.spanNormalBlack, 0, false));
document.Add(projectTable);
var ContractTable = PDFUtil.createTableWithHeader("Contract/Job Paperwork", new float[] { 3, 1, 1.5f, 5 });
ContractTable.AddCell(PDFUtil.CreateCell("Copy of Contract or PO", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.CopyOfContractorPO).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.CopyOfContractorPOComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Broken scope into appropriate phases", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.BrokenScopephases).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.BrokenScopephasesComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Bid Roll-up (For each BI being activated)", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.BidRollUp).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.BidRollUpComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Pack CFS for each BI rollup", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.PackCFSPIRollUp).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.PackCFSPIRollUpcomments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Applicable quote(s) for special material", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.ApplicableQuote).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.ApplicableQuoteComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Drawings/field conditions or grading reports", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.DrawingConditions).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.DrawingConditionsComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Site Photos", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.SitePhotos).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.SitePhotosComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Hard Card completely filled out", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.HardCard).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.HardCardComments, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Pay Envelope (residential only)", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.contractPaperWork.PayEnvelope).Response, PDFUtil.spanNormalBlack, 0, false));
ContractTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
ContractTable.AddCell(PDFUtil.CreateCell(model.contractPaperWork.PayEnvelopeComments, PDFUtil.spanNormalBlack, 0, false));
document.Add(ContractTable);
document.NewPage();
var BondingTable = PDFUtil.createTableWithHeader("Bonding/Insurance/Labor ", new float[] { 3, 1, 1.5f, 5 });
BondingTable.AddCell(PDFUtil.CreateCell("Received bond (if required) and necessary insurance certification", PDFUtil.font_body_bold, 2, false));
BondingTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.bondingInsurance.InsuranceCertification).Response, PDFUtil.spanNormalBlack, 0, false));
BondingTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
BondingTable.AddCell(PDFUtil.CreateCell(model.bondingInsurance.InsuranceCertificationComments, PDFUtil.spanNormalBlack, 0, false));
document.Add(BondingTable);
var SafetyTable = PDFUtil.createTableWithHeader("Safety Requirements - For all 'Yes' answers, please provide additional details",
new float[] { 3, 1, 1.5f, 5 });
SafetyTable.AddCell(PDFUtil.CreateCell("Is there a safety officer on site? If so, provide Contact Informatios there a safety officer on site? If so, provide Contact Information", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.SafetyOfficer).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.SafetyOfficerComments, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Any safety meetings/orientation or badging needed before the job starts?", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.SafetyMeeting).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.SafetyMeetingComments, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Any daily safety meetings, truck/tool inspections required?", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.DailySafetyMeeting).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.DailySafetyMeetingComments, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Any specific PPE needed (e.g. fall protection,flotation, fire clothing, etc.)", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.PPENeeded).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.PPENeededComments, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Is fall protection is required? Please provide details of the situation ?", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.FallProtection).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.FallProtectionComments, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Any equipment certifications required (e.g. Bobcats, Forklifts, High lift, etc)?", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.EquipmentCertification).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.EquipmentCertificationComments, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Other hazards (water, lane closure, dust/respirator, HEPA, vacuum, heavy lifting)", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.ListResponses.
First(i => i.ResponseId.ToString() == model.safetyRequirements.OtherHazards).Response, PDFUtil.spanNormalBlack, 0, false));
SafetyTable.AddCell(PDFUtil.CreateCell("Comments", PDFUtil.font_body_bold, 2, false));
SafetyTable.AddCell(PDFUtil.CreateCell(model.safetyRequirements.OtherHazardsComments, PDFUtil.spanNormalBlack, 0, false));
document.Add(SafetyTable);
var OtherImportantTable = PDFUtil.createTableWithHeader("Other Important Factors", new float[] { 3, 7 });
OtherImportantTable.AddCell(PDFUtil.CreateCell("Please fill in any other pertinant information", PDFUtil.font_body_bold, 2, false));
OtherImportantTable.AddCell(PDFUtil.CreateCell(model.otherImportantFactors.OtherPertinentInformation, PDFUtil.spanNormalBlack, 0, false));
document.Add(OtherImportantTable);
var footerTable = PDFUtil.createTableWithHeader("", new float[] { 1, 2, 1, 2 }, true);
footerTable.AddCell(PDFUtil.CreateCell("Estimator Name", PDFUtil.font_body_bold, 2, false));
footerTable.AddCell(PDFUtil.CreateCell(model.projectInformation.Estimator, PDFUtil.spanNormalBlack, 0, false));
footerTable.AddCell(PDFUtil.CreateCell("Date Completed", PDFUtil.font_body_bold, 2, false));
footerTable.AddCell(PDFUtil.CreateCell(model.DateCompleted, PDFUtil.spanNormalBlack, 0, false));
footerTable.AddCell(PDFUtil.CreateCell("Approved By", PDFUtil.font_body_bold, 2, false));
footerTable.AddCell(PDFUtil.CreateCell(model.ListUsers.First(i => i.UserId.ToString() == model.ApprovedBy).Name, PDFUtil.spanNormalBlack, 0, false));
footerTable.AddCell(PDFUtil.CreateCell("Date Reviewed", PDFUtil.font_body_bold, 2, false));
footerTable.AddCell(PDFUtil.CreateCell(model.DateReviewed, PDFUtil.spanNormalBlack, 0, false));
document.Add(footerTable);
document.Close();
byte[] file = ms.ToArray();
MemoryStream output = new MemoryStream();
output.Write(file, 0, file.Length);
output.Position = 0;
HttpContext.Response.AddHeader("content-disposition", "inline; filename=JobActivation_" + prjid + ".pdf");
return(File(output, "application/pdf"));
}
public void LoadActivationLookup(JobActivationChecklist model)
{
model = ChecklistDal.JobActivationLookup(model);
if (model.ListLabourTypes == null)
{
model.ListLabourTypes = new List <SYS10_MhRates>();
}
IEnumerable <SelectListItem> ListLabourTypes = model.ListLabourTypes.Select(c => new SelectListItem
{
Value = Convert.ToString(c.MhRateId),
Text = c.MhRateName
});
ViewBag.ListLabourTypes = ListLabourTypes;
if (model.ListCustomersTypes == null)
{
model.ListCustomersTypes = new List <DOC08_CustomerType>();
}
IEnumerable <SelectListItem> ListCustomersType = model.ListCustomersTypes.Select(c => new SelectListItem
{
Value = Convert.ToString(c.CustomerTypeID),
Text = c.Description
});
ViewBag.ListCustomersType = ListCustomersType;
if (model.ListJobTypes == null)
{
model.ListJobTypes = new List <DOC09_JobTypes>();
}
IEnumerable <SelectListItem> ListJobType = model.ListJobTypes.Select(c => new SelectListItem
{
Value = Convert.ToString(c.JobTypeId),
Text = c.JobTypeDesc
});
ViewBag.ListJobType = ListJobType;
if (model.ListResponses == null)
{
model.ListResponses = new List <DOC10_Responses>();
}
IEnumerable <SelectListItem> ListResponses = model.ListResponses.Select(c => new SelectListItem
{
Value = Convert.ToString(c.ResponseId),
Text = c.Response
});
ViewBag.ListResponses = ListResponses;
IEnumerable <SelectListItem> ListUser = model.ListUsers.Select(c => new SelectListItem
{
Value = Convert.ToString(c.UserId),
Text = c.Name
});
ViewBag.ListUser = ListUser;
}
