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();
}
}
