protected void btn_Add_Click(object sender, EventArgs e) { int _id = LettersGenDAL.insertNewLetterType(txtletterType.Text, txtLetterCode.Text); ddlLetterType.DataBind(); resetControls(); //audit insert }
protected void lnkViewStg_onclick(Object sender, EventArgs e) { clearMessages(); LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; string _schemaUri = "EBAnamespace"; string _schemaAlias = "EBAHRA"; try { int _lgid = Convert.ToInt32(grdvStageTemplates.DataKeys[row.RowIndex].Value); string _letterCode = LettersGenDAL.getLetterTypeCodeStage(_lgid); string _schemaPath = ""; if (_letterCode.Equals("HRB1") || _letterCode.Equals("HRB2")) { _schemaPath = FilePaths.getFilePath("SchemaValid"); } else { _schemaPath = FilePaths.getFilePath("Schema"); } string _template = LettersGenDAL.getStageTemplate(_lgid); string _filepath = "C:\\EBATemp\\"; string _file = _filepath + "Template.xml"; int _seq = 0; ClientScriptManager cs = Page.ClientScript; if (!cs.IsClientScriptBlockRegistered(_seq + "DeleteFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "DeleteFile", "DeleteFile('" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "SaveFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "SaveFile", "SaveFile('" + _template.Replace(Environment.NewLine, "") + "', '" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "DownloadWord")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "DownloadWord", "DownloadTemplate('" + _file.Replace("\\", "\\\\") + "', '" + _schemaPath + "','" + _schemaAlias + "','" + _schemaUri + "');", true); } } catch (Exception ex) { errorDiv3.Visible = true; lblErr3.Text = "Error downloading File - " + ex.Message; } }
protected void getVersion() { int _typeId = Convert.ToInt32(ddlLetterType.SelectedItem.Value); string _type = ddlLetterType.SelectedItem.Text; string _uptype = ddlUploadType.SelectedItem.Text; txtVersion.Text = ""; if (!_type.Equals("--Select Type--") && !_uptype.Equals("--Select--")) { int _version = LettersGenDAL.getTemplateVersion(_typeId); txtVersion.Text = (_version + 1).ToString(); } }
protected void getVersion() { string _typeCode = ddlLetterType.SelectedItem.Value; string _type = ddlLetterType.SelectedItem.Text; txtVersion.Text = ""; if (!_type.Equals("--Select Type--")) { int _version = LettersGenDAL.getTemplateVersion(_typeCode); if (_version != 0) { txtVersion.Text = (_version).ToString(); } else { txtVersion.Text = "N/A"; } } }
protected void lnkView_onclick(Object sender, EventArgs e) { clearMessages(); try { LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; int _lgid = Convert.ToInt32(grdvltrTemplates.DataKeys[row.RowIndex].Value); string _template = LettersGenDAL.getTemplate(_lgid); //string _filepath = FilePaths.getFilePath("Uploads"); //string _file = _filepath + "Template.xml"; string _filepath = "C:\\EBATemp\\"; string _file = _filepath + "Template.xml"; int _seq = 0; ClientScriptManager cs = Page.ClientScript; if (!cs.IsClientScriptBlockRegistered(_seq + "SaveFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "SaveFile", "SaveTextFile('" + _template.Replace(Environment.NewLine, "") + "', '" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "ViewWord")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "ViewWord", "OpenWord('" + _file.Replace("\\", "\\\\") + "');", true); } } catch (Exception ex) { errorDiv1.Visible = true; lblErrorTemplates.Text = "Error viewing File - " + ex.Message; } }
protected void grdvStageTemplate_rowCommand(Object sender, GridViewCommandEventArgs e) { try { if (e.CommandName.Equals("UpdateAlt")) { GridViewRow row = (GridViewRow)((Control)e.CommandSource).Parent.Parent; int index = row.RowIndex; CheckBox cbx1 = row.FindControl("cbxAprrovedE") as CheckBox; if (cbx1.Checked) { int _id = Convert.ToInt32(grdvStageTemplates.DataKeys[index].Value); LettersGenDAL.StoreTemplate(_id); grdvStageTemplates.EditIndex = -1; grdvLetter.DataBind(); } } } catch (Exception ex) { } }
protected void lnkPrint_onclick(Object sender, EventArgs e) { clearMessages(); LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; int _lgid = Convert.ToInt32(grdvltrPending.DataKeys[row.RowIndex].Value); string _empNum = grdvltrPending.Rows[row.RowIndex].Cells[1].Text; string _dpndssn = grdvltrPending.Rows[row.RowIndex].Cells[2].Text; string _dpndRel = grdvltrPending.Rows[row.RowIndex].Cells[3].Text; string _letterType = ""; switch (_dpndRel) { case "SP": _letterType = "HRB1"; break; case "CH": _letterType = "HRB2"; break; } LetterGen gObj = new LetterGen("EBAnamespace"); Type cstype = this.GetType(); try { int _version = LettersGenDAL.getTemplateVersion(_letterType); string[] _Letter = gObj.generateBenValidationLetter(Convert.ToInt32(_empNum), _dpndssn, _letterType, _version, _lgid); ClientScriptManager cs = Page.ClientScript; string _filepath = "C:\\EBATemp\\"; string _file = _filepath + "Print.xml"; int _seq = 0; foreach (string _lt in _Letter) { try { if (!cs.IsClientScriptBlockRegistered(_seq + "SaveExcel")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "SaveExcel", "SaveTextFile('" + _lt.Replace(Environment.NewLine, "") + "', '" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "PrintWord")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "PrintWord", "PrintWord('" + _file.Replace("\\", "\\\\") + "');", true); } } finally { EndProcess(); if (!cs.IsClientScriptBlockRegistered(_seq + "DeleteFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "DeleteFile", "DeleteFile('" + _file.Replace("\\", "\\\\") + "');", true); } } _seq++; } } catch (Exception ex) { errorDiv2.Visible = true; lbl_error1.Text = "Some error occured while printing letters - " + ex.Message; } finally { grdvltrPending.DataBind(); grdvLtrPendingreprint.DataBind(); } }
protected void lnkGen1_Click(object sender, EventArgs e) { string _ltrType = ddlLetterType.SelectedItem.Text; string _ltrCode = ddlLetterType.SelectedItem.Value; string _empnums = txtEmpNum.Text.Trim(); clearMessages(); List <string> _elList0 = new List <string>(); List <string> _elList1 = new List <string>(); string _exceptionEmpl = ""; LetterGen gObj = new LetterGen("EBAnamespace"); Type cstype = this.GetType(); try { if (rdbFilter.SelectedValue.Equals("0")) { int _version = LettersGenDAL.getTemplateVersion(_ltrCode); string[] _Letter = gObj.generateLetter(_ltrCode, _version, false); ClientScriptManager cs = Page.ClientScript; string _filepath = "C:\\EBATemp\\"; string _file = _filepath + "Print.xml"; int _seq = 0; foreach (string _lt in _Letter) { try { if (!cs.IsClientScriptBlockRegistered(_seq + "SaveExcel")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "SaveExcel", "SaveTextFile('" + _lt.Replace(Environment.NewLine, "") + "', '" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "PrintWord")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "PrintWord", "PrintWord('" + _file.Replace("\\", "\\\\") + "');", true); } } finally { EndProcess(); if (!cs.IsClientScriptBlockRegistered(_seq + "DeleteFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "DeleteFile", "DeleteFile('" + _file.Replace("\\", "\\\\") + "');", true); } } _seq++; } } else if (rdbFilter.SelectedValue.Equals("1")) { if (!_empnums.Equals("")) { _elList0 = gObj.createEmpList(_empnums); foreach (string _empl in _elList0) { PilotData pData = new PilotData(); int _order = pData.getBeneficiaryOrders(Convert.ToInt32(_empl)); if (_order == 0) { //The following logic was replaced due to an exception ..3/9/2009 R.A - as per Andrea D // The Ben Designation letter should print even when there are no dependants for a Pilot //_exceptionEmpl += " " + _empl + ","; //Added this line..where Pilots with no deps are added to the _elist to print the letter _elList1.Add(_empl); } else { _elList1.Add(_empl); } pData = null; } if (!_exceptionEmpl.Equals("")) { infoDiv1.Visible = true; _exceptionEmpl = _exceptionEmpl.Remove(_exceptionEmpl.Length - 1); lblInfo.Text = "Employee number(s) <br/>" + _exceptionEmpl + "<br/> don't have any Beneficiary Listed. <br/> No Letters were generated for above Employee Numbers"; } } string _empListFinal = gObj.createEmplCSV(_elList1); int _version = LettersGenDAL.getTemplateVersion(_ltrCode); string[] _Letter = gObj.generateLetter(_empListFinal, _ltrCode, _version); ClientScriptManager cs = Page.ClientScript; string _filepath = "C:\\EBATemp\\"; string _file = _filepath + "Print.xml"; int _seq = 0; foreach (string _lt in _Letter) { try { if (!cs.IsClientScriptBlockRegistered(_seq + "SaveExcel")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "SaveExcel", "SaveTextFile('" + _lt.Replace(Environment.NewLine, "") + "', '" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "PrintWord")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "PrintWord", "PrintWord('" + _file.Replace("\\", "\\\\") + "');", true); } } finally { EndProcess(); if (!cs.IsClientScriptBlockRegistered(_seq + "DeleteFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "DeleteFile", "DeleteFile('" + _file.Replace("\\", "\\\\") + "');", true); } } _seq++; } } } catch (Exception ex) { clearMessages(); errorDiv1.Visible = true; lbl_error.Text = "Some error occured while printing letters - " + ex.Message; } finally { Alert.Show("The Summary Plan Description (SPD) Addendum can be printed by clicking on the Generate SPD Letter"); } }
protected void lnkPrev_Click(object sender, EventArgs e) { string _ltrType = ddlLetterType.SelectedItem.Text; string _ltrCode = ddlLetterType.SelectedItem.Value; clearMessages(); LetterGen gObj = new LetterGen("EBAnamespace"); Type cstype = this.GetType(); try { int _version = LettersGenDAL.getTemplateVersion(_ltrCode); string[] _Letter = gObj.generateLetter(_ltrCode, _version, true); ClientScriptManager cs = Page.ClientScript; string _filepath = "C:\\EBATemp\\"; string _file = _filepath + "Print.xml"; int _seq = 0; foreach (string _lt in _Letter) { if (_seq == 2) { break; } try { if (!cs.IsClientScriptBlockRegistered(_seq + "SaveExcel")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "SaveExcel", "SaveTextFile('" + _lt.Replace(Environment.NewLine, "") + "', '" + _file.Replace("\\", "\\\\") + "');", true); } if (!cs.IsClientScriptBlockRegistered(_seq + "PrintWord")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "PrintWord", "PrintWord('" + _file.Replace("\\", "\\\\") + "');", true); } } finally { EndProcess(); if (!cs.IsClientScriptBlockRegistered(_seq + "DeleteFile")) { cs.RegisterClientScriptBlock(typeof(Page), _seq + "DeleteFile", "DeleteFile('" + _file.Replace("\\", "\\\\") + "');", true); } } _seq++; } } catch (Exception ex) { clearMessages(); errorDiv1.Visible = true; lbl_error.Text = "Some error occured while printing letters - " + ex.Message; } finally { } }
private bool ImportFile(string strUrl) { int _typeId = Convert.ToInt32(ddlLetterType.SelectedItem.Value); string _type = ddlLetterType.SelectedItem.Text; string _uptype = ddlUploadType.SelectedItem.Text; int _version = Convert.ToInt32(txtVersion.Text); StreamReader _reader; //_reader = File.OpenText(strUrl); _reader = new StreamReader(strUrl, Encoding.UTF8); string _content = _reader.ReadToEnd(); _content = LetterGen.replaceIllegalXMLCharacters(_content); try { if (!_uptype.Equals("In Validation")) { if (!LettersGenDAL.checkStageExists(_typeId, _version)) { try { LettersGenDAL.StoreStageTemplate(_typeId, _version, _content); //audit here } catch (Exception ex) { throw (new Exception("Error while importing Template.<br />" + ex.Message)); } } else { throw (new Exception("A version of the Letter type - " + _type + " and Version - " + _version + " is already in validation stage ")); } } else { if (LettersGenDAL.checkStageExists(_typeId, _version)) { try { LettersGenDAL.UpdateStageTemplate(_typeId, _version, _content); //audit here } catch (Exception ex) { throw (new Exception("Error while importing Template.<br />" + ex.Message)); } } else { throw (new Exception("A version of the Letter type - " + _type + " and Version - " + _version + " is not in validation stage. <br/> Please select Different Upload Type.")); } } return(true); } catch (Exception ex) { throw ex; } finally { _reader.Close(); } }