public static void SendSMS(ApplicantMaster dbApplication, string isSuperVisor, string ApplicationId)
{
try
{
string strurl = "http://premiumsms.markteq.com/api/v4/?method=sms&api_key=A4a416ad5067ff4e0b27e6633404f4a1d&to=" + dbApplication.MobileNumber + " &sender=MSBABD&message=Your application no " + ApplicationId + " for the post of " + (isSuperVisor == "true" ? "SUPERVISOR" : "AsstAO") + " is submitted successfully.";
var http = (HttpWebRequest)WebRequest.Create(strurl);
http.Method = "POST";
var response = http.GetResponse();
}
catch (Exception)
{
using (NPSSOnlineRecruitmentPortal.DBModel.NPSSEntities context = new NPSSEntities())
{
EmailFailureBacklog logFailure = new EmailFailureBacklog();
logFailure.ApplicantID = dbApplication.ApplicantID;
logFailure.FailureReason = "SMS Failure";
context.EmailFailureBacklogs.Add(logFailure);
context.SaveChanges();
}
}
}
public ActionResult ApplicationSuccessful(int applicantID = 0)
{
string str = Convert.ToString(TempData["key"] == null ? string.Empty : TempData["key"]);
ApplicantMaster applicantMaster = new ApplicantMaster();
if (applicantID == 0 || str == "")
{
return(RedirectToAction("Index", "Home"));
}
else if (applicantID > 0)
{
using (context = new DBModel.NPSSEntities())
{
applicantMaster = context.ApplicantMasters.Where(x => x.ApplicantID == applicantID).FirstOrDefault();
if (applicantMaster == null)
{
return(RedirectToAction("Index", "Error"));
}
}
}
return(View(applicantMaster));
}
public static void SendMailToMultipleUser(string toemailid, string attachmentFileName, byte[] bytes, ApplicantMaster dbApplication, string isSuperVisor, string ApplicationId)
{
string UserName = ConfigurationManager.AppSettings["NetworkCredentialUserName"].ToString();
string Password = ConfigurationManager.AppSettings["NetworkCredentialPassword"].ToString();
string FromMail = ConfigurationManager.AppSettings["FromMail"].ToString();
string subject = ConfigurationManager.AppSettings["Subject"].ToString();
string body = ConfigurationManager.AppSettings["Body"].ToString();
string message = body.Replace("@@NewLine", "<br />")
.Replace("@@Name", dbApplication.FirstName + " " + dbApplication.LastName + " " + dbApplication.Surname)
.Replace("@@Position", isSuperVisor == "true" ? "Trained Graduate Supervisor (ટ્રેઈનડ ગ્રેજ્યુએટ સુપરવાઇઝર)" : "Assistant Administrative Officer (મદદનીશ શાસનાધિકારી)")
.Replace("@@ApplicationNo", ApplicationId);
string Host = ConfigurationManager.AppSettings["Host"].ToString();
int Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"].ToString());
attachmentFileName = "MSBABD_" + (isSuperVisor == "true" ? "SUPERVISOR_" : "AsstAO_") + ApplicationId;
MailMessage objEmail = new MailMessage();
try
{
objEmail.From = new MailAddress(FromMail, UserName);
objEmail.To.Add(toemailid);
objEmail.Subject = subject;
objEmail.Body = message;
objEmail.IsBodyHtml = true;
objEmail.Priority = MailPriority.Normal;
Attachment att = new Attachment(new MemoryStream(bytes), attachmentFileName + ".pdf");
objEmail.Attachments.Add(att);
//Get appropriate SmtpSection for mail sending
//SmtpSection smtpSection = GetSmtpSection(isSupportMail);
SmtpClient smtpClient = new SmtpClient(Host, Port);
smtpClient.Credentials = new System.Net.NetworkCredential(FromMail, Password);
smtpClient.EnableSsl = true;
smtpClient.Send(objEmail);
}
catch (Exception ex)
{
using (NPSSOnlineRecruitmentPortal.DBModel.NPSSEntities context = new NPSSEntities())
{
EmailFailureBacklog logFailure = new EmailFailureBacklog();
logFailure.ApplicantID = dbApplication.ApplicantID;
logFailure.FailureReason = ex.Message;
context.EmailFailureBacklogs.Add(logFailure);
context.SaveChanges();
}
}
finally
{
objEmail.Dispose();
}
}
public JsonResult Application(ApplicationViewModel objApplication)
{
int ApplicantID = 0;
bool IsDuplicateFlag = false;
string ApplicationNumber = string.Empty;
try
{
byte[] photo = (byte[])TempData["Photo"];
byte[] signBytes = (byte[])TempData["Signature"];
using (context = new DBModel.NPSSEntities())
{
if (objApplication != null)
{
var isDuplicated = context.ApplicantMasters.Where(x => x.Surname == objApplication.Surname && x.FirstName == objApplication.FirstName && x.LastName == objApplication.LastName &&
x.BirthDate == objApplication.BirthDate && x.MobileNumber == objApplication.MobileNumber && x.EmailId == objApplication.EmailId &&
(objApplication.postSelected == 1 ? x.IsAppliedForSupervisor : true) &&
(objApplication.postSelected == 2 ? x.ISAppliedForAsstAO : true)).FirstOrDefault();
if (isDuplicated == null)
{
#region "Save Basic details"
ApplicantMaster dbApplication = new ApplicantMaster()
{
Surname = objApplication.Surname.Trim(),
FirstName = objApplication.FirstName.Trim(),
LastName = objApplication.LastName.Trim(),
BirthDate = objApplication.BirthDate,
AgeOnApplicationDate = objApplication.AgeOnApplicationDate,
BirthPlaceVillage = objApplication.BirthPlaceVillage,
BirthPlaceCity = objApplication.BirthPlaceCity,
BirthPlaceState = objApplication.BirthPlaceState,
AadharCardNo = objApplication.AadharCardNo,
PhysicalDisability = objApplication.PhysicalDisability,
DisabilityPercentage = objApplication.PhysicalDisability ? objApplication.DisabilityPercentage : 0,
IsMSBEmp = objApplication.IsMSBEmp,
IsAMCEmp = objApplication.IsAMCEmp,
Address1 = objApplication.Address1,
Address2 = objApplication.Address2,
Address3 = objApplication.Address3,
MobileNumber = objApplication.MobileNumber,
EmailId = objApplication.EmailId,
Cast = objApplication.Cast,
SubCast = objApplication.SubCast,
IsAppliedForSupervisor = objApplication.IsAppliedForSupervisor,
SupervisorSeatNumber = objApplication.SupervisorSeatNumber,
ISAppliedForAsstAO = objApplication.ISAppliedForAsstAO,
AsstAOSeatNumber = objApplication.AsstAOSeatNumber,
Category = objApplication.Category,
MaritalStaus = objApplication.MaritalStaus,
Title = objApplication.Title,
Gender = objApplication.Gender,
City = objApplication.City.Trim(),
State = objApplication.State.Trim(),
PinCode = objApplication.PinCode,
District = objApplication.District.Trim(),
Taluka = objApplication.Taluka.Trim(),
Country = "INDIA",
CreatedDateTime = DateTime.Now,
photo = photo,
signature = signBytes,
};
context.ApplicantMasters.Add(dbApplication);
context.SaveChanges();
ApplicantID = dbApplication.ApplicantID;
#endregion
#region "Save Qualification details"
if (dbApplication.ApplicantID > 0 && objApplication.QualificationDetails != null && objApplication.QualificationDetails.Count > 0)
{
foreach (var item in objApplication.QualificationDetails)
{
ApplicantQualificationDetail dbQualification = new ApplicantQualificationDetail()
{
ApplicantID = dbApplication.ApplicantID,
QualificationTypeID = Convert.ToInt32(item.Key.Split('_')[0]),
QualificationHeaderID = Convert.ToInt32(item.Key.Split('_')[1]),
Value = item.Value.ToString()
};
context.ApplicantQualificationDetails.Add(dbQualification);
context.SaveChanges();
}
}
#endregion
#region "Save Experience details"
if (dbApplication.ApplicantID > 0 && objApplication.ExperienceDetails != null && objApplication.ExperienceDetails.Count > 0)
{
foreach (var item in objApplication.ExperienceDetails)
{
var objval = JsonConvert.DeserializeObject <ApplicantExperienceDetail>(Convert.ToString(item.Value));
ApplicantExperienceDetail dbExperience = new ApplicantExperienceDetail()
{
ApplicantID = dbApplication.ApplicantID,
OrganizationName = objval.OrganizationName,
Designation = objval.Designation,
StartDate = objval.StartDate,
EndDate = objval.EndDate,
Sequence = Convert.ToInt32(objval.Sequence)
};
context.ApplicantExperienceDetails.Add(dbExperience);
context.SaveChanges();
}
}
#endregion
context.UpdateApplicationIDByPost(dbApplication.ApplicantID, objApplication.postSelected);
Report("Application Form", dbApplication.ApplicantID, dbApplication.EmailId, objApplication.postSelected, dbApplication);
TempData["key"] = "fromSave";
}
else
{
IsDuplicateFlag = true;
if (objApplication.postSelected == 1)
{
ApplicationNumber = isDuplicated.SupervisotApplicationID;
}
else if (objApplication.postSelected == 2)
{
ApplicationNumber = isDuplicated.AsstAOApplicationID;
}
else if (objApplication.postSelected == 3)
{
ApplicationNumber = isDuplicated.SupervisotApplicationID + "@_@" + isDuplicated.AsstAOApplicationID;
}
}
}
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
if (ApplicantID > 0)
{
using (context = new DBModel.NPSSEntities())
{
context.DeleteApplicantDetails(ApplicantID);
}
}
return(Json(new { IsSuccess = false, ApplicantID = ApplicantID, IsDuplicate = IsDuplicateFlag, ApplicationID = ApplicationNumber }, JsonRequestBehavior.AllowGet));
}
return(Json(new { IsSuccess = true, ApplicantID = ApplicantID, IsDuplicate = IsDuplicateFlag, ApplicationID = ApplicationNumber }, JsonRequestBehavior.AllowGet));
}
private void DownloadPDF(string reportFileName, int applicantID, string isSuperVisor, ApplicantMaster dbApplication)
{
List <ApplicantMaster> lstappmaster = new List <ApplicantMaster>();
expdetail = new List <ApplicantExperienceDetailViewModel>();
qualificationdetail = new List <ApplicationQualificationDetail>();
using (context = new NPSSEntities())
{
lstappmaster = context.Database.SqlQuery <ApplicantMaster>("SP_GetApplicationDetail " + applicantID).ToList <ApplicantMaster>();
expdetail = context.Database.SqlQuery <ApplicantExperienceDetailViewModel>("SP_ExpierienceDetail " + applicantID).ToList <ApplicantExperienceDetailViewModel>();
qualificationdetail = context.Database.SqlQuery <ApplicationQualificationDetail>("SP_QualificationDetail " + applicantID).ToList <ApplicationQualificationDetail>();
}
// Create Report DataSource
ReportDataSource rds = new ReportDataSource("DataSet1", lstappmaster);
// Variables
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
// Setup the report viewer object and get the array of bytes
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = reportFileName;
viewer.LocalReport.SetParameters(new ReportParameter("IsSupervisor", isSuperVisor));
viewer.LocalReport.DataSources.Add(rds); // Add datasource here
viewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
string fileName = "MSBABD_" + (isSuperVisor == "true" ? "SUPERVISOR_" + lstappmaster[0].SupervisotApplicationID : "AsstAO_" + lstappmaster[0].AsstAOApplicationID);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=" + fileName + "." + extension);
Response.BinaryWrite(bytes); // create the file
Response.Flush(); // send it to the client to download
}
private void CreatePDF(string fileName, List <ApplicantMaster> ds, string reportFileName, int applicantID, string toMail, string isSuperVisor, ApplicantMaster dbApplication, string ApplicationId)
{
// Create Report DataSource
ReportDataSource rds = new ReportDataSource("DataSet1", ds);
// Variables
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
// Setup the report viewer object and get the array of bytes
ReportViewer viewer = new ReportViewer();
viewer.ProcessingMode = ProcessingMode.Local;
viewer.LocalReport.ReportPath = reportFileName;
viewer.LocalReport.SetParameters(new ReportParameter("IsSupervisor", isSuperVisor));
viewer.LocalReport.DataSources.Add(rds); // Add datasource here
viewer.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SetSubDataSource);
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
SendMailToMultipleUser(toMail, fileName, bytes, dbApplication, isSuperVisor, ApplicationId);
//Response.Buffer = true;
//Response.Clear();
//Response.ContentType = mimeType;
//Response.AddHeader("content-disposition", "attachment; filename=" + fileName + "." + extension);
//Response.BinaryWrite(bytes); // create the file
//Response.Flush(); // send it to the client to download
}
public void Report(string fileName, int applicantID, string toMail, int postSelection, ApplicantMaster dbApplication)
{
List <ApplicantMaster> lstappmaster = new List <ApplicantMaster>();
expdetail = new List <ApplicantExperienceDetailViewModel>();
qualificationdetail = new List <ApplicationQualificationDetail>();
using (context = new NPSSEntities())
{
lstappmaster = context.Database.SqlQuery <ApplicantMaster>("SP_GetApplicationDetail " + applicantID).ToList <ApplicantMaster>();
if (dbApplication.EmailId != null && dbApplication.EmailId != "")
{
expdetail = context.Database.SqlQuery <ApplicantExperienceDetailViewModel>("SP_ExpierienceDetail " + applicantID).ToList <ApplicantExperienceDetailViewModel>();
qualificationdetail = context.Database.SqlQuery <ApplicationQualificationDetail>("SP_QualificationDetail " + applicantID).ToList <ApplicationQualificationDetail>();
}
}
if (postSelection == 1)
{
if (dbApplication.EmailId != null && dbApplication.EmailId != "")
{
CreatePDF(fileName, lstappmaster, Server.MapPath("~/Report/ApplicantDetail.rdlc"), applicantID, toMail, "true", dbApplication, lstappmaster.FirstOrDefault().SupervisotApplicationID);
}
SendSMS(dbApplication, "true", lstappmaster.FirstOrDefault().SupervisotApplicationID);
}
else if (postSelection == 2)
{
if (dbApplication.EmailId != null && dbApplication.EmailId != "")
{
CreatePDF(fileName, lstappmaster, Server.MapPath("~/Report/ApplicantDetail.rdlc"), applicantID, toMail, "false", dbApplication, lstappmaster.FirstOrDefault().AsstAOApplicationID);
}
SendSMS(dbApplication, "false", lstappmaster.FirstOrDefault().AsstAOApplicationID);
}
else if (postSelection == 3)
{
if (dbApplication.EmailId != null && dbApplication.EmailId != "")
{
CreatePDF(fileName, lstappmaster, Server.MapPath("~/Report/ApplicantDetail.rdlc"), applicantID, toMail, "true", dbApplication, lstappmaster.FirstOrDefault().SupervisotApplicationID);
CreatePDF(fileName, lstappmaster, Server.MapPath("~/Report/ApplicantDetail.rdlc"), applicantID, toMail, "false", dbApplication, lstappmaster.FirstOrDefault().AsstAOApplicationID);
}
SendSMS(dbApplication, "true", lstappmaster.FirstOrDefault().SupervisotApplicationID);
SendSMS(dbApplication, "false", lstappmaster.FirstOrDefault().AsstAOApplicationID);
}
}
