public DataSet AdmissionPipeline_Select_StatusAndEmail(AdmissionPipeline oAdmissionPipeline)
{
oDataHelper = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("AdmissionId", oAdmissionPipeline.AdmissionId));
return(oDataHelper.DAL_Select("AdmissionPipeline_Select_StatusAndEmail", arrParameter));
}
public bool AdmissionPipeline_UpdateMailStatus(AdmissionPipeline AdmissionPipeline)
{
this.oDataHelper = new DataAccess();
this.arrParameter = new ArrayList();
this.arrParameter.Add(new parameter("AdmissionId", AdmissionPipeline.AdmissionId));
this.arrParameter.Add(new parameter("AdmissionStatus", AdmissionPipeline.AdmissionStatus));
this.arrParameter.Add(new parameter("IsSendMail", AdmissionPipeline.IsSendSuccess));
this.arrParameter.Add(new parameter("FailiurReason", AdmissionPipeline.FailureReasons));
return(this.oDataHelper.DAL_InsertUpdateWithStatus("AdmissionPipeline_UpdateMailStatus", this.arrParameter));
}
protected void btnGetHistory_Click(object sender, EventArgs e)
{
oAdmissionPipeline = new AdmissionPipeline();
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
DataSet ods = oAdmission_BLogic.AdmissionPipeline_Select_StatusAndEmail(oAdmissionPipeline);
GvStatusHistory.Visible = true;
GvStatusHistory.DataSource = ods.Tables[0];
GvStatusHistory.DataBind();
GvMailHistory.Visible = true;
GvMailHistory.DataSource = ods.Tables[1];
GvMailHistory.DataBind();
MdlHistory.Show();
}
/// <summary>
/// Insert new record in AdmissionPipeline table.
/// </summary>
/// <param name="Admission">AdmissionPipeline properties class</param>
/// <returns>Insert ststus(true or false)</returns>
public bool AdmissionPipeline_Insert(AdmissionPipeline AdmissionPipeline)
{
this.oDataHelper = new DataAccess();
this.arrParameter = new ArrayList();
this.arrParameter.Add(new parameter("AdmissionId", AdmissionPipeline.AdmissionId));
this.arrParameter.Add(new parameter("AdmissionStatus", AdmissionPipeline.AdmissionStatus));
this.arrParameter.Add(new parameter("InteractionTime", AdmissionPipeline.InteractionTime));
this.arrParameter.Add(new parameter("FeedBack", AdmissionPipeline.FeedBack));
this.arrParameter.Add(new parameter("Remarks", AdmissionPipeline.Remarks));
this.arrParameter.Add(new parameter("GeneratedDocumentCount", AdmissionPipeline.GeneratedDocumentCount));
this.arrParameter.Add(new parameter("MailFrom", AdmissionPipeline.MailFrom));
this.arrParameter.Add(new parameter("MailTo", AdmissionPipeline.MailTo));
this.arrParameter.Add(new parameter("MailSubject", AdmissionPipeline.MailSubject));
this.arrParameter.Add(new parameter("MailBody", AdmissionPipeline.MailBody));
this.arrParameter.Add(new parameter("MailDocument", AdmissionPipeline.MailDocument));
this.arrParameter.Add(new parameter("IsSendSuccess", AdmissionPipeline.IsSendSuccess));
this.arrParameter.Add(new parameter("FailureReasons", AdmissionPipeline.FailureReasons));
this.arrParameter.Add(new parameter("CreatedBy", AdmissionPipeline.CreatedBy));
return(this.oDataHelper.DAL_InsertUpdateWithStatus("AdmissionPipeline_Insert", this.arrParameter));
}
public static string LoadMail(string AdmissionEmailID)
{
AdmissionPipeline oAdmissionPipeline = new AdmissionPipeline();
Admission_BLogic oAdmission_BLogic = new Admission_BLogic();
DataSet ods = oAdmission_BLogic.AdmissionPipeline_Select_StatusAndEmail_By_AdmissionEmailID(AdmissionEmailID);
StringBuilder oBuilder = new StringBuilder();
if (ods.Tables[0].Rows.Count > 0)
{
foreach (DataRow odr in ods.Tables[0].Rows)
{
oBuilder.Append("<div class='dvsmallheader' style='width:50px;text-align:right;'><span>From</span></div><div class='dvsmallheader' style='width:86%; margin-top:0px;'>" + Convert.ToString(odr["MailFrom"]) + "</div><br />");
oBuilder.Append("<div class='dvsmallheader' style='width:50px;text-align:right;'><span>To</span></div><div class='dvsmallheader' style='width:86%; margin-top:0px;'>" + Convert.ToString(odr["MailTo"]) + "</div><br />");
oBuilder.Append("<div class='dvsmallheader' style='width:50px;text-align:right;'><span>Subject</span></div><div class='dvsmallheader' style='width:86%; margin-top:0px;'>" + Convert.ToString(odr["MailSubject"]) + "</div><br />");
oBuilder.Append("<div class='dvsmallheader' style='margin-top:20px;'><span>Body</span></div><div class='dvsmallheader' style='display:block; width:97%; margin-top:0px;'>" + Convert.ToString(odr["Mailbody"]) + "</div><br />");
oBuilder.Append("<div class='dvsmallheader'><span>Attachment</span></div><div class='dvsmallheader' style='display:block; width:97%; margin-top:0px;'>" + GetAttachmentHTML(odr) + "</div><br />");
}
}
return(Convert.ToString(oBuilder));
}
/// <summary>
/// Interaction slip send button click event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSend_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hdnAdmissionID.Value))
{
foreach (GridViewRow row in gvtemplate.Rows)
{
RadioButton Rb = (RadioButton)row.FindControl("Rbtemplate");
if (Rb.Checked)
{
Label LblTemplateName = (Label)row.FindControl("GV_LblTemplateName");
TemplateName = LblTemplateName.Text;
}
}
foreach (GridViewRow row in GvDocument.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("chkdocument");
if (chk.Checked)
{
Label LblDocumentName = (Label)row.FindControl("GV_LblDocumentName");
DocumentList.Add(LblDocumentName.Text);
}
}
string InteractionDateTime = string.Empty;
string FeedBack = string.Empty;
string Remarks = string.Empty;
string MailFrom = EmailUtility.SMTPEmailAddress;
string MailTo = hdnEmailID.Value;
string MailSubject = string.Empty;
string MailBody = string.Empty;
string FailiurReason = string.Empty;
ArrayList ArrMailTo = new ArrayList();
switch (hdnAdmissionStatus.Value)
{
case "Interaction":
InteractionDate = TxtDate.Text.Trim();
InteractionTime = TxtTime.Text.Trim();
InteractionDateTime = TxtDate.Text.Trim() + " " + TxtTime.Text.Trim();
DocumentFileList = GenerateDocument(DocumentList, hdnAdmissionID.Value);
GetMailSubjectAndBody(TemplateName, out MailSubject, out MailBody);
#region Insert in AdmissionPipeline
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline = new AdmissionPipeline();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
oAdmissionPipeline.AdmissionStatus = hdnAdmissionStatus.Value;
oAdmissionPipeline.InteractionTime = InteractionDateTime;
oAdmissionPipeline.FeedBack = null;
oAdmissionPipeline.Remarks = null;
oAdmissionPipeline.GeneratedDocumentCount = Convert.ToString(AutoGeneratedDocumentList.Count);
oAdmissionPipeline.MailFrom = MailFrom;
oAdmissionPipeline.MailTo = MailTo;
oAdmissionPipeline.MailSubject = MailSubject;
oAdmissionPipeline.MailBody = MailBody;
oAdmissionPipeline.MailDocument = (!string.IsNullOrEmpty(GetMailDocumentString(AutoGeneratedDocumentList))) ? GetMailDocumentString(AutoGeneratedDocumentList) : null;
oAdmissionPipeline.IsSendSuccess = false;
oAdmissionPipeline.FailureReasons = null;
oAdmissionPipeline.CreatedBy = Convert.ToString(AppSessions.EmpolyeeID);
bool IsInsert = oAdmission_BLogic.AdmissionPipeline_Insert(oAdmissionPipeline);
#endregion
if (IsInsert)
{
ArrMailTo.Add(MailTo);
bool IsSendSuccess = EmailUtility.SendEmail(ArrMailTo, MailSubject, MailBody, out FailiurReason, DocumentFileList);
#region Update Mail Status
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline = new AdmissionPipeline();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
oAdmissionPipeline.AdmissionStatus = hdnAdmissionStatus.Value;
oAdmissionPipeline.IsSendSuccess = IsSendSuccess;
oAdmissionPipeline.FailureReasons = (!string.IsNullOrEmpty(FailiurReason)) ? FailiurReason : null;
oAdmission_BLogic.AdmissionPipeline_UpdateMailStatus(oAdmissionPipeline);
#endregion
if (IsSendSuccess)
{
WebMsg.Show("Interaction slip sent successfully.");
}
else
{
WebMsg.Show("Interaction slip sent failed.");
}
}
else
{
WebMsg.Show("Send Admission in pipeline failed.");
}
break;
case "confirm":
FeedBack = TxtFeedBack.InnerText;
Remarks = TxtRemarks.InnerText;
DocumentFileList = GenerateDocument(DocumentList, hdnAdmissionID.Value);
GetMailSubjectAndBody(TemplateName, out MailSubject, out MailBody);
#region Insert in AdmissionPipeline
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline = new AdmissionPipeline();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
oAdmissionPipeline.AdmissionStatus = hdnAdmissionStatus.Value;
oAdmissionPipeline.InteractionTime = null;
oAdmissionPipeline.FeedBack = FeedBack;
oAdmissionPipeline.Remarks = Remarks;
oAdmissionPipeline.GeneratedDocumentCount = Convert.ToString(AutoGeneratedDocumentList.Count);
oAdmissionPipeline.MailFrom = MailFrom;
oAdmissionPipeline.MailTo = MailTo;
oAdmissionPipeline.MailSubject = MailSubject;
oAdmissionPipeline.MailBody = MailBody;
oAdmissionPipeline.MailDocument = (!string.IsNullOrEmpty(GetMailDocumentString(AutoGeneratedDocumentList))) ? GetMailDocumentString(AutoGeneratedDocumentList) : null;
oAdmissionPipeline.IsSendSuccess = false;
oAdmissionPipeline.FailureReasons = null;
oAdmissionPipeline.CreatedBy = Convert.ToString(AppSessions.EmpolyeeID);
IsInsert = oAdmission_BLogic.AdmissionPipeline_Insert(oAdmissionPipeline);
#endregion
if (IsInsert)
{
ArrMailTo.Add(MailTo);
bool IsSendSuccess = EmailUtility.SendEmail(ArrMailTo, MailSubject, MailBody, out FailiurReason, DocumentFileList);
#region Update Mail Status
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline = new AdmissionPipeline();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
oAdmissionPipeline.AdmissionStatus = hdnAdmissionStatus.Value;
oAdmissionPipeline.IsSendSuccess = IsSendSuccess;
oAdmissionPipeline.FailureReasons = (!string.IsNullOrEmpty(FailiurReason)) ? FailiurReason : null;;
oAdmission_BLogic.AdmissionPipeline_UpdateMailStatus(oAdmissionPipeline);
#endregion
if (IsSendSuccess)
{
WebMsg.Show("Admission is confirmed.");
}
else if (IsSendSuccess)
{
WebMsg.Show("Admission confirm failed.");
}
}
else
{
WebMsg.Show("Send Admission in pipeline failed.");
}
break;
case "onhold":
FeedBack = TxtFeedBack.InnerText;
Remarks = TxtRemarks.InnerText;
#region Insert in AdmissionPipeline
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline = new AdmissionPipeline();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
oAdmissionPipeline.AdmissionStatus = hdnAdmissionStatus.Value;
oAdmissionPipeline.InteractionTime = null;
oAdmissionPipeline.FeedBack = FeedBack;
oAdmissionPipeline.Remarks = Remarks;
oAdmissionPipeline.GeneratedDocumentCount = Convert.ToString(AutoGeneratedDocumentList.Count);
oAdmissionPipeline.MailFrom = null;
oAdmissionPipeline.MailTo = null;
oAdmissionPipeline.MailSubject = null;
oAdmissionPipeline.MailBody = null;
oAdmissionPipeline.MailDocument = (!string.IsNullOrEmpty(GetMailDocumentString(AutoGeneratedDocumentList))) ? GetMailDocumentString(AutoGeneratedDocumentList) : null;
oAdmissionPipeline.IsSendSuccess = false;
oAdmissionPipeline.FailureReasons = null;
oAdmissionPipeline.CreatedBy = Convert.ToString(AppSessions.EmpolyeeID);
IsInsert = oAdmission_BLogic.AdmissionPipeline_Insert(oAdmissionPipeline);
#endregion
if (IsInsert)
{
WebMsg.Show("Admission is on hold.");
}
else
{
WebMsg.Show("Admission onhold failed.");
}
break;
case "reject":
FeedBack = TxtFeedBack.InnerText;
Remarks = TxtRemarks.InnerText;
#region Insert in AdmissionPipeline
oAdmission_BLogic = new Admission_BLogic();
oAdmissionPipeline = new AdmissionPipeline();
oAdmissionPipeline.AdmissionId = hdnAdmissionID.Value;
oAdmissionPipeline.AdmissionStatus = hdnAdmissionStatus.Value;
oAdmissionPipeline.InteractionTime = null;
oAdmissionPipeline.FeedBack = FeedBack;
oAdmissionPipeline.Remarks = Remarks;
oAdmissionPipeline.GeneratedDocumentCount = Convert.ToString(AutoGeneratedDocumentList.Count);
oAdmissionPipeline.MailFrom = null;
oAdmissionPipeline.MailTo = null;
oAdmissionPipeline.MailSubject = null;
oAdmissionPipeline.MailBody = null;
oAdmissionPipeline.MailDocument = (!string.IsNullOrEmpty(GetMailDocumentString(AutoGeneratedDocumentList))) ? GetMailDocumentString(AutoGeneratedDocumentList) : null;
oAdmissionPipeline.IsSendSuccess = false;
oAdmissionPipeline.FailureReasons = null;
oAdmissionPipeline.CreatedBy = Convert.ToString(AppSessions.EmpolyeeID);
IsInsert = oAdmission_BLogic.AdmissionPipeline_Insert(oAdmissionPipeline);
#endregion
if (IsInsert)
{
WebMsg.Show("Admission is rejected.");
}
else
{
WebMsg.Show("Admission reject failed.");
}
break;
default:
break;
}
BindAdmissionGrid("");
}
else
{
WebMsg.Show("Please reload page and try again.");
}
}
