public string SaveRakshakRegistrationForm(RakshakRegistration rakshakRegistrationForm)
{
int newFormNumber = 1;
IQueryable <SerialNumbertrackerRA> queryableSerialNumberTrackerRAData = this.unitOfWork.DbContext.SerialNumbertrackerRA
.Where(x => x.UserCode == rakshakRegistrationForm.CreatedBy && x.FormType == "RR");
if (queryableSerialNumberTrackerRAData.Any())
{
newFormNumber = queryableSerialNumberTrackerRAData.Max(y => y.SerialValue) + 1;;
}
string padding = "000";
string serialNumberComponent = padding.Remove(padding.Length - newFormNumber.ToString().Length) + (newFormNumber).ToString();
rakshakRegistrationForm.RakshakRegistrationNumber = "RR-" + rakshakRegistrationForm.CreatedBy + "-" + serialNumberComponent;
/*Form entry*/
RakshakRegistration RakshakRegistrationObj = this.unitOfWork.DbContext.RakshakRegistration.Add(rakshakRegistrationForm);
/*Serial Number updation*/
SerialNumbertrackerRA serialNumbertrackerRAObj = new SerialNumbertrackerRA
{
FormType = "RR",
UserCode = rakshakRegistrationForm.CreatedBy,
SerialValue = newFormNumber,
GeneratedDate = DateTime.UtcNow.AddHours(5.5)
};
serialNumbertrackerRAObj = this.unitOfWork.DbContext.SerialNumbertrackerRA.Add(serialNumbertrackerRAObj);
this.unitOfWork.DbContext.SaveChanges();
return(RakshakRegistrationObj.RakshakRegistrationNumber);
}
public string SaveRakshakRegistrationForm(RakshakRegistration rakshakRegistrationForm)
{
var SaveRakshakRegistrationNumber = this.svpDataAccess.SaveRakshakRegistrationForm(rakshakRegistrationForm);
this.SendRakshakRegistrationFormResponseMail(rakshakRegistrationForm);
return(SaveRakshakRegistrationNumber);
}
public IActionResult SaveRakshakRegistrationForm([FromBody] RakshakRegistration rakshakRegistrationForm)
{
rakshakRegistrationForm.CreatedDateTime = DateTime.UtcNow.AddHours(5.5);
var updatedForm = this._svpBusinessAccess.SaveRakshakRegistrationForm(rakshakRegistrationForm);
return(Ok(updatedForm));
}
public void SendRakshakRegistrationFormResponseMail(RakshakRegistration rakshakRegistrationForm)
{
var generatedPdfTemplateString = pdfTemplate.RakshakRegistrationFormMailGenerator(rakshakRegistrationForm);
var redAlertUser = this.svpDataAccess.GetUserDetails(rakshakRegistrationForm.CreatedBy);
string subject = $"Team ORA - Confirmation: Rakshak Registration Form {rakshakRegistrationForm.RakshakRegistrationNumber} Received ";
string body = $"<img src='https://drive.google.com/uc?id=1Ri4dvgKuyRlK3MYxgqueIDO3OFyBKe5a'/> <br/>Dear {redAlertUser.Organization}, " +
$"<br/><br/><br/>We acknowledge the receipt of your Rakshak Registration Form for the village code {rakshakRegistrationForm.VillageCode}." +
$" Please find the attached PDF for the submitted details.<br/><br/>Let's strive to make our Villages safe !" +
$"<br/><br/>Team ORA";
string pdfName = $"{rakshakRegistrationForm.RakshakRegistrationNumber}.pdf";
rkPdfMailer.SendMailToUser(generatedPdfTemplateString, redAlertUser.UserName, subject, body, pdfName);
}
public string RakshakRegistrationFormMailGenerator(RakshakRegistration rakshakRegistrationForm)
{
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;'>Rakshak Registration Number :</td><td>");
sb.Append(rakshakRegistrationForm.RakshakRegistrationNumber);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Village Code :</td><td>");
sb.Append(rakshakRegistrationForm.VillageCode);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'> Rakshak Name :</td><td>");
sb.Append(rakshakRegistrationForm.Name);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Rakshak Age:</td><td>");
sb.Append(rakshakRegistrationForm.Age);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Rakshak Gender :</td><td>");
sb.Append(rakshakRegistrationForm.Gender);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Education :</td><td>");
sb.Append(rakshakRegistrationForm.EducationalQualification);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Rakshak Contact Number :</td><td>");
sb.Append(rakshakRegistrationForm.PhoneNumber);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Alternate Contact Number :</td><td>");
sb.Append(rakshakRegistrationForm.AlternatePhoneNumber);
sb.Append("</td></tr>");
sb.Append("<tr><td style = 'width:350px; word-wrap: break-word;'>Rakshak E-Mail ID :</td><td>");
sb.Append(rakshakRegistrationForm.EmailId);
sb.Append("</td></tr>");
sb.Append("</table><br/><br/><hr size='5' style='background-color:#E00'/><br/>");
return(sb.ToString());
}
