public string PreSvpQCFormMailGenerator(PreSvpQC preSvpQCForm) { StringBuilder sb = new StringBuilder(); sb.Append("<br/><br/> <hr size='5' style='background-color:#E00'/><br/>" + "<table cellpadding='10' style='border-spacing:15px 0rem; font-family:'Times New Roman', Times, serif; font-size:16px;'>" + "<tr><td style='width:350px;word-wrap:break-word;'>Pre-SVP QC Number :</td><td>"); sb.Append(preSvpQCForm.PreSvpQCNumber); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Village Code :</td><td>"); sb.Append(preSvpQCForm.VillageCode); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Stakeholder Description :</td><td>"); sb.Append(preSvpQCForm.StakeholdersDescription); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>IP Facilator Communication skill level :</td><td>"); sb.Append(preSvpQCForm.IpFacilitatorCommunicationSkillLevel); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>CVC Status :</td><td>"); sb.Append(preSvpQCForm.CVCStatus); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Logistic arangements done according to Pre-SVP guidelines :</td><td>"); sb.Append(preSvpQCForm.WasLogisticArrangementsMade); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Are the villagers looking forward for the SVP ? :</td><td>"); sb.Append(preSvpQCForm.AreVillagersInterested); sb.Append("</td></tr>"); sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Summary :</td><td>"); sb.Append(preSvpQCForm.Summary); sb.Append("</td></tr>"); sb.Append("</table><br/><br/><hr size='5' style='background-color:#E00'/><br/>"); return(sb.ToString()); }
public string SavePreSvpQCForm(PreSvpQC preSvpQCForm) { int newFormNumber = 1; IQueryable <SerialNumbertrackerRA> queryableSerialNumberTrackerRAData = this.unitOfWork.DbContext.SerialNumbertrackerRA .Where(x => x.UserCode == preSvpQCForm.CreatedBy && x.FormType == "PQ"); if (queryableSerialNumberTrackerRAData.Any()) { newFormNumber = queryableSerialNumberTrackerRAData.Max(y => y.SerialValue) + 1;; } string padding = "000"; string serialNumberComponent = padding.Remove(padding.Length - newFormNumber.ToString().Length) + (newFormNumber).ToString(); preSvpQCForm.PreSvpQCNumber = "PQ-" + preSvpQCForm.CreatedBy + "-" + serialNumberComponent; /*Form entry*/ PreSvpQC preSvpQCObj = this.unitOfWork.DbContext.PreSvpQC.Add(preSvpQCForm); /*Serial Number updation*/ SerialNumbertrackerRA serialNumbertrackerRAObj = new SerialNumbertrackerRA { FormType = "PQ", UserCode = preSvpQCForm.CreatedBy, SerialValue = newFormNumber, GeneratedDate = DateTime.UtcNow.AddHours(5.5) }; serialNumbertrackerRAObj = this.unitOfWork.DbContext.SerialNumbertrackerRA.Add(serialNumbertrackerRAObj); this.unitOfWork.DbContext.SaveChanges(); return(preSvpQCObj.PreSvpQCNumber); }
public string SavePreSvpQCForm(PreSvpQC preSvpQCForm) { var preSvpQCNumber = this.svpDataAccess.SavePreSvpQCForm(preSvpQCForm); this.SendPreSvpQCFormResponseMail(preSvpQCForm); return(preSvpQCNumber); }
public IActionResult SavePreSvpQCForm([FromBody] PreSvpQC preSvpQCForm) { preSvpQCForm.CreatedDateTime = DateTime.UtcNow.AddHours(5.5); var updatedForm = this._svpBusinessAccess.SavePreSvpQCForm(preSvpQCForm); return(Ok(updatedForm)); }
public void SendPreSvpQCFormResponseMail(PreSvpQC preSvpQCForm) { var generatedPdfTemplateString = pdfTemplate.PreSvpQCFormMailGenerator(preSvpQCForm); var redAlertQCUser = this.svpDataAccess.GetUserDetails(preSvpQCForm.CreatedBy); string subject = $"Team ORA - Confirmation: Pre-SVP QC Form {preSvpQCForm.PreSvpQCNumber} Received "; string body = $"<img src='https://drive.google.com/uc?id=1Ri4dvgKuyRlK3MYxgqueIDO3OFyBKe5a'/> <br/>Dear {redAlertQCUser.PrimaryContact}, " + $"<br/><br/><br/>We acknowledge the receipt of your Pre-SVP QC Visit report for the village code {preSvpQCForm.VillageCode}." + $" Please find the attached PDF for the submitted details.<br/><br/>Let's strive to make our programs better and better and our impact bigger and bigger !" + $"<br/><br/>Team ORA"; string pdfName = $"{preSvpQCForm.PreSvpQCNumber}.pdf"; qcPdfMailer.SendMailToUser(generatedPdfTemplateString, redAlertQCUser.UserName, subject, body, pdfName); }