protected void btnSaveAuthorizeLetter_Click(object sender, EventArgs e) { try { string strPath = string.Empty; strPath = Server.MapPath("~/MailTemplate" + "/AuthorizeLetter.docx"); string strPath2 = string.Empty; string SaveLoc = Server.MapPath("~/NoticeCopies/" + Session["CBViewNoticeID"].ToString() + "/"); strPath2 = Server.MapPath("~/NoticeCopies/" + Session["CBViewNoticeID"].ToString() + "/AuthorizeLetter.doc"); test = new CCWordApp(); test.Open(); string str = test.GetContent(); string NewLine = string.Empty; NewLine = txtgenMailText.Text; test.InsertText(NewLine); if (System.IO.Directory.Exists(SaveLoc) == false) { // Try to create the directory. System.IO.DirectoryInfo di = System.IO.Directory.CreateDirectory(SaveLoc); } if (System.IO.File.Exists(strPath2)) { System.IO.File.Delete(strPath2); } test.SaveAs(strPath2); int FiletypeID = 1; string FilePath = "NoticeCopies/" + Session["CBViewNoticeID"].ToString() + "/AuthorizeLetter.doc"; int DocumentTypeID = 1; int IsEditable = 1; DataSet dsData = objdropdownBL.SaveCBDocumnetsForProcess(Convert.ToInt32(Session["CBViewNoticeID"]), FiletypeID, FilePath, Convert.ToInt32(Session[Constants.USER_ID].ToString()), DocumentTypeID, IsEditable); test.Quit(); } catch (Exception ex) { throw ex; } }
public string AuthroizationLetter(ref string strMailFormat, string CBViewNoticeID, string Agentname) { DataSet dsDate = objdropdownBL.GetDatetime(); DateTime ToDayDate = Convert.ToDateTime(dsDate.Tables[0].Rows[0]["Datetime"].ToString()); test = new CCWordApp(); string line = string.Empty; string strPath = string.Empty; string strPath2 = string.Empty; //DataSet dsInfo = objdropdownBL.GetPackageDetailsByUIDForAuthLetter(); strPath = HttpContext.Current.Server.MapPath("~/MailTemplate/AuthorizeLetter.docx"); strPath2 = HttpContext.Current.Server.MapPath("~/NoticeCopies/" + CBViewNoticeID + "/AuthorizeLetter.doc"); test.Open(strPath); string str = test.GetContent(); string NewLine = string.Empty; line = str; if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#VoiceFile#")) { line = line.Replace("#VoiceFile#", ""); } if (line.Contains("#Recorddate#")) { line = line.Replace("#Recorddate#", ""); } if (line.Contains("#AgentName#")) { line = line.Replace("#AgentName#", Agentname.ToString()); } if (line.Contains("#TodayDate#")) { line = line.Replace("#TodayDate#", ToDayDate.ToString("MM/dd/yyyy")); } if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#Phone#")) { line = line.Replace("#Phone#", ""); } if (line.Contains("#Address#")) { line = line.Replace("#Address#", ""); } if (line.Contains("#VehiclesCount#")) { line = line.Replace("#VehiclesCount#", "0"); } if (line.Contains("#Amount#")) { line = line.Replace("#Amount#", "0.00"); } if (line.Contains("#Payment#")) { line = line.Replace("#Payment#", ""); } if (line.Contains("xxxxxxxxxxxx1015")) { line = line.Replace("xxxxxxxxxxxx1015", ""); } if (line.Contains("XX/XX")) { line = line.Replace("XX/XX", ""); } if (line.Contains("CVX")) { line = line.Replace("CVX", ""); } if (line.Contains("#CustEmail#")) { line = line.Replace("#CustEmail#", ""); } //address city, state zip test.Quit(); return line; }
protected void lnkbtnAuthorizationLetter_Click(object sender, EventArgs e) { try { DataSet dsDate = objdropdownBL.GetDatetime(); DateTime ToDayDate = Convert.ToDateTime(dsDate.Tables[0].Rows[0]["Datetime"].ToString()); if ((Session["CBClaimsCustID"] == null) || (Session["CBClaimsCustID"].ToString() == "")) { //mdepCBAlert.Show(); //lblCBAlertMsg.Visible = true; //lblCBAlertMsg.Text = "User information not available for this notice"; System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "sample();", true); clsMailFormats format = new clsMailFormats(); string text = string.Empty; string strPath2 = string.Empty; CCWordApp testNew = new CCWordApp(); string line = string.Empty; string strPath = string.Empty; string strPath1 = string.Empty; //DataSet dsInfo = objdropdownBL.GetPackageDetailsByUIDForAuthLetter(); strPath = HttpContext.Current.Server.MapPath("~/MailTemplate/") + "AuthorizeLetter.docx"; strPath2 = HttpContext.Current.Server.MapPath("~/NoticeCopies/" + Session["CBViewNoticeID"].ToString() + "/") + "AuthorizeLetter.doc"; testNew.Open(strPath); string str = testNew.GetContent(); string NewLine = string.Empty; line = str; if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#VoiceFile#")) { line = line.Replace("#VoiceFile#", ""); } if (line.Contains("#Recorddate#")) { line = line.Replace("#Recorddate#", ""); } if (line.Contains("#AgentName#")) { line = line.Replace("#AgentName#", Session[Constants.NAME].ToString()); } if (line.Contains("#TodayDate#")) { line = line.Replace("#TodayDate#", ToDayDate.ToString("MM/dd/yyyy")); } if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#Phone#")) { line = line.Replace("#Phone#", ""); } if (line.Contains("#Address#")) { line = line.Replace("#Address#", ""); } if (line.Contains("#VehiclesCount#")) { line = line.Replace("#VehiclesCount#", "0"); } if (line.Contains("#Amount#")) { line = line.Replace("#Amount#", "0.00"); } if (line.Contains("#Payment#")) { line = line.Replace("#Payment#", ""); } if (line.Contains("xxxxxxxxxxxx1015")) { line = line.Replace("xxxxxxxxxxxx1015", ""); } if (line.Contains("XX/XX")) { line = line.Replace("XX/XX", ""); } if (line.Contains("CVX")) { line = line.Replace("CVX", ""); } if (line.Contains("#CustEmail#")) { line = line.Replace("#CustEmail#", ""); } //address city, state zip testNew.Quit(); txtgenMailText.Text = line; mdepAuthorizeLetter.Show(); } else { Session.Timeout = 180; clsMailFormats format = new clsMailFormats(); string text = string.Empty; string strPath2 = string.Empty; CCWordApp testNew = new CCWordApp(); string line = string.Empty; string strPath = string.Empty; string strPath1 = string.Empty; //DataSet dsInfo = objdropdownBL.GetPackageDetailsByUIDForAuthLetter(); strPath = HttpContext.Current.Server.MapPath("~/MailTemplate/") + "AuthorizeLetter.docx"; strPath2 = HttpContext.Current.Server.MapPath("~/NoticeCopies/" + Session["CBViewNoticeID"].ToString() + "/") + "AuthorizeLetter.doc"; if (System.IO.File.Exists(strPath2)) { testNew.Open(strPath2); string str = testNew.GetContent(); string NewLine = string.Empty; line = str; testNew.Quit(); txtgenMailText.Text = line; } else { DataSet dsPackageInfo = objdropdownBL.GetPackageDetailsByUIDForAuthLetter(Convert.ToInt32(Session["CBClaimsCustID"].ToString())); if (dsPackageInfo.Tables.Count > 0) { if (dsPackageInfo.Tables[0].Rows.Count > 0) { testNew.Open(strPath); string str = testNew.GetContent(); string NewLine = string.Empty; line = str; string recordDate = string.Empty; if (dsPackageInfo.Tables[0].Rows[0]["PayDate"].ToString() != "") { DateTime dtRD = Convert.ToDateTime(dsPackageInfo.Tables[0].Rows[0]["PayDate"].ToString()); recordDate = dtRD.ToString("MM/dd/yyyy"); } else { recordDate = ""; } if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", dsPackageInfo.Tables[0].Rows[0]["Name"].ToString()); } if (line.Contains("#VoiceFile#")) { line = line.Replace("#VoiceFile#", dsPackageInfo.Tables[0].Rows[0]["VoiceRecord"].ToString()); } if (line.Contains("#Recorddate#")) { line = line.Replace("#Recorddate#", recordDate); } if (line.Contains("#AgentName#")) { line = line.Replace("#AgentName#", Session[Constants.NAME].ToString()); } if (line.Contains("#TodayDate#")) { line = line.Replace("#TodayDate#", ToDayDate.ToString("MM/dd/yyyy")); } if (line.Contains("#Phone#")) { line = line.Replace("#Phone#", dsPackageInfo.Tables[0].Rows[0]["phoneNumber"].ToString()); } string Address = dsPackageInfo.Tables[0].Rows[0]["Address"].ToString(); string City = dsPackageInfo.Tables[0].Rows[0]["City"].ToString(); string State = dsPackageInfo.Tables[0].Rows[0]["State_Code"].ToString(); string Zip = dsPackageInfo.Tables[0].Rows[0]["Zip"].ToString(); string FullAddress = string.Empty; FullAddress = Address; if (FullAddress != "") { FullAddress = FullAddress + " " + City; } else { FullAddress = City; } if (FullAddress != "") { FullAddress = FullAddress + ", " + State; } else { FullAddress = State; } if (FullAddress != "") { FullAddress = FullAddress + " " + Zip; } else { FullAddress = Zip; } if (line.Contains("#Address#")) { line = line.Replace("#Address#", FullAddress); } if (line.Contains("#VehiclesCount#")) { line = line.Replace("#VehiclesCount#", dsPackageInfo.Tables[1].Rows.Count.ToString()); } if (line.Contains("#Amount#")) { line = line.Replace("#Amount#", string.Format("{0:0.00}", Convert.ToDouble(dsPackageInfo.Tables[0].Rows[0]["Price"].ToString()))); } if (line.Contains("#Payment#")) { line = line.Replace("#Payment#", dsPackageInfo.Tables[0].Rows[0]["cardType"].ToString()); } string CardNum = dsPackageInfo.Tables[0].Rows[0]["cardNumber"].ToString(); if (CardNum.Length > 0) { CardNum = CardNum.Substring(Convert.ToInt32(CardNum.Length - 4), 4); CardNum = "xxxxxxxxxxxx" + CardNum.ToString(); } else { CardNum = "xxxxxxxxxxxxxxxx"; } if (line.Contains("xxxxxxxxxxxx1015")) { line = line.Replace("xxxxxxxxxxxx1015", CardNum); } string EXpDate = dsPackageInfo.Tables[0].Rows[0]["cardExpDt"].ToString(); string expirtdt = string.Empty; if (EXpDate != "") { string[] EXpDt = EXpDate.Split(new char[] { '/' }); expirtdt = EXpDt[0].ToString() + "/" + "20" + EXpDt[1].ToString(); } else { expirtdt = EXpDate; } if (line.Contains("XX/XX")) { line = line.Replace("XX/XX", expirtdt); } if (line.Contains("CVX")) { line = line.Replace("CVX", dsPackageInfo.Tables[0].Rows[0]["cardCode"].ToString()); } if (line.Contains("#CustEmail#")) { line = line.Replace("#CustEmail#", dsPackageInfo.Tables[0].Rows[0]["UserName"].ToString()); } //test.SaveAs(strPath2); testNew.Quit(); } else { testNew.Open(strPath); string str = testNew.GetContent(); string NewLine = string.Empty; line = str; if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#VoiceFile#")) { line = line.Replace("#VoiceFile#", ""); } if (line.Contains("#Recorddate#")) { line = line.Replace("#Recorddate#", ""); } if (line.Contains("#AgentName#")) { line = line.Replace("#AgentName#", Session[Constants.NAME].ToString()); } if (line.Contains("#TodayDate#")) { line = line.Replace("#TodayDate#", ToDayDate.ToString("MM/dd/yyyy")); } if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#Phone#")) { line = line.Replace("#Phone#", ""); } if (line.Contains("#Address#")) { line = line.Replace("#Address#", ""); } if (line.Contains("#VehiclesCount#")) { line = line.Replace("#VehiclesCount#", "0"); } if (line.Contains("#Amount#")) { line = line.Replace("#Amount#", "0.00"); } if (line.Contains("#Payment#")) { line = line.Replace("#Payment#", ""); } if (line.Contains("xxxxxxxxxxxx1015")) { line = line.Replace("xxxxxxxxxxxx1015", ""); } if (line.Contains("XX/XX")) { line = line.Replace("XX/XX", ""); } if (line.Contains("CVX")) { line = line.Replace("CVX", ""); } if (line.Contains("#CustEmail#")) { line = line.Replace("#CustEmail#", ""); } //address city, state zip testNew.Quit(); } } else { testNew.Open(strPath); string str = testNew.GetContent(); string NewLine = string.Empty; line = str; if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#VoiceFile#")) { line = line.Replace("#VoiceFile#", ""); } if (line.Contains("#Recorddate#")) { line = line.Replace("#Recorddate#", ""); } if (line.Contains("#AgentName#")) { line = line.Replace("#AgentName#", Session[Constants.NAME].ToString()); } if (line.Contains("#TodayDate#")) { line = line.Replace("#TodayDate#", ToDayDate.ToString("MM/dd/yyyy")); } if (line.Contains("#CustName#")) { line = line.Replace("#CustName#", ""); } if (line.Contains("#Phone#")) { line = line.Replace("#Phone#", ""); } if (line.Contains("#Address#")) { line = line.Replace("#Address#", ""); } if (line.Contains("#VehiclesCount#")) { line = line.Replace("#VehiclesCount#", "0"); } if (line.Contains("#Amount#")) { line = line.Replace("#Amount#", "0.00"); } if (line.Contains("#Payment#")) { line = line.Replace("#Payment#", ""); } if (line.Contains("xxxxxxxxxxxx1015")) { line = line.Replace("xxxxxxxxxxxx1015", ""); } if (line.Contains("XX/XX")) { line = line.Replace("XX/XX", ""); } if (line.Contains("CVX")) { line = line.Replace("CVX", ""); } if (line.Contains("#CustEmail#")) { line = line.Replace("#CustEmail#", ""); } //address city, state zip testNew.Quit(); } //test = new CCWordApp(); //test.Open(strPath1); //test.InsertText(NewLine); //test.SaveAs(strPath2); //test.Quit(); txtgenMailText.Text = line; } mdepAuthorizeLetter.Show(); } } catch (Exception ex) { throw ex; } }