/// <summary> /// UpdateApprovalDetails method is useful to update the account approval details into database. /// </summary> /// <param name="updatePolicyDetails"></param> public int UpdateApprovalDetails(PolicyDetailsBusinessEntity updateApprovalStatus) { int status = CommonConstants.StatusZero; try { conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand(sqlQry.UpdatePolicyApprovalQuery(updateApprovalStatus), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); status = CommonConstants.StatusOne; } catch (System.InvalidCastException e) { throw e; } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(status); }
/// <summary> /// Fatching row details into Textboxes on Edit button click. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals(CommonConstants.EditRow)) { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = grdView1.Rows[index]; Session[CommonConstants.SelectedRowIndex] = row.RowIndex; txtPolicyNo.Text = row.Cells[0].Text; txtPolicyNo.Enabled = CommonConstants.False; txtUserName.Text = row.Cells[2].Text; txtRequestDate.Text = row.Cells[3].Text; txtMailId.Text = row.Cells[4].Text; TextBox tbox = (TextBox)row.FindControl("GrdTxtBusinessReason"); txtBusinessReason.Text = tbox.Text.ToString(); txtRootSegCount.Text = row.Cells[6].Text; txtMachineSegCount.Text = row.Cells[7].Text; txtFaceSegCount.Text = row.Cells[8].Text; } if (e.CommandName.Equals(CommonConstants.DeleteRow)) { int status; int index = Convert.ToInt32(e.CommandArgument); PolicyDetailsBusinessEntity policyDetails = new PolicyDetailsBusinessEntity(); MilePostBuzLogic milePostBuzObj = new MilePostBuzLogic(); UserInfoDetailsBusinessEntity userInfo = (UserInfoDetailsBusinessEntity)Session[CommonConstants.UserInfo]; try { GridViewRow row = grdView1.Rows[index]; policyDetails.PolicyNo = row.Cells[0].Text; policyDetails.UserId = userInfo.UserId; status = milePostBuzObj.DeletePolicyDetails(policyDetails); if (status == CommonConstants.StatusOne) { ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.SuccessDeleted, true); LoadGrid(); } } catch (Exception ex) { HandleLogging.AddtoLogFile(ex.Message, CommonConstants.PolicyEntry); Response.Redirect(CommonConstants.Error); } finally { if (!txtPolicyNo.Enabled) { txtPolicyNo.Enabled = CommonConstants.True; } txtPolicyNo.Text = string.Empty; txtRequestDate.Text = string.Empty; txtRootSegCount.Text = string.Empty; txtBusinessReason.Text = string.Empty; txtMachineSegCount.Text = string.Empty; txtFaceSegCount.Text = string.Empty; } } }
/// <summary> /// GetPolicyEnquiry method is useful to retrieve the all policy details from database. /// </summary> /// <param name="getPolicyEnquiry"></param> /// <returns>DataSet</returns> public DataSet GetPolicyEnquiry(PolicyDetailsBusinessEntity getPolicyEnquiry) { DataSet ds = new DataSet(); try { conn = new SqlConnection(connStr); conn.Open(); if (getPolicyEnquiry.PolicyNo != string.Empty && (getPolicyEnquiry.StartDate != string.Empty && getPolicyEnquiry.EndDate != string.Empty)) { SqlCommand cmd = new SqlCommand(sqlQry.GetPolicyEnquiryQuery(getPolicyEnquiry), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); } else if (getPolicyEnquiry.StartDate != string.Empty && getPolicyEnquiry.EndDate != string.Empty) { SqlCommand cmd = new SqlCommand(sqlQry.GetPolicyEnquiryDateQuery(getPolicyEnquiry), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); } else { SqlCommand cmd = new SqlCommand(sqlQry.PolicyEnquiryPolicyNoQuery(getPolicyEnquiry), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); } for (Int32 i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { if (ds.Tables[0].Rows[i][6].ToString() != "") { //if (Convert.ToInt32(ds.Tables[0].Rows[i][6]) == 0) //{ // ds.Tables[0].Rows[i][6] = System.DBNull.Value; //} } } } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(ds); }
/// <summary> /// Invokes SendApproveRejectMail method of the MilePostProvider class to send trigger mail on policy approval and policy reject to Business Team /// </summary> /// <param name="?"></param> /// <returns></returns> public bool SendApproveRejectMail(PolicyDetailsBusinessEntity policyDetails, UserInfoDetailsBusinessEntity userInfoDetails, string mailType) { bool status = false; try { MilePostProvider provider = new MilePostProvider(); status = provider.SendApproveRejectMail(policyDetails, userInfoDetails, mailType); } catch (DataException ex) { throw ex; } return(status); }
/// <summary> /// UpdateApprovalDetails method is useful to update all the policy which is in approve and /// </summary> /// <param name="updatePolicyDetails"></param> public int UpdateApprovalDetails(PolicyDetailsBusinessEntity updatePolicyDetails) { int status = CommonConstants.StatusZero; try { MilePostProvider provider = new MilePostProvider(); status = provider.UpdateApprovalDetails(updatePolicyDetails); } catch (DataException ex) { throw ex; } return(status); }
/// <summary> /// Invokes SendEmail method of the MilePostProvider class to send mail to Account Team /// </summary> /// <param name="?"></param> /// <returns></returns> public bool SendEmail(PolicyDetailsBusinessEntity policyDetails) { bool status = false; try { MilePostProvider provider = new MilePostProvider(); status = provider.SendEmail(policyDetails); } catch (DataException ex) { throw ex; } return(status); }
public string PolicyEnquiryPolicyNoQuery(PolicyDetailsBusinessEntity getPolicyEnquiry) { try { queryString = "SELECT TPD.*, TUI.USER_NAME, TUI.EMAIL_ID, (SELECT USER_NAME FROM " + CommonConstants.tblUserInfo + " WHERE USER_ID = TPD.APPROVER_ID_ACCTNG) AS APPROVER_NAME FROM " + CommonConstants.tblPolicyDetails + " TPD INNER JOIN " + CommonConstants.tblUserInfo + " TUI ON TPD.USER_ID = TUI.USER_ID WHERE TPD.POLICY_NUMBER = " + CommonConstants.invertedComma + getPolicyEnquiry.PolicyNo + CommonConstants.invertedComma + "ORDER BY TPD.POLICY_NUMBER"; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
public string UpdatePolicyApprovalQuery(PolicyDetailsBusinessEntity updateApprovalStatus) { try { queryString = "UPDATE " + CommonConstants.tblPolicyDetails + " SET APPROVER_ID_ACCTNG = " + updateApprovalStatus.UserId + "," + " APPROVAL_IND_ACCTNG = 'Y' WHERE POLICY_NUMBER = " + CommonConstants.invertedComma + updateApprovalStatus.PolicyNo + CommonConstants.invertedComma; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
/// <summary> /// GetPolicyEnquiry method is useful to retrieve override audit log details from the database. /// </summary> /// <param name="getPolicyEnquiry"></param> /// <returns>DataSet</returns> public DataSet GetPolicyEnquiry(PolicyDetailsBusinessEntity getPolicyEnquiry) { DataSet ds = new DataSet(); try { MilePostProvider provider = new MilePostProvider(); ds = provider.GetPolicyEnquiry(getPolicyEnquiry); } catch (DataException ex) { throw ex; } return(ds); }
public string UpdatePolicyRejectQuery(PolicyDetailsBusinessEntity policyDetails, UserInfoDetailsBusinessEntity userInfoDetails) { try { queryString = "UPDATE " + CommonConstants.tblPolicyDetails + " SET APPROVER_ID_ACCTNG = " + userInfoDetails.UserId + " WHERE POLICY_NUMBER = " + CommonConstants.invertedComma + policyDetails.PolicyNo + CommonConstants.invertedComma; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
public string InsertPolicyDetailsQuery(PolicyDetailsBusinessEntity addPolicyDetails) { try { queryString = "INSERT INTO " + CommonConstants.tblPolicyDetails + "(USER_ID,POLICY_NUMBER,REQUEST_DATE, BUSINESS_REASON,APPROVAL_IND_ACCTNG,LOADED_IN_PROD_IND,ROOT_SEG_CNT,MACHINE_SEG_CNT,FACE_SEG_CNT ) VALUES (" + addPolicyDetails.UserId + "," + CommonConstants.invertedComma + addPolicyDetails.PolicyNo + CommonConstants.invertedComma + "," + CommonConstants.invertedComma + addPolicyDetails.RequestDate + CommonConstants.invertedComma + "," + CommonConstants.invertedComma + addPolicyDetails.BusinessReason + CommonConstants.invertedComma + "," + "'N'" + "," + "'N'" + "," + addPolicyDetails.RootSegmentCount + "," + addPolicyDetails.MachineSegmentCount + "," + addPolicyDetails.FaceSegmentCount + ")"; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
public string DeletePolicyDetailsQuery(PolicyDetailsBusinessEntity deletePolicyDetails) { try { queryString = "DELETE FROM " + CommonConstants.tblPolicyDetails + " WHERE USER_ID = " + deletePolicyDetails.UserId + " AND POLICY_NUMBER = " + CommonConstants.invertedComma + deletePolicyDetails.PolicyNo + CommonConstants.invertedComma; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
public string UpdatePolicyDetailsQuery(PolicyDetailsBusinessEntity updatePolicyDetails) { try { queryString = "UPDATE " + CommonConstants.tblPolicyDetails + " SET REQUEST_DATE = " + CommonConstants.invertedComma + updatePolicyDetails.RequestDate + CommonConstants.invertedComma + "," + "BUSINESS_REASON = " + CommonConstants.invertedComma + updatePolicyDetails.BusinessReason + CommonConstants.invertedComma + "," + "ROOT_SEG_CNT = " + updatePolicyDetails.RootSegmentCount + "," + " MACHINE_SEG_CNT =" + updatePolicyDetails.MachineSegmentCount + "," + "FACE_SEG_CNT = " + updatePolicyDetails.FaceSegmentCount + " WHERE USER_ID = " + updatePolicyDetails.UserId + " AND " + " POLICY_NUMBER = " + CommonConstants.invertedComma + updatePolicyDetails.PolicyNo + CommonConstants.invertedComma; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
public string GetPolicyEnquiryQuery(PolicyDetailsBusinessEntity getPolicyEnquiry) { try { //queryString = " SELECT TPD.*, TUI.USER_NAME, TUI.EMAIL_ID, (SELECT USER_NAME FROM " + CommonConstants.tblUserInfo + " WHERE USER_ID = TPD.APPROVER_ID_ACCTNG) AS APPROVER_NAME FROM " + CommonConstants.tblPolicyDetails + " TPD INNER JOIN " + CommonConstants.tblUserInfo + " TUI ON TPD.USER_ID = TUI.USER_ID WHERE TPD.POLICY_NUMBER = " + CommonConstants.invertedComma + getPolicyEnquiry.PolicyNo + CommonConstants.invertedComma + " AND ((TO_DATE(REQUEST_DATE,'MM/DD/YYYY') >= TO_DATE(" + CommonConstants.invertedComma + getPolicyEnquiry.StartDate + CommonConstants.invertedComma + ",'MM/DD/YYYY')) AND (TO_DATE(REQUEST_DATE,'MM/DD/YYYY') <= TO_DATE(" + CommonConstants.invertedComma + getPolicyEnquiry.EndDate + CommonConstants.invertedComma + ",'MM/DD/YYYY'))) ORDER BY TPD.POLICY_NUMBER"; //queryString = " SELECT TPD.*, TUI.USER_NAME, TUI.EMAIL_ID, (SELECT USER_NAME FROM " + CommonConstants.tblUserInfo + " WHERE USER_ID = TPD.APPROVER_ID_ACCTNG) AS APPROVER_NAME FROM " + CommonConstants.tblPolicyDetails + " TPD INNER JOIN " + CommonConstants.tblUserInfo + " TUI ON TPD.USER_ID = TUI.USER_ID WHERE TPD.POLICY_NUMBER = " + CommonConstants.invertedComma + getPolicyEnquiry.PolicyNo + CommonConstants.invertedComma + " AND (REQUEST_DATE >= TO_DATE(" + CommonConstants.invertedComma + getPolicyEnquiry.StartDate + CommonConstants.invertedComma + ",'MM/DD/YYYY') AND (REQUEST_DATE <=TO_DATE(" + CommonConstants.invertedComma + getPolicyEnquiry.EndDate + CommonConstants.invertedComma + ",'MM/DD/YYYY'))) ORDER BY TPD.POLICY_NUMBER"; queryString = " SELECT TPD.*, TUI.USER_NAME, TUI.EMAIL_ID, (SELECT USER_NAME FROM " + CommonConstants.tblUserInfo + " WHERE USER_ID = TPD.APPROVER_ID_ACCTNG) AS APPROVER_NAME FROM " + CommonConstants.tblPolicyDetails + " TPD INNER JOIN " + CommonConstants.tblUserInfo + " TUI ON TPD.USER_ID = TUI.USER_ID WHERE TPD.POLICY_NUMBER = " + CommonConstants.invertedComma + getPolicyEnquiry.PolicyNo + CommonConstants.invertedComma + " AND REQUEST_DATE >=" + CommonConstants.invertedComma + getPolicyEnquiry.StartDate + CommonConstants.invertedComma + " AND REQUEST_DATE <=" + CommonConstants.invertedComma + getPolicyEnquiry.EndDate + CommonConstants.invertedComma + " ORDER BY TPD.POLICY_NUMBER"; return(queryString); } catch (Exception ex) { throw ex; } finally { queryString = string.Empty; } }
/// <summary> /// This method is usefult to Load the grid. /// </summary> protected void LoadGrid() { DataSet ds = null; PolicyDetailsBusinessEntity policyDetails = new PolicyDetailsBusinessEntity(); UserInfoDetailsBusinessEntity userInfo = (UserInfoDetailsBusinessEntity)Session[CommonConstants.UserInfo]; MilePostBuzLogic milePostBuzObj = new MilePostBuzLogic(); try { policyDetails.UserId = userInfo.UserId; policyDetails.PolicyNo = txtPolicyNo.Text.ToUpper(); policyDetails.StartDate = txtRequestDate.Text; policyDetails.EndDate = txtEndDate.Text; ds = milePostBuzObj.GetPolicyEnquiry(policyDetails); if (ds.Tables[0].Rows.Count > CommonConstants.StatusZero) { GrdView2.Visible = CommonConstants.True; GrdView2.DataSource = ds; GrdView2.DataBind(); } else { if (GrdView2.Visible) { GrdView2.Visible = CommonConstants.False; } lblNoRecords.Visible = CommonConstants.True; } } catch (Exception ex) { HandleLogging.AddtoLogFile(ex.ToString(), CommonConstants.PolicyEnquiry); Response.Redirect(CommonConstants.Error); } finally { ds.Dispose(); } }
/// <summary> /// DeletePolicyDetails method is useful to delete the specific Policy Number from the database. /// </summary> /// <param name="policyId"></param> /// <returns>int</returns> public int DeletePolicyDetails(PolicyDetailsBusinessEntity deletePolicyDetails) { int status = CommonConstants.StatusZero; try { conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand(sqlQry.DeletePolicyDetailsQuery(deletePolicyDetails), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); status = CommonConstants.StatusOne; } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(status); }
/// <summary> /// AddPolicyDetails method is useful to add the override request details into T_Policy_Details table. /// </summary> /// <param name="addPolicyDetails"></param> /// <returns></returns> public int AddPolicyDetails(PolicyDetailsBusinessEntity addPolicyDetails) { int status = CommonConstants.StatusZero; try { conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand(sqlQry.InsertPolicyDetailsQuery(addPolicyDetails), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); //SqlCommand cmd = new SqlCommand(CommonConstants.SProcInsertPolicyDetails, conn); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("UserId", addPolicyDetails.UserId); //cmd.Parameters.AddWithValue("PolicyNo", addPolicyDetails.PolicyNo); //cmd.Parameters.AddWithValue("RequestDate", addPolicyDetails.RequestDate); //cmd.Parameters.AddWithValue("BusinessReason", addPolicyDetails.BusinessReason); //cmd.Parameters.AddWithValue("RootSegmentCount", addPolicyDetails.RootSegmentCount); //cmd.Parameters.AddWithValue("FaceSegmentCount", addPolicyDetails.FaceSegmentCount); //cmd.Parameters.AddWithValue("MachineSegmentCount", addPolicyDetails.MachineSegmentCount); //cmd.CommandType = CommandType.StoredProcedure; //cmd.ExecuteNonQuery(); status = CommonConstants.StatusOne; } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(status); }
/// <summary> /// Invokes SendEmail method of the MilePostProvider class to send mail to Account Team /// </summary> /// <param name="?"></param> /// <returns></returns> public bool SendEmail(PolicyDetailsBusinessEntity policyDetails) { bool status = true; char[] sepArray = new char[] { ',', ';' }; StringBuilder emailBody = null; StringBuilder toEmailAddress = null; string ccEmailAddress = string.Empty; string bccEmailAddress = string.Empty; string errorMessage = string.Empty; string username = policyDetails.UserName; string policyNo = policyDetails.PolicyNo; string phoneNo = policyDetails.PhoneNumber; string date = DateTime.Today.ToString(CommonConstants.DateFormat); int pmrRecordCnt = policyDetails.RootSegmentCount; int machineRecordCnt = policyDetails.MachineSegmentCount; int faceRecordCnt = policyDetails.FaceSegmentCount; string targetDate = policyDetails.OverwriteDate; string requestDate = policyDetails.RequestDate; MailMessage mailMessage = null; DataSet ds = null; List <String> lstEmailAddress = new List <String>(); string emailAddress = string.Empty; try { ds = new DataSet(); conn = new SqlConnection(connStr); toEmailAddress = new StringBuilder(); emailBody = new StringBuilder(); //Mail Message mailMessage = new MailMessage(); conn.Open(); SqlCommand cmd = new SqlCommand(sqlQry.GetApproversEmailIdQuery(), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(ds); if (ds.Tables[0].Rows.Count > CommonConstants.StatusZero) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { emailAddress = ds.Tables[0].Rows[i][0].ToString(); lstEmailAddress.Add(emailAddress); } } if (lstEmailAddress.Count > 0) { for (int i = 0; i < lstEmailAddress.Count; i++) { toEmailAddress.Append(lstEmailAddress[i].ToString()); toEmailAddress.Append(";"); } } toEmailAddress.Remove(toEmailAddress.Length - 1, 1); string toEmailAddress1 = toEmailAddress.ToString(); mailMessage.From = new MailAddress(fromEmailAddress); if (!string.IsNullOrEmpty(toEmailAddress1)) { string[] toArray = toEmailAddress1.Split(sepArray); foreach (string tomailAddr in toArray) { mailMessage.To.Add(new MailAddress(tomailAddr)); } toArray = null; } //ccEmailAddress = policyDetails.MailId; //mailMessage.CC.Add(new MailAddress(ccEmailAddress)); if (!string.IsNullOrEmpty(bccEmailAddress)) { string[] bccArray = bccEmailAddress.Split(sepArray); foreach (string bccmailAddr in bccArray) { mailMessage.Bcc.Add(new MailAddress(bccmailAddr)); } bccArray = null; } //--------------------------------- //mailMessage.To.Add(new MailAddress("*****@*****.**")); //---------------------------------------- mailMessage.Subject = CommonConstants.MailSubjectPolicyEntry1 + policyNo + CommonConstants.MailSubjectPolicyEntry2 + requestDate; emailBody.AppendLine("<div id=\"pnlLoggedIn\" style=\"width:480px;\">"); emailBody.Append(@"<html><body><div><img src=cid:myImageID> </div>"); emailBody.AppendLine("<br>"); emailBody.Append("<div>IS Memorandum</div>"); emailBody.AppendLine("<br>"); emailBody.AppendLine("<div style=\"text-align:right;\"><b>Date: </b>" + date + "</div>"); emailBody.AppendLine("<div style=\"text-align:right;\"><b>Phone No:</b> " + phoneNo + "</div>"); emailBody.AppendLine("<hr />"); emailBody.AppendLine("<div>The following policy has been included for Special Overwrite:</div>"); emailBody.Append("<br />"); emailBody.Append("<div style=\"text-align:center;text-decoration:underline;font-weight:bold;\">"); emailBody.Append(username); emailBody.Append("</div><div style=\"text-align:center;\">"); emailBody.Append(policyNo + " 0 – Tests in IMSK </div> "); emailBody.AppendLine("<br />"); emailBody.Append("<div style = \"text-decoration:underline;font-weight:bold;\">Reason for the overwrite</div>"); emailBody.AppendLine("<div style=\"text-decoration:underline;font-weight:bold;\">"); emailBody.AppendLine(policyNo); emailBody.Append("</div>"); emailBody.AppendLine("<div>" + policyDetails.BusinessReason + "</div>"); emailBody.AppendLine("<br />"); emailBody.AppendLine("<div>The first overwrite job will delete " + pmrRecordCnt + " PMRs.</div>"); emailBody.Append("<div> The second overwrite job will insert "); emailBody.Append(pmrRecordCnt + " PMRs; insert " + machineRecordCnt + " machine segments and " + faceRecordCnt + " Face segments.</div>"); emailBody.AppendLine("<br />"); //emailBody.AppendLine("<div style = \"float:left;\">Please submit the following jobs from "); //emailBody.Append("<b> SYSCMN.PROD.PRODJOBS </b>"); //emailBody.Append("unless noted:</div>"); //emailBody.AppendLine("<ul><li><pre style=\"font-family:Verdana;font-size:10px;\"><b>E0385WGP stop the WIFY job</b></pre> </li>"); //emailBody.AppendLine("<li><pre style=\"font-family:Verdana;font-size:10px;\"><b>E0384O1 Special Overwrite job (in E0384T.GRPLIB.JCL)</b></pre></li>"); //emailBody.AppendLine("<li><pre style=\"font-family:Verdana;font-size:10px;\"><b>E0384O2P Special Overwrite job (in E0384T.GRPLIB.JCL)</b></pre></li>"); //emailBody.AppendLine("<li><pre style=\"font-family:Verdana;font-size:10px;\"><b>E0385WHP WIFY prep job </b></pre></li>"); //emailBody.AppendLine("<li><pre style=\"font-family:Verdana;font-size:10px;\"><b>E0385WFP restart the WIFY job </b></pre> </li>"); //emailBody.Append("</ul>"); //emailBody.AppendLine("<br />"); //emailBody.AppendLine("<div style = \"float:left;\">The parameters needed for the execution of job "); //emailBody.Append("<b> E0384O2P </b>"); //emailBody.Append("reside in "); //emailBody.Append("<b>E0384T.TEMP.PARAMFL(CYV).</b>"); //emailBody.Append("They should be set up prior to running the jobs:</div>"); //emailBody.AppendLine("<div style = \"font-family:Verdana;font-size:10px; \">PARAMETER000 CYCPOVRT " + targetDate + " CYCLE DATE *** USE PREVIOUS DAY’S <b>PARMS</b></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">TYPRUN 001 NEVER <b>WHEN RUNNING SPECIAL</b></pre>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">FMCYCDT 002 CC <b>" + targetDate + "</b> CYCLE DATE <b>OVERWRITE ***</b></pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">FMEXADT 003 CC <b>" + targetDate + "</b> HIGH ACTIVITY DATE (MON USE FRI HIGH)</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">DIVCYCDT 004 CC <b>" + targetDate + "</b> (NEVER) INTRODUCTION CYCLE DATE</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">DIVEXADT 005 CC <b>" + targetDate + "</b> (NEVER) INTRODUCTION EXACT DATE</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">HIACTYDT 006 CC <b>" + targetDate + "</b> HIGH ACTIVITY DATE (MON USE FRI HIGH)</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">ENVIRON 007 D CONSTANT</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">CHKPTFREQ008 1000 CONSTANT</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">EQUITYDB 013x Y UPDATE EQUITY INDEX DB Y OR N</pre></div>"); //emailBody.AppendLine("<div><pre style=\"font-family:Verdana;font-size:10px;\">CYCLE-ID 014 T CYCLE IDENT; T=TRADITIONAL CYCLE</pre></div>"); emailBody.Append("</body>"); emailBody.Append("</html>"); mailMessage.Body = emailBody.ToString(); mailMessage.IsBodyHtml = true; //create Alrternative HTML view //AlternateView htmlView = AlternateView.CreateAlternateViewFromString(mailMessage.Body, null, CommonConstants.MailType); ////Add Image //LinkedResource theEmailImage = new LinkedResource(logo1); //theEmailImage.ContentId = CommonConstants.ImageId; ////Add the Image to the Alternate view //htmlView.LinkedResources.Add(theEmailImage); //Add view to the Email Message ////mailMessage.AlternateViews.Add(htmlView); SmtpClient smtpClient = new SmtpClient(smtpServer); smtpClient.Port = Int16.Parse(smtpPort); smtpClient.Send(mailMessage); } catch (System.Net.Mail.SmtpException exception) { errorMessage = exception.Message; status = false; } finally { if (mailMessage != null) { mailMessage.Dispose(); mailMessage = null; } sepArray = null; } return(status); }
/// <summary> /// Adding new policy detials into database. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { PolicyDetailsBusinessEntity policyDetails = new PolicyDetailsBusinessEntity(); MilePostBuzLogic milePostBuzObj = new MilePostBuzLogic(); UserInfoDetailsBusinessEntity userInfo = (UserInfoDetailsBusinessEntity)Session[CommonConstants.UserInfo]; int addStatus = CommonConstants.StatusZero; bool exist = false; int status = 0; bool sendMailStatus = false; DataSet dsPolicyUnapprove = (DataSet)Cache[CommonConstants.PolicyUnapproved]; DataSet dsAllPolicyNo = milePostBuzObj.GetAllPolicyNumber(); try { policyDetails.PolicyNo = txtPolicyNo.Text.Trim(); policyDetails.UserId = userInfo.UserId; policyDetails.UserName = userInfo.UserName; policyDetails.RequestDate = txtRequestDate.Text.Trim(); policyDetails.PhoneNumber = userInfo.PhoneNumber.Trim(); policyDetails.BusinessReason = txtBusinessReason.Text.Trim(); policyDetails.RootSegmentCount = Int16.Parse(txtRootSegCount.Text.Trim()); policyDetails.FaceSegmentCount = Int16.Parse(txtFaceSegCount.Text.Trim()); policyDetails.MachineSegmentCount = Int16.Parse(txtMachineSegCount.Text.Trim()); if (Session[CommonConstants.SelectedRowIndex] != null) { status = milePostBuzObj.UpdatePolicyDetails(policyDetails); if (status == CommonConstants.StatusOne) { Session.Remove(CommonConstants.SelectedRowIndex); exist = true; ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.SuccessUpdate, true); txtPolicyNo.Enabled = CommonConstants.True; txtPolicyNo.Text = string.Empty; txtRequestDate.Text = string.Empty; txtRootSegCount.Text = string.Empty; txtBusinessReason.Text = string.Empty; txtMachineSegCount.Text = string.Empty; txtFaceSegCount.Text = string.Empty; } LoadGrid(); } else { for (int i = 0; i < dsPolicyUnapprove.Tables[0].Rows.Count; i++) { if (txtPolicyNo.Text.ToUpper() == Convert.ToString(dsPolicyUnapprove.Tables[0].Rows[i][2])) { status = milePostBuzObj.UpdatePolicyDetails(policyDetails); if (status == CommonConstants.StatusOne) { LoadGrid(); exist = true; ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.SuccessUpdate, true); txtPolicyNo.Text = string.Empty; txtRequestDate.Text = string.Empty; txtRootSegCount.Text = string.Empty; txtBusinessReason.Text = string.Empty; txtMachineSegCount.Text = string.Empty; txtFaceSegCount.Text = string.Empty; } break; } } if (dsAllPolicyNo.Tables[0].Rows.Count > CommonConstants.StatusOne) { for (int i = 0; i < dsAllPolicyNo.Tables[0].Rows.Count; i++) { if (txtPolicyNo.Text.ToUpper() == Convert.ToString(dsAllPolicyNo.Tables[0].Rows[i][0])) { if (Convert.ToChar(dsAllPolicyNo.Tables[0].Rows[i][7]) == CommonConstants.ApproveIndN || Convert.ToChar(dsAllPolicyNo.Tables[0].Rows[i][7]) == CommonConstants.ApproveIndn) { ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.AddFailure, true); exist = true; break; } else { if (Convert.ToChar(dsAllPolicyNo.Tables[0].Rows[i][7]) == CommonConstants.ApproveIndY || Convert.ToChar(dsAllPolicyNo.Tables[0].Rows[i][7]) == CommonConstants.ApproveIndy) { ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.AlreadyApproved, true); if (lblNoRecords.Visible) { lblNoRecords.Visible = CommonConstants.False; } exist = true; break; } } } } } if (!exist) { addStatus = milePostBuzObj.AddPolicyDetails(policyDetails); if (addStatus == CommonConstants.StatusOne) { policyDetails.MailId = userInfo.EmailId; // sendMailStatus = milePostBuzObj.SendEmail(policyDetails); if (sendMailStatus) { LoadGrid(); //ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.MailSuccess, true); } ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.SuccessAdded, true); txtPolicyNo.Text = string.Empty; txtRequestDate.Text = string.Empty; txtRootSegCount.Text = string.Empty; txtBusinessReason.Text = string.Empty; txtMachineSegCount.Text = string.Empty; txtFaceSegCount.Text = string.Empty; } LoadGrid(); } } } catch (Exception ex) { HandleLogging.AddtoLogFile(ex.ToString(), CommonConstants.PolicyEntry); Response.Redirect(CommonConstants.Error); } finally { Session.Remove(CommonConstants.SelectedRowIndex); } }
/// <summary> /// Invokes SendApproveRejectMail method of the MilePostProvider class to send trigger mail on policy approval or policy reject to Account Team. /// </summary> /// <param name="?"></param> /// <returns></returns> public bool SendApproveRejectMail(PolicyDetailsBusinessEntity policyDetails, UserInfoDetailsBusinessEntity userInfoDetails, string mailType) { bool status = true; char[] sepArray = new char[] { ',', ';' }; StringBuilder emailBody = null; string errorMessage = string.Empty; string policyNo = policyDetails.PolicyNo; string phoneNo = userInfoDetails.PhoneNumber; string date = DateTime.Today.ToString(CommonConstants.DateFormat); int pmrRecordCnt = policyDetails.RootSegmentCount; int machineRecordCnt = policyDetails.MachineSegmentCount; int faceRecordCnt = policyDetails.FaceSegmentCount; string businessReason = policyDetails.BusinessReason; string rejectedReason = policyDetails.RejectedReason; MailMessage mailMessage = null; string emailAddress = string.Empty; try { conn = new SqlConnection(connStr); emailBody = new StringBuilder(); //New code conn.Open(); SqlCommand cmd = new SqlCommand(sqlQry.UpdatePolicyRejectQuery(policyDetails, userInfoDetails), conn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); //status = CommonConstants.StatusOne; ///////////////// //Mail Message mailMessage = new MailMessage(); mailMessage.From = new MailAddress(fromEmailAddress); mailMessage.To.Add(new MailAddress(policyDetails.MailId)); mailMessage.CC.Add(new MailAddress(userInfoDetails.EmailId)); emailBody.Append(@"<html><body><div><img src=cid:myImageID> </div>"); emailBody.AppendLine(CommonConstants.StartNewLine); emailBody.Append("<div style=\"font-family:Verdana;font-size:10px;\">"); emailBody.AppendLine("<div style=\"text-align:right;\"><b>Date: </b>" + date + "</div>"); if (mailType == CommonConstants.MailType_Approval) { mailMessage.Subject = CommonConstants.MailSubjectApproval + policyNo; emailBody.AppendLine("<hr />"); emailBody.AppendLine(CommonConstants.MailBodyApproval_Initial); emailBody.Append(CommonConstants.Div_PolicyNumber + policyNo + CommonConstants.DIV); emailBody.Append(CommonConstants.Div_BusinessReason + businessReason + CommonConstants.DIV); } else { mailMessage.Subject = CommonConstants.MailSubjectRejection + policyNo; emailBody.AppendLine("<div style=\"text-align:right;\"><b>Phone No:</b> " + phoneNo + "</div>"); emailBody.AppendLine("<hr />"); emailBody.AppendLine(CommonConstants.MailBodyRejection_Initial); emailBody.Append(CommonConstants.Div_PolicyNumber + policyNo + CommonConstants.DIV); emailBody.Append(CommonConstants.Div_BusinessReason + businessReason + CommonConstants.DIV); emailBody.Append(CommonConstants.Div_RejectedReason + rejectedReason + CommonConstants.DIV); } emailBody.Append(CommonConstants.EndNewLine); emailBody.Append(CommonConstants.DIV); emailBody.Append(CommonConstants.BODY); emailBody.Append(CommonConstants.HTML); mailMessage.Body = emailBody.ToString(); mailMessage.IsBodyHtml = true; //create Alrternative HTML view AlternateView htmlView = AlternateView.CreateAlternateViewFromString(mailMessage.Body, null, CommonConstants.MailType); //Add Image LinkedResource theEmailImage = new LinkedResource(logo1); theEmailImage.ContentId = CommonConstants.ImageId; //Add the Image to the Alternate view htmlView.LinkedResources.Add(theEmailImage); //Add view to the Email Message mailMessage.AlternateViews.Add(htmlView); SmtpClient smtpClient = new SmtpClient(smtpServer); smtpClient.Port = 25; smtpClient.Send(mailMessage); } catch (System.Net.Mail.SmtpException exception) { errorMessage = exception.Message; status = false; } finally { if (mailMessage != null) { mailMessage.Dispose(); mailMessage = null; } sepArray = null; } return(status); }
protected void btnSubmit_Click(object sender, EventArgs e) { ArrayList rowIndex = null; ArrayList rowIndexRejected = null; int status; //bool sendMailStatus = false; bool sendMailStatus = true; SaveCheckedValues(); UserInfoDetailsBusinessEntity userInfo = null; PolicyDetailsBusinessEntity policyDetails = null; MilePostBuzLogic milePostBuzObj = new MilePostBuzLogic(); DataSet ds = milePostBuzObj.GetAllPolicyNumber(); try { if (Session[CommonConstants.CheckedItems] != null || Session[CommonConstants.CheckedRejected] != null) { rowIndex = (ArrayList)Session[CommonConstants.CheckedItems]; rowIndexRejected = (ArrayList)Session[CommonConstants.CheckedRejected]; if (Session[CommonConstants.UserInfo] != null) { userInfo = (UserInfoDetailsBusinessEntity)Session[CommonConstants.UserInfo]; } if (rowIndex != null) { if (rowIndex.Count > 1) { if (rowIndexRejected != null) { if (rowIndexRejected.Count > 1) { lblNotSelected.Visible = CommonConstants.True; lblNotSelected.Text = CommonConstants.MsgSelectAppRej; } } else { lblNotSelected.Visible = CommonConstants.True; lblNotSelected.Text = CommonConstants.MsgSelectApprove; } } else { if (rowIndexRejected != null) { if (rowIndexRejected.Count > 1 || rowIndexRejected.Count == 1) { lblNotSelected.Visible = CommonConstants.True; lblNotSelected.Text = CommonConstants.MsgSelectAppRej; } } else { policyDetails = new PolicyDetailsBusinessEntity(); policyDetails.UserId = userInfo.UserId; policyDetails.ApprovalId = userInfo.UserId; policyDetails.PolicyNo = rowIndex[0].ToString(); status = milePostBuzObj.UpdateApprovalDetails(policyDetails); if (status == CommonConstants.StatusOne) { LoadGrid(); ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.SuccessApprove, true); if (ds.Tables[0].Rows.Count > CommonConstants.StatusZero) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { policyDetails = new PolicyDetailsBusinessEntity(); if (rowIndex[0].ToString() == Convert.ToString(ds.Tables[0].Rows[i][0])) { policyDetails.PolicyNo = Convert.ToString(ds.Tables[0].Rows[i][0]); policyDetails.BusinessReason = Convert.ToString(ds.Tables[0].Rows[i][1]); policyDetails.MailId = Convert.ToString(ds.Tables[0].Rows[i][6]); break; } } } //sendMailStatus = milePostBuzObj.SendApproveRejectMail(policyDetails, userInfo, CommonConstants.ApproveInd); if (sendMailStatus) { LoadGrid(); if (lblNotSelected.Visible) { lblNotSelected.Visible = CommonConstants.False; } } } if (lblNotSelected.Visible) { lblNotSelected.Visible = CommonConstants.False; } } } } else { if (rowIndexRejected != null) { if (rowIndexRejected.Count > 1) { lblNotSelected.Visible = CommonConstants.True; lblNotSelected.Text = CommonConstants.MsgSelectReject; } else { if (txtReasonReject.Text == string.Empty) { lblNotSelected.Visible = CommonConstants.True; lblNotSelected.Text = CommonConstants.MsgProvideReason; } else { if (ds.Tables[0].Rows.Count > CommonConstants.StatusZero) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { policyDetails = new PolicyDetailsBusinessEntity(); if (rowIndexRejected[0].ToString() == Convert.ToString(ds.Tables[0].Rows[i][0])) { policyDetails.PolicyNo = rowIndexRejected[0].ToString(); policyDetails.BusinessReason = Convert.ToString(ds.Tables[0].Rows[i][1]); policyDetails.MailId = Convert.ToString(ds.Tables[0].Rows[i][6]); policyDetails.RejectedReason = txtReasonReject.Text; break; } } } //sendMailStatus = milePostBuzObj.SendApproveRejectMail(policyDetails, userInfo, CommonConstants.RejectInd); if (sendMailStatus) { LoadGrid(); ScriptManager.RegisterStartupScript(this, GetType(), CommonConstants.ShowAlert, CommonConstants.SucccessReject, true); txtReasonReject.Text = string.Empty; if (lblNotSelected.Visible) { lblNotSelected.Visible = CommonConstants.False; } } } } } } } else { lblNotSelected.Visible = CommonConstants.True; lblNotSelected.Text = CommonConstants.MsgSelectAppRej; } } catch (Exception ex) { HandleLogging.AddtoLogFile(ex.ToString(), CommonConstants.AccountApproval); Response.Redirect(CommonConstants.Error); } finally { Session.Remove(CommonConstants.CheckedItems); Session.Remove(CommonConstants.CheckedRejected); } }