protected void imgBtnPrint_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
string[] datacolumn = new string[gridViewModuleDetails.Columns.Count - 1];
for (int i = 1; i < gridViewModuleDetails.Columns.Count - 1; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = gridViewModuleDetails.Columns[i].HeaderText;
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
clsPrint.TableName = "Disbursement Detail";
objPrint.Add(clsPrint);
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Module Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgbtnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2010";
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags pbfFlag = new Flags();
pbfFlag.key = "<br/>Agency ";
pbfFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(pbfFlag);
}
string[] header = new string[]
{
"loanNumberWithName",
"vsProjectComponent",
"LineMinister",
"NodalOfficer",
"ProjectDirector",
"ADBTaskManager"
};
string[] datacolumn = new string[grdProjectComponentDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop < header.Length + 1; iLoop++)
{
if (grdProjectComponentDetails.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectComponentDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Project Component Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
string[] datacolumn = new string[gridDesignationDetailsList.Columns.Count - 2];
for (int i = 1; i <= 2; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = gridDesignationDetailsList.Columns[i].HeaderText;
objPrint.Add(clsPrint);
}
excel.TableHeader = "Designation Detail";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgBtnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("iRoleID"))
{
dt.Columns.Remove("iRoleID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
string[] datacolumn = new string[grdRole.Columns.Count - 1];
for (int i = 1; i <= grdRole.Columns.Count - 2; i++)
{
if (grdRole.Columns[i].Visible != false)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = grdRole.Columns[i].HeaderText;
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
clsPrint.TableName = "Role Detail";
objPrint.Add(clsPrint);
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Role Detail";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (drplstQuarter.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "ToYear";
testFlag.value = drplstQuarter.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpFromYear.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "FromYear";
testFlag.value = drpFromYear.SelectedItem.Text;
flag.Add(testFlag);
}
if (drplstQuarter.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "ToQuarter";
testFlag.value = drplstQuarter.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpFromQuarter.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "FromQuarter";
testFlag.value = drpFromQuarter.SelectedItem.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"DocCategory",
"Tar",
"act",
"percentage"
};
try
{
string[] datacolumn = new string[grdDisbursementSummary.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop < header.Length + 1; iLoop++)
{
if (grdDisbursementSummary.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdDisbursementSummary.Columns[iLoop].HeaderText.Replace("<br/>", ""));
if (grdDisbursementSummary.Columns[iLoop].HeaderText == "Target ($M)")
{
grdDisbursementSummary.Columns[iLoop].HeaderText = "Target ($M)";
}
if (grdDisbursementSummary.Columns[iLoop].HeaderText == "Actual ($M)")
{
grdDisbursementSummary.Columns[iLoop].HeaderText = "Actual ($M)";
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "Tar":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "act":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align:right";
break;
case "percentage":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align:right";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Disbursment By sector <br/><span style='padding: 0 80px'> "
+ (drpFromQuarter.SelectedIndex == 0 ? "" : drpFromQuarter.SelectedItem.ToString() + " To ")
+
(drplstQuarter.SelectedIndex == 0 ? "" : " " + drplstQuarter.SelectedItem.ToString()) + " " +
(drplstQuarter.SelectedIndex == 0 ? "" : drpFromYear.SelectedItem.ToString()) + "</span>";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
this.bindGrid();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("CFDRelationID"))
{
dt.Columns.Remove("CFDRelationID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
if (drpConsultant.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Consultant Name";
testFlag.value = drpConsultant.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpFirmName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Firm Name";
testFlag.value = drpFirmName.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpPackageName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Package Name";
testFlag.value = drpPackageName.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpLoanNumber.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Loan Number";
testFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsLoanNumber",
"vsPackageNumber",
"vsFirmName",
"vsDesignationName",
"vsFirstName"
};
string[] datacolumn = new string[grdCFD.Columns.Count - 3];
int counter = 0;
for (int i = 1; i <= header.Length + 1; i++)
{
if (grdCFD.Columns[i].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdCFD.Columns[i].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
clsPrint.TableName = "Firm valuati";
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Consultant To Firm";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgBtnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
string[] header = new string[]
{
"Loan",
"vsAgencyName",
"vsState",
"vsDocCatName",
"cAmount",
"CumDisburse",
"dtApprovalDate",
"dtSigningDate",
"dtEffectivenessDate",
"dtClosingDate",
"dtRevisedClosingDate"
};
string[] datacolumn = new string[grdLoanDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdLoanDetails.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdLoanDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
if (grdLoanDetails.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Approval") ||
grdLoanDetails.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Signing") ||
grdLoanDetails.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Effectiveness") ||
grdLoanDetails.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("OrgClosing") ||
grdLoanDetails.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("RevClosing")
)
{
//set the Header Name for Group
clsPrint.headerGroup = true;
}
//set the Header Size
clsPrint.mGroupSize = "5";
//set the Header Name for Group
clsPrint.mGroupHeadName = "Date";
switch (clsPrint.ColumnName)
{
case "Loan":
clsPrint.ItemStyle = "text-align: Left;";
break;
case "vsAgencyName":
clsPrint.ItemStyle = "text-align: Left; Width:400px;";
break;
case "cAmount":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: Right";
break;
case "CumDisburse":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: Right";
break;
case "dtApprovalDate":
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtSigningDate":
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtEffectivenessDate":
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtClosingDate":
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtRevisedClosingDate":
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
string abbr = "<b>Abbrivation Used:</b><i>Org: Orignal, Rev: Revised, Cont Awd: Contract Award,</i>";
string footer = "<i style='font-size:xx-small'><b>" + abbr + " </b></i><br/>";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;'";
excel.FlagValues = flag;
excel.TableHeader = "Loan Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLStringSubtotal(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgButtonPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (dt.Columns.Contains("iDisbursementID"))
{
dt.Columns.Remove("iDisbursementID");
}
Print printObj = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2011";
flag.Add(testFlag);
Flags testFlag1 = new Flags();
testFlag1.key = "Amount";
testFlag1.value = " in USD";
flag.Add(testFlag1);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpAgency.SelectedIndex > 0)
{
Flags agencyFlag = new Flags();
agencyFlag.key = "<br/> Agency ";
agencyFlag.value = drpAgency.SelectedItem.Text;
flag.Add(agencyFlag);
}
if (drpState.SelectedIndex > 0)
{
Flags stateFlag = new Flags();
stateFlag.key = "<br/>State ";
stateFlag.value = drpState.SelectedItem.Text;
flag.Add(stateFlag);
}
if (drpYear.SelectedIndex > 0)
{
Flags yearsFlag = new Flags();
yearsFlag.key = "<br/>Year ";
yearsFlag.value = drpYear.SelectedItem.Text;
flag.Add(yearsFlag);
}
string[] datacolumn = new string[grdDisbursement.Columns.Count - 2];
string[] headers =
{
"vsLoanNumber",
"iYear",
"vsAgencyName",
"State",
"DocCatName",
"T1",
"A1",
"T2",
"A2",
"T3",
"A3",
"T4",
"A4",
"iTotalTargetDisbursement",
"iTotalActualDisbursement"
};
for (int i = 0; i < grdDisbursement.Columns.Count - 2; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = headers[i];
clsPrint.Caption = grdDisbursement.Columns[i + 1].HeaderText;
if (grdDisbursement.Columns[i + 1].HeaderText.Replace("</br>", "").ToString().Equals("Target") ||
grdDisbursement.Columns[i + 1].HeaderText.Replace("</br>", "").ToString().Equals("Actual")
)
{
clsPrint.headerGroup = true;
clsPrint.headerGroupTwo = true;
clsPrint.headerGroupThree = true;
clsPrint.headerGroupFour = true;
clsPrint.headerGroupFive = true;
}
clsPrint.mGroupSize = "2";
clsPrint.mGroupSizeTwo = "2";
clsPrint.mGroupSizeThree = "2";
clsPrint.mGroupSizeFour = "2";
clsPrint.mGroupSizeFive = "2";
switch (drpCalFinJun.SelectedValue)
{
case "1":
clsPrint.mGroupHeadName = "Jan-Mar " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameTwo = "Apr-Jun " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameThree = "July-Sep " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameFour = "Oct-Dec " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameFive = "Total";
break;
case "2":
clsPrint.mGroupHeadName = "Apr-Jun " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameTwo = "July-Sep " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameThree = "Oct-Dec " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameFour = "Jan-Mar " + (drpYear.SelectedIndex != 0 ? (int.Parse(drpYear.SelectedItem.Text) + 1).ToString() : "");
clsPrint.mGroupHeadNameFive = "Total";
break;
case "3":
clsPrint.mGroupHeadName = "July-Sep " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameTwo = "Oct-Dec " + (drpYear.SelectedIndex != 0 ? drpYear.SelectedItem.Text : "");
clsPrint.mGroupHeadNameThree = "Jan-Mar " + (drpYear.SelectedIndex != 0 ? (int.Parse(drpYear.SelectedItem.Text) + 1).ToString() : "");
clsPrint.mGroupHeadNameFour = "Apr-Jun " + (drpYear.SelectedIndex != 0 ? (int.Parse(drpYear.SelectedItem.Text) + 1).ToString() : "");
clsPrint.mGroupHeadNameFive = "Total ";
break;
}
switch (clsPrint.ColumnName)
{
case "iYear":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ1Target":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ1Actual":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ2Target":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ2Actual":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ3Target":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ3Actual":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ4Target":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iQ4Actual":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: right";
break;
case "iTotalTargetDisbursement":
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Sub Total ";
clsPrint.Summarize = true;
break;
case "iTotalActualDisbursement":
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Sub Total ";
clsPrint.Summarize = true;
break;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
}
printObj.TableStyle = "style:'width:100%;font-size:10pt;'";
printObj.FlagValues = flag;
printObj.TableHeader = "Disbursement Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)printObj.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
string[] header = new string[]
{
"Loan",
"DocCategory",
"Score",
"iLastFlag"
};
string[] datacolumn = new string[grdProjectPerformanceGroupBSummary.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupBSummary.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", ""));
if (grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Flag") || grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Last Flag"))
{
clsPrint.FlagColumnName = true;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
if (grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Cont.Awd") ||
grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Disb")
)
{
//set the Header Name for Group
clsPrint.headerGroup = true;
}
//set the Header Size
clsPrint.mGroupSize = "2";
//set the Header Name for Group
clsPrint.mGroupHeadName = "Projection";
switch (clsPrint.ColumnName)
{
case "Score":
clsPrint.Caption = ((Label)(grdProjectPerformanceGroupBSummary.HeaderRow.FindControl("lblHeader"))).Text;
clsPrint.ItemStyle = "text-align: center;";
break;
case "iLastFlag":
clsPrint.Caption = ((Label)(grdProjectPerformanceGroupBSummary.HeaderRow.FindControl("lbllastHeader"))).Text;
clsPrint.ItemStyle = "text-align: center;";
break;
}
objPrint.Add(clsPrint);
counter++;
}
if ((drpFromQuarter.SelectedIndex == 1) && (drpFromYear.SelectedIndex == 1))
{
for (int i = 0; i < grdProjectPerformanceGroupBSummary.Rows.Count; i++)
{
grdProjectPerformanceGroupBSummary.Columns[4].Visible = false;
}
}
else
{
grdProjectPerformanceGroupBSummary.Columns[4].Visible = true;
}
}
//string abbr = "<b>Abbrivation Used:</b> <i>Completion Delay - Compl Dly, Cont Awd- Contract Award, Disbursment - Disb, Audited Project Account - Aud Prj Acc </i>";
string footer = "<i style='font-size:xx-small'><b><img height='20px' width='20px' src='../Images/Icons/green.png'/>Green Tick Mark shows Range(0-3), <img height='20px' width='20px' src='../Images/Icons/yellow.png'/>Yellow Exclamation shows Range(4-7), <img height='20px' width='20px' src='../Images/Icons/Red.png'/>Red Hyphen Shows Range(>= 8)</b><i><br/>";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Performance of effective Loans <br/><span style='padding: 0 80px'> "
+ (drplstQuarter.SelectedIndex.ToString() == "1" ? " Mar To" :
drplstQuarter.SelectedIndex.ToString() == "2" ? " June To" :
drplstQuarter.SelectedIndex.ToString() == "3" ? " Sep To" :
drplstQuarter.SelectedIndex.ToString() == "4" ? " Dec To" : "")
+ (drpFromQuarter.SelectedIndex.ToString() == "1" ? "Mar " + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "2" ? " June " + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "3" ? " Sep " + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "4" ? " Dec " + drpFromYear.SelectedItem.Text : "") + "</span><br/>";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgbtnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
string[] header = new string[]
{
"vsAAANumber",
"vsAAAName",
"vsAgencyName",
"vsDocCatFAName",
"vsDocCatName",
"vsDEAFileNo",
"cAmount",
"NegotiationDate",
"ApprovalDate",
"SigningDate",
"dtClosingDate",
"dtRevisedClosingDate"
};
string[] datacolumn = new string[grdTaDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdTaDetails.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdTaDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "cAmount":
clsPrint.Format = "{0:0.0}";
clsPrint.ItemStyle = "text-align: Right";
break;
case "SigningDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "ApprovalDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "NegotiationDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtClosingDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtRevisedClosingDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
string abbr = ""; //"<b>Abbrivation Used:</b><i>Org: Orignal, Rev: Revised, Cont Awd: Contract Award,</i>";
string footer = "<i style='font-size:xx-small'><b>" + abbr + " </b></i><br/>";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;'";
excel.FlagValues = flag;
excel.TableHeader = "AAA Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint, "WB");
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
DataTable dtTemp = dt;
if (dtTemp.Columns.Contains("iPerformanceFlagsAID"))
{
dtTemp.Columns.Remove("iPerformanceFlagsAID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2011";
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpSector.SelectedIndex > 0)
{
Flags sectorFlag = new Flags();
sectorFlag.key = "<br/>Sector ";
sectorFlag.value = drpSector.SelectedItem.Text;
flag.Add(sectorFlag);
}
string[] header = new string[]
{
"vsLoanNumber",
"DocCategory",
"iAppFCount",
"iLastFlag"
};
string[] datacolumn = new string[grdProjectPerformanceGroupA.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupA.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectPerformanceGroupA.Columns[iLoop].HeaderText.Replace("<br />", ""));
if (grdProjectPerformanceGroupA.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Flag") || grdProjectPerformanceGroupA.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Last Flag"))
{
clsPrint.FlagColumnName = true;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
if (grdProjectPerformanceGroupA.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Sign") ||
grdProjectPerformanceGroupA.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Eff") ||
grdProjectPerformanceGroupA.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Est. PMU")
)
{
clsPrint.headerGroup = true;
}
clsPrint.mGroupSize = "3";
clsPrint.mGroupHeadName = "Approval To";
switch (clsPrint.ColumnName)
{
case "vsLoanNumber":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Left;width: 350px;";
break;
case "StateName":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Left;width: 66px;";
break;
case "AgencyName":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Left;width: 350px;";
break;
case "DocCategory":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Left;width: 66px;";
break;
case "iAppSign":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Right;";
break;
case "iAppEfft":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Right;";
break;
case "iAppPMU":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Right;";
break;
case "iAppFCount":
clsPrint.Caption = ((Label)(grdProjectPerformanceGroupA.HeaderRow.FindControl("lblHeader"))).Text;
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;";
break;
case "iLastFlag":
clsPrint.Caption = ((Label)(grdProjectPerformanceGroupA.HeaderRow.FindControl("lbllastHeader"))).Text;
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;";
break;
}
objPrint.Add(clsPrint);
counter++;
}
if ((drpFromMonth.SelectedIndex == 1) && (drpFromYear.SelectedIndex == 1))
{
for (int i = 0; i < grdProjectPerformanceGroupA.Rows.Count; i++)
{
grdProjectPerformanceGroupA.Columns[4].Visible = false;
}
}
else
{
grdProjectPerformanceGroupA.Columns[4].Visible = true;
}
}
string footer = "<i style='font-size:xx-small'><b><img height='20px' width='20px' src='../Images/Icons/green.png'/>Green Tick Mark shows Range(0-3), <img height='20px' width='20px' src='../Images/Icons/yellow.png'/>Yellow Exclamation shows Range(4-7), <img height='20px' width='20px' src='../Images/Icons/Red.png'/>Red Hyphen Shows Range(>= 8)</b><i><br/> ";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Loan Not Yet Effective <br/><span style='padding: 0 80px'> "
+ (drplstMonth.SelectedIndex == 0 ? "" : drplstMonth.SelectedItem.ToString() + " To ")
+
(drpFromMonth.SelectedIndex == 0 ? "" : " " + drpFromMonth.SelectedItem.ToString()) + " " +
(drpFromMonth.SelectedIndex == 0 ? "" : drpFromYear.SelectedItem.ToString()) + "</span>";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dtTemp, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
string[] header = new string[]
{
"vsLoanNumber",
"vsLoanName",
"Sector",
"dtApprovalDate",
"dtClosingDate",
"dtRevisedClosingDate",
};
string[] datacolumn = new string[grdProjectPerformanceGroupCDetail.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupCDetail.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br />", ""));
//if (grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Flag") || grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Last Flag"))
// clsPrint.FlagColumnName = true;
//if (grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Approval")
// || grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Closing")
// || grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Revised Closing")
// )
//{
// clsPrint.headerGroup = true;
//}
//clsPrint.mGroupSize = "5";
//clsPrint.mGroupHeadName = "Date";
//clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
//clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "vsLoanName":
clsPrint.ItemStyle = "text-align: Left;width: 400px;";
break;
case "dtApprovalDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "dtSigningDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "dtEffectivenessDate":
clsPrint.Format = "{0:dd MMM yyyy}";
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "dtClosingDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "'text-align: center;width: 66px;";
break;
case "dtRevisedClosingDate":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "camount":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "cCancelAmount":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
string abbr = ""; //"<b>Abbrivation Used:</b><i> Rev: Revised,Mths: Months, C-M: Current to Mid,Rt: Rate, Adtnl: Additional, Impl: Implementation</i>";
string footer = ""; //"<i style='font-size:xx-small'><b></b><i>" + abbr + "<br/>";
excel.TableStyle = "style:'width:100%;'";
excel.FlagValues = flag;
// excel.TableHeader = "Completion Delay";
excel.TableHeader = "Loan Under Financial Closure ";
excel.TableFooter = footer;
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (ddlLoanNo.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Loan No";
testFlag.value = ddlLoanNo.SelectedItem.Text;
flag.Add(testFlag);
}
if (txtAdvertisementDateFrom.Text != "")
{
testFlag = new Flags();
testFlag.key = "Advertisement Date (From)";
testFlag.value = txtAdvertisementDateFrom.Text;
flag.Add(testFlag);
}
if (txtEstimatedAmountFrom.Text != "")
{
testFlag = new Flags();
testFlag.key = "Advertisement Date (From)";
testFlag.value = txtEstimatedAmountFrom.Text;
flag.Add(testFlag);
}
if (txtEstimatedAmountTo.Text != "")
{
testFlag = new Flags();
testFlag.key = "Advertisement Date (To)";
testFlag.value = txtEstimatedAmountTo.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"LoanNumber",
"vsAgencyName",
"vsProjectName",
"VendorGroupName",
"dtAdvertisement",
"dtSubmission",
"iAmount",
"dtAdvertisementSent",
"DocSentStatus"
};
try
{
string[] datacolumn = new string[grdAdvertisementDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdAdvertisementDetails.Columns[iLoop].Visible != false)
{
if (grdAdvertisementDetails.Columns[iLoop].HeaderText.Equals("Send Email"))
{
continue;
}
clsPrint = new clsPrintObject(header[counter], grdAdvertisementDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "dtAdvertisement":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: Center;width: 53px";
break;
case "iAmount":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;width: 53px";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Advertisement Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2011";
flag.Add(testFlag);
Flags testFlag1 = new Flags();
testFlag1.key = "Amount";
testFlag1.value = " in USD";
flag.Add(testFlag1);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpAgency.SelectedIndex > 0)
{
Flags agencyFlag = new Flags();
agencyFlag.key = "<br/> Agency ";
agencyFlag.value = drpAgency.SelectedItem.Text;
flag.Add(agencyFlag);
}
if (drpState.SelectedIndex > 0)
{
Flags stateFlag = new Flags();
stateFlag.key = "<br/>State ";
stateFlag.value = drpState.SelectedItem.Text;
flag.Add(stateFlag);
}
if (drpYear.SelectedIndex > 0)
{
Flags yearsFlag = new Flags();
yearsFlag.key = "<br/>Year ";
yearsFlag.value = drpYear.SelectedItem.Text;
flag.Add(yearsFlag);
}
string[] header = new string[]
{
"vsLoanNumber",
"vsAgencyName",
"vsState",
"vsDocCatName",
"iYear",
"ContractAwardMonthwiseValues",
"dtAuditRepDate"
};
string[] datacolumn = new string[grdContractAward.Columns.Count - 1];
int j = 0;
for (int i = 0; i < grdContractAward.Columns.Count - 2; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = header[j];
clsPrint.Caption = grdContractAward.Columns[i + 1].HeaderText;
switch (clsPrint.ColumnName)
{
case "iYear":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: right'";
break;
case "dtAuditRepDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: center'";
break;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
j++;
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
if (flag != null)
{
excel.FlagValues = flag;
}
excel.TableHeader = "Contract Award Details By Month";
DataTable dtPrint = Session[clsConstant.SESS_TABLE] as DataTable;
if (dtPrint != null)
{
if (!dtPrint.Columns.Contains("ContractAwardMonthwiseValues"))
{
dtPrint.Columns.Add(new DataColumn("ContractAwardMonthwiseValues"));
}
foreach (DataRow dr in dtPrint.Rows)
{
dr["ContractAwardMonthwiseValues"] =
dr["iQ1Target"].ToString() + "*" +
dr["iQ2Target"].ToString() + "*" +
dr["iQ3Target"].ToString() + "*" +
dr["iQ4Target"].ToString() + "*" +
dr["iTotalTargetAward"].ToString() + "*" +
//til here
dr["iAMonth1"].ToString() + "*" +
dr["iAMonth2"].ToString() + "*" +
dr["iAMonth3"].ToString() + "*" +
dr["iAMonth4"].ToString() + "*" +
dr["iAMonth5"].ToString() + "*" +
dr["iAMonth6"].ToString() + "*" +
dr["iAMonth7"].ToString() + "*" +
dr["iAMonth8"].ToString() + "*" +
dr["iAMonth9"].ToString() + "*" +
dr["iAMonth10"].ToString() + "*" +
dr["iAMonth11"].ToString() + "*" +
dr["iAMonth12"].ToString() + "*" +
dr["iTotalActualAward"].ToString();
}
}
Session[clsConstant.SESS_TABLE] = dtPrint;
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dtPrint, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgPrint_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("iNominationID"))
{
dt.Columns.Remove("iNominationID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (txtTopic.Text != "")
{
testFlag = new Flags();
testFlag.key = "Topic";
testFlag.value = txtTopic.Text;
flag.Add(testFlag);
}
if (drpSector.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Sector";
testFlag.value = drpSector.SelectedItem.Text;
flag.Add(testFlag);
}
if (txtFromDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "From Date";
testFlag.value = txtFromDate.Text;
flag.Add(testFlag);
}
if (txtToDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "From Date";
testFlag.value = txtFromDate.Text;
flag.Add(testFlag);
}
if (txtVenue.Text != "")
{
testFlag = new Flags();
testFlag.key = "Venue";
testFlag.value = txtVenue.Text;
flag.Add(testFlag);
}
if (drpTargetAudience.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Target Audience";
testFlag.value = drpTargetAudience.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpInvite.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Invite By";
testFlag.value = drpInvite.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpNationalInternational.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "National / International";
testFlag.value = drpNationalInternational.SelectedItem.Text;
flag.Add(testFlag);
}
if (txtLstDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "Last Date of Nomination";
testFlag.value = txtLstDate.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsTopic",
"Sector",
"dtFromDate",
"dtToDate",
"vsVenue",
"vsTargetAudienceName",
"vsInviteType",
"iSeats",
"vsName",
"dtLastDate",
"vsFile"
};
try
{
string[] datacolumn = new string[grdNominationManagementSystem.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdNominationManagementSystem.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdNominationManagementSystem.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "dtFromDate":
clsPrint.Format = "{0:d}";
break;
case "dtToDate":
clsPrint.Format = "{0:d}";
break;
case "dtLastDate":
clsPrint.Format = "{0:d}";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Nomination Management Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("iConsEvalDetailID"))
{
dt.Columns.Remove("iConsEvalDetailID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (drpPackageName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Package Name";
testFlag.value = drpPackageName.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpFirmName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Firm Name";
testFlag.value = drpFirmName.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpConsultantName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Consultant Name";
testFlag.value = drpConsultantName.SelectedItem.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsAgencyName",
"vsFirstName",
"vsPackageName",
"vsLoannumber",
"vsFirmName",
"vsConsCompaliance",
"vsConsOutput",
"vsPersonalStability",
"vsConsAvailability",
"vsConsultantRating",
"vsComments",
"vsFinal",
"dtEvaluationDate"
};
string[] datacolumn = new string[grdConsEvaluation.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdConsEvaluation.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdConsEvaluation.Columns[iLoop].HeaderText.Replace("<br/>", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
#region Mearge Column
if (grdConsEvaluation.Columns[iLoop].HeaderText.Replace("</br>", "").ToString().Equals("Compliance Work Programme") ||
grdConsEvaluation.Columns[iLoop].HeaderText.Replace("</br>", "").ToString().Equals("Quality OutPut") ||
grdConsEvaluation.Columns[iLoop].HeaderText.Replace("</br>", "").ToString().Equals("Personal Stability") ||
grdConsEvaluation.Columns[iLoop].HeaderText.Replace("</br>", "").ToString().Equals("Timely Availabilty") ||
grdConsEvaluation.Columns[iLoop].HeaderText.Replace("</br>", "").ToString().Equals("Average Rating")
)
{
//set the Header Name for Group
clsPrint.headerGroup = true;
}
//set the Header Size
clsPrint.mGroupSize = "5";
//set the Header Name for Group
clsPrint.mGroupHeadName = "Consultant";
#endregion
switch (clsPrint.ColumnName)
{
case "dtEvaluationDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: center'";
break;
case "vsLoannumber":
clsPrint.ItemStyle = "style='text-align: Right'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Consultant Evaluation";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("ifirmID"))
{
dt.Columns.Remove("ifirmID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (drpFirmName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Firm name";
testFlag.value = drpFirmName.SelectedItem.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsFirmName",
"vsDocCatName",
"vsContactPerson",
"vsEmail",
"vsTelephone",
"vsCellphone",
"vsPostalcode",
"vsAdress"
};
try
{
string[] datacolumn = new string[grdFirmDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdFirmDetails.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdFirmDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "vsFirmName":
clsPrint.ItemStyle = "style='text-align: left;width: 350px'";
break;
case "vsTelephone":
clsPrint.ItemStyle = "style='text-align: Right;width: 150px'";
break;
case "vsCellphone":
clsPrint.ItemStyle = "style='text-align: Right;width: 150px'";
break;
case "vsPostalcode":
clsPrint.ItemStyle = "style='text-align: Right;width: 50px'";
break;
case "vsAdress":
clsPrint.ItemStyle = "style='text-align: left;width: 350px'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Firm Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2011";
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpAgency.SelectedIndex > 0)
{
Flags agencyFlag = new Flags();
agencyFlag.key = "<br/> Agency ";
agencyFlag.value = drpAgency.SelectedItem.Text;
flag.Add(agencyFlag);
}
if (drpState.SelectedIndex > 0)
{
Flags stateFlag = new Flags();
stateFlag.key = "<br/>State ";
stateFlag.value = drpState.SelectedItem.Text;
flag.Add(stateFlag);
}
if (drpSector.SelectedIndex > 0)
{
Flags sectorFlag = new Flags();
sectorFlag.key = "<br/>Sector ";
sectorFlag.value = drpSector.SelectedItem.Text;
flag.Add(sectorFlag);
}
if (drpOnlyOpen.SelectedIndex > 0)
{
Flags onlyOpenFlag = new Flags();
onlyOpenFlag.key = "<br/>Only Open ";
onlyOpenFlag.value = drpOnlyOpen.SelectedItem.Text;
flag.Add(onlyOpenFlag);
}
string[] datacolumn = new string[grdPeformaceLoan.Columns.Count - 1];
for (int i = 1; i < grdPeformaceLoan.Columns.Count - 1; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = grdPeformaceLoan.Columns[i].HeaderText;
if (grdPeformaceLoan.Columns[i].HeaderText.Replace("<br/>", "").ToString().Equals("Approval") ||
grdPeformaceLoan.Columns[i].HeaderText.Replace("<br/>", "").ToString().Equals("Signing") ||
grdPeformaceLoan.Columns[i].HeaderText.Replace("<br/>", "").ToString().Equals("Effectivness") ||
grdPeformaceLoan.Columns[i].HeaderText.Replace("<br/>", "").ToString().Equals("Closing") ||
grdPeformaceLoan.Columns[i].HeaderText.Replace("<br/>", "").ToString().Equals("Revised Closing")
)
{
clsPrint.headerGroup = true;
}
clsPrint.mGroupSize = "7";
clsPrint.mGroupHeadName = "Date";
switch (clsPrint.ColumnName)
{
case "vsLoanNumber":
clsPrint.ItemStyle = "text-align:Left; Width:400px;";
break;
case "vsAgencyName":
clsPrint.ItemStyle = "text-align: Left; Width:400px;";
break;
case "cAmount":
clsPrint.ItemStyle = "text-align: Right";
break;
case "CumDisburse":
clsPrint.ItemStyle = "text-align: Right";
break;
case "dtApprovalDate":
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtSigningDate":
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtEffectivenessDate":
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtClosingDate":
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
case "dtRevisedClosingDate":
clsPrint.ItemStyle = "text-align: center;width: 150px;";
break;
}
objPrint.Add(clsPrint);
}
string abbr = "<b>Abbrivation Used:</b><i>Org: Orignal, Rev: Revised, Cont Awd: Contract Award,</i>";
string footer = "<i style='font-size:xx-small'><b>" + abbr + " </b></i><br/>";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Performance Loan Detail";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLStringSubtotal(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2011";
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpSector.SelectedIndex > 0)
{
Flags sectorFlag = new Flags();
sectorFlag.key = "<br/>Sector ";
sectorFlag.value = drpSector.SelectedItem.Text;
flag.Add(sectorFlag);
}
string[] header = new string[]
{
"LnName",
"orgScore",
"iYear",
"iQuarter",
"iNewFlag",
"vsReason",
"dtModDate"
};
string[] datacolumn = new string[grdOverrideGroupB.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdOverrideGroupB.Columns[iLoop].HeaderText != "Select Flag")
{
clsPrint = new clsPrintObject(header[counter], grdOverrideGroupB.Columns[iLoop].HeaderText.Replace("<br />", ""));
if (grdOverrideGroupB.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Orginal Flag") ||
grdOverrideGroupB.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Override Flag"))
{
clsPrint.FlagColumnName = true;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "LnName":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 350px;'";
break;
case "orgScore":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 66px;'";
break;
case "iYear":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 66px;'";
break;
case "iQuarter":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 66px;'";
break;
case "iNewFlag":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 66px;'";
break;
case "vsReason":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 350px;'";
break;
case "dtModDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: center;width: 150px;'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
string abbr = "<b>Abbrivation Used:</b> <i>Quarter: Q1,Q2,Q3 & Q4, Quarter - Qutr </i>";
string footer = "<i style='font-size:xx-small'><b><img height='20px' width='20px' src='../Images/Icons/green.png'/>Green Tick Mark shows Range(0-3), <img height='20px' width='20px' src='../Images/Icons/yellow.png'/>Yellow Exclamation shows Range(4-7), <img height='20px' width='20px' src='../Images/Icons/Red.png'/>Red Hyphen Shows Range(> 8)</b><i><br/> " + abbr + "";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;'";
excel.FlagValues = flag;
// excel.TableHeader = "Override Group-B";
excel.TableHeader = "Override Group-B Report As on "
+ (drpFromQuarter.SelectedIndex.ToString() == "1" ? "31st Mar" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "2" ? "30 June" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "3" ? "30 Sep" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "4" ? "31 Dec" + drpFromYear.SelectedItem.Text : "");
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgButtonPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2010";
flag.Add(testFlag);
if (drpAgencyName.SelectedIndex > 0)
{
Flags agencyFlag = new Flags();
agencyFlag.key = "<br/>Agency ";
agencyFlag.value = drpAgencyName.SelectedItem.Text;
flag.Add(agencyFlag);
}
if (txtFirstName.Text != string.Empty)
{
Flags firstNameFlag = new Flags();
firstNameFlag.key = "<br/>First Name ";
firstNameFlag.value = txtFirstName.Text;
flag.Add(firstNameFlag);
}
if (txtLastName.Text != string.Empty)
{
Flags lastNameFlag = new Flags();
lastNameFlag.key = "<br/>Last Name ";
lastNameFlag.value = txtLastName.Text;
flag.Add(lastNameFlag);
}
if (txtEmail.Text != string.Empty)
{
Flags emailFlag = new Flags();
emailFlag.key = "<br/>Email-ID ";
emailFlag.value = txtEmail.Text;
flag.Add(emailFlag);
}
string[] header = new string[]
{
"vsFirstName",
"vsLastName",
"vsUserName",
"vsDesignationName",
"vsTelephone",
"vsCellPhone",
"vsEmailID",
"vsAgencyName",
"vsSkypeID",
"bUserActiive",
"iParentUserID",
"bSuperUser",
};
string[] datacolumn = new string[grdUser.Columns.Count - 2];
int counter = 0;
for (int iLoop = 2; iLoop <= header.Length; iLoop++)
{
if (grdUser.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdUser.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "People Finder Detail";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
ObjUtility = new Utility();
//ObjUtility.Print(divFirmEval);
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("Final"))
{
dt.Columns.Add("Final");
}
if (!dt.Columns.Contains("iFirmEvalID"))
{
dt.Columns.Remove("iFirmEvalID");
}
if (!dt.Columns.Contains("iFirmID"))
{
dt.Columns.Remove("iFirmID");
}
if (!dt.Columns.Contains("iAgencyID"))
{
dt.Columns.Remove("iAgencyID");
}
if (!dt.Columns.Contains("iLoanID"))
{
dt.Columns.Remove("iLoanID");
}
if (!dt.Columns.Contains("iPackageID"))
{
dt.Columns.Remove("iPackageID");
}
for (int iLoop = 0; iLoop < dt.Rows.Count; iLoop++)
{
if (dt.Rows[iLoop][15].ToString() == "True")
{
dt.Rows[iLoop]["Final"] = "Yes";
}
else if (dt.Rows[iLoop][15].ToString() == "False")
{
dt.Rows[iLoop]["Final"] = "No";
}
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
if (drpAgency.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Agency Name";
testFlag.value = drpAgency.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpFirmName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Firm Name";
testFlag.value = drpFirmName.SelectedItem.Text;
flag.Add(testFlag);
}
if (txtFromDate.Text != null)
{
testFlag = new Flags();
testFlag.key = "From Date";
testFlag.value = txtToDate.Text;
flag.Add(testFlag);
}
if (txtToDate.Text != null)
{
testFlag = new Flags();
testFlag.key = "To Date";
testFlag.value = txtToDate.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsAgencyName",
"vsFirmName",
"vsFirmtype",
"dtEvalDate",
"vsCWWP",
"vsQOO",
"vsPS",
"vsTA",
"vsAR",
"vsComments",
"Final"
};
string[] datacolumn = new string[grdFirmEvaluation.Columns.Count - 4];
int counter = 0;
for (int i = 1; i <= header.Length + 2; i++)
{
if (grdFirmEvaluation.Columns[i].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdFirmEvaluation.Columns[i].HeaderText.Replace("<br />", ""));
//clsPrint.ColumnName = dt.Columns[i].ColumnName;
//clsPrint.Caption = grdFirmEvaluation.Columns[i].HeaderText;
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
clsPrint.TableName = "Firm valuation";
#region Mearge Column
if (grdFirmEvaluation.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Compliance Work Programme") ||
grdFirmEvaluation.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Quality OutPut") ||
grdFirmEvaluation.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Personal Stability") ||
grdFirmEvaluation.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Timely Availability") ||
grdFirmEvaluation.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Average Rating")
)
{
//set the Header Name for Group
clsPrint.headerGroup = true;
}
//set the Header Size
clsPrint.mGroupSize = "5";
//set the Header Name for Group
clsPrint.mGroupHeadName = "Firm";
#endregion
switch (clsPrint.ColumnName)
{
case "dtEvalDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: center'";
break;
//case "btFinal":
// //if (clsPrint.FlagColumnName.ToString() == "False")
// // clsPrint.FlagColumnName.ToString() = "No";
// //clsPrint.Format = "{0:on;0;OFF}";
// //clsPrint.ItemStyle = "style='text-align: center'";
// //ToYesNoString(clsPrint.FlagColumnName);
// var truth = string.Format("{0:Yes;0;No}", clsPrint.FlagColumnName.GetHashCode());
// if (dt.Rows[i][15].ToString() == "True")
// {
// grdFirmEvaluation.Rows[i].Cells[13].Text = truth;
// }
// else if (dt.Rows[i][15].ToString() == "False")
// {
// grdFirmEvaluation.Rows[i].Cells[13].Text = truth;
// }
// break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Firm Evaluation";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgPrint_Click(object sender, ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("N / S / A"))
{
dt.Columns.Add("N / S / A");
}
if (!dt.Columns.Contains("AAt"))
{
dt.Columns.Add("AAt");
}
for (int iLoop = 0; iLoop < dt.Rows.Count; iLoop++)
{
if (dt.Rows[iLoop]["bSelected"].ToString() == "" || dt.Rows[iLoop]["bSelected"].ToString() == "False" &&
dt.Rows[iLoop]["bApproved"].ToString() == "False"
)
{
dt.Rows[iLoop]["N / S / A"] = "N";
}
else
if (dt.Rows[iLoop]["bSelected"].ToString() == "True" && dt.Rows[iLoop]["bApproved"].ToString() == "False")
{
dt.Rows[iLoop]["N / S / A"] = "S";
}
else
if (dt.Rows[iLoop]["bApproved"].ToString() == "True")
{
dt.Rows[iLoop]["N / S / A"] = "A";
}
if (dt.Rows[iLoop]["bIsActualAttended"].ToString() == "1")
{
dt.Rows[iLoop]["AAt"] = "Yes";
}
else
if (dt.Rows[iLoop]["bIsActualAttended"].ToString() == "0")
{
dt.Rows[iLoop]["AAt"] = "No";
}
}
if (dt.Columns.Contains("iNominationID"))
{
dt.Columns.Remove("iNominationID");
}
if (dt.Columns.Contains("vsJustification"))
{
dt.Columns.Remove("vsJustification");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (drpAgency.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "File Nomination";
testFlag.value = drpAgency.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpDesignation.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Designation:";
testFlag.value = drpDesignation.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpLoanNumber.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Loan Number:";
testFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(testFlag);
}
if (txtEmail.Text != "")
{
testFlag = new Flags();
testFlag.key = "Email: ";
testFlag.value = txtEmail.Text;
flag.Add(testFlag);
}
if (drpRefrenceID.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Reference ID: ";
testFlag.value = drpRefrenceID.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpPartName.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Name of Participant: ";
testFlag.value = drpPartName.SelectedItem.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"iNominatedUser",
"Loan",
"Agency",
"Name",
"vsCellphone",
"vsEmail",
"vsFax",
"vsDesignationID",
"vsTopic",
"dtFromDate",
"dtToDate",
"N / S / A",
"AAt"
};
try
{
string[] datacolumn = new string[grdUserlist.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdUserlist.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], header[counter] != "N / S / A" ? grdUserlist.Columns[iLoop].HeaderText.Replace("<br />", "") : "N / S / A");
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "iNominatedUser":
clsPrint.ItemStyle = "style='text-align: Right;'";
break;
case "Loan":
clsPrint.ItemStyle = "style='text-align: left; width: 200px'";
break;
case "Agency":
clsPrint.ItemStyle = "style='text-align: left; width: 200px'";
break;
case "Name":
clsPrint.ItemStyle = "style='text-align: left; width: 200px'";
break;
case "vsCellphone":
clsPrint.ItemStyle = "style='text-align: Right; width: 60px'";
break;
case "vsEmail":
clsPrint.ItemStyle = "style='text-align: left; width: 60px'";
break;
case "vsFax":
clsPrint.ItemStyle = "style='text-align: Right; width: 80px'";
break;
case "vsDesignationID":
clsPrint.ItemStyle = "style='text-align: Left; width: 80px'";
break;
case "vsJustification":
clsPrint.ItemStyle = "style='text-align: Left; width: 80px'";
break;
case "vsTopic":
clsPrint.ItemStyle = "style='text-align: Left; width: 200px'";
break;
case "dtFromDate":
clsPrint.ItemStyle = "style='text-align: Center; width: 60px'";
break;
case "dtToDate":
clsPrint.ItemStyle = "style='text-align: Center; width: 60px'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableFooter = "R - Recommended, S - Selected, A - Approved";
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Participant Nomination List";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("iAgencyID"))
{
dt.Columns.Remove("iAgencyID");
}
if (!dt.Columns.Contains("iDocCatID"))
{
dt.Columns.Remove("iDocCatID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (drpProject.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Project Number";
testFlag.value = drpProject.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpAgency.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Agency Details";
testFlag.value = drpAgency.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpDocument.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Document Category Details";
testFlag.value = drpDocument.SelectedItem.Text;
flag.Add(testFlag);
}
if (txtStartDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "Start Date";
testFlag.value = txtStartDate.Text;
flag.Add(testFlag);
}
if (txtEndDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "End Date";
testFlag.value = txtEndDate.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsProjectNumber",
"vsProjectName",
"vsAgencyName",
"vsDocCatName",
"dtStartDate",
"dtEndDate",
};
try
{
string[] datacolumn = new string[grdProjectDetailsMaster.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectDetailsMaster.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectDetailsMaster.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "vsProjectNumber":
clsPrint.ItemStyle = "style='text-align: Right;'";
break;
case "vsProjectName":
clsPrint.ItemStyle = "style='text-align: Left; width: 350px;'";
break;
case "vsAgencyName":
clsPrint.ItemStyle = "style='text-align: Left; width: 350px;'";
break;
case "vsDocCatName":
clsPrint.ItemStyle = "style='text-align: Left; width: 70px;'";
break;
case "dtStartDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center; width: 66px;'";
break;
case "dtEndDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center; width: 66px;'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
string footer = "<i style='font-size:xx-small'><b>Abbreviation Used: Doc Category: Document Category</b></i><br/>";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Project Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgbtnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (txtFirstName.Text != "")
{
testFlag = new Flags();
testFlag.key = "First Name";
testFlag.value = txtFirstName.Text;
flag.Add(testFlag);
}
if (txtLastName.Text != "")
{
testFlag = new Flags();
testFlag.key = "Last Name";
testFlag.value = txtLastName.Text;
flag.Add(testFlag);
}
if (txtDateOfBirth.Text != "")
{
testFlag = new Flags();
testFlag.key = "Date Of Birth";
testFlag.value = txtDateOfBirth.Text;
flag.Add(testFlag);
}
if (txtStartDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "Start Date";
testFlag.value = txtStartDate.Text;
flag.Add(testFlag);
}
if (txtEndDate.Text != "")
{
testFlag = new Flags();
testFlag.key = "End Date";
testFlag.value = txtEndDate.Text;
flag.Add(testFlag);
}
string[] datacolumn = new string[grdConsultantDetails.Columns.Count - 1];
for (int i = 1; i < grdConsultantDetails.Columns.Count - 1; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = grdConsultantDetails.Columns[i].HeaderText;
switch (clsPrint.ColumnName)
{
case "dtDateOfBirth":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center;'";
break;
case "dtStartDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center;'";
break;
case "dtEndDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center;'";
break;
}
clsPrint.HeaderStyle = "style='font-weight:bold;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
}
excel.TableStyle = "style:'font-size:10pt;'";
if (flag != null)
{
excel.FlagValues = flag;
}
excel.TableHeader = "Consultant Detail";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags yearFlag = new Flags();
yearFlag.key = "Year";
yearFlag.value = "2011";
flag.Add(yearFlag);
Flags amountFlag = new Flags();
amountFlag.key = "Amount";
amountFlag.value = " in USD";
flag.Add(amountFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpSector.SelectedIndex > 0)
{
Flags agencyFlag = new Flags();
agencyFlag.key = "<br/> Sector ";
agencyFlag.value = drpSector.SelectedItem.Text;
flag.Add(agencyFlag);
}
if (drpYear.SelectedIndex > 0)
{
Flags yearsFlag = new Flags();
yearsFlag.key = "<br/>Year ";
yearsFlag.value = drpYear.SelectedItem.Text;
flag.Add(yearsFlag);
}
for (int i = 1; i <= grdContractAwardReport.Columns.Count - 1; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = grdContractAwardReport.Columns[i].HeaderText;
grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "");
if (grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Target") ||
grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Actual")
)
{
clsPrint.headerGroup = true;
}
if (
grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Target") ||
grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Actual")
)
{
clsPrint.headerGroupTwo = true;
}
if (grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Target") ||
grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Actual")
)
{
clsPrint.headerGroupThree = true;
}
if (grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Target")
|| grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", "").ToString().Equals("Actual")
)
{
clsPrint.headerGroupFour = true;
}
clsPrint.mGroupSize = "2";
clsPrint.mGroupSizeTwo = "2";
clsPrint.mGroupSizeThree = "2";
clsPrint.mGroupSizeFour = "2";
clsPrint.mGroupHeadName = "Quarter 1";
clsPrint.mGroupHeadNameTwo = "Quarter 2";
clsPrint.mGroupHeadNameThree = "Quarter 3";
clsPrint.mGroupHeadNameFour = "Quarter 4";
switch (clsPrint.ColumnName)
{
case "iYear":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: right'";
break;
case "iQ1Target":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ1Actual":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ2Target":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ2Actual":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ3Target":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ3Actual":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ4Target":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iQ4Actual":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iTotalTargetAward":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Total ";
clsPrint.Summarize = true;
break;
case "iTotalActualAward":
clsPrint.Format = "{0:N0}";
clsPrint.ItemStyle = "text-align: right";
clsPrint.SummaryLineCaption = "Sub Total ";
clsPrint.Summarize = true;
break;
case "PercentContractorAward":
clsPrint.Format = "{0:f2}";
clsPrint.ItemStyle = "text-align: right";
break;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Contractaward By Loan";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgPrint_Click(object sender, ImageClickEventArgs e)
{
try{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains(" iAgencyID"))
{
dt.Columns.Remove("iAgencyID");
}
if (!dt.Columns.Contains(" iStateID"))
{
dt.Columns.Remove("iStateID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (drpAgencyCode.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Project Number";
testFlag.value = drpAgencyCode.SelectedItem.Text;
flag.Add(testFlag);
}
if (drpState.SelectedIndex != 0)
{
testFlag = new Flags();
testFlag.key = "Agency Details";
testFlag.value = drpState.SelectedItem.Text;
flag.Add(testFlag);
}
string[] header = new string[]
{
"vsAgencyCode",
"vsAgencyName",
"vsAddress",
"vsPostalCode",
"vsState",
"vsTelephone",
"vsCellPhone",
"vsFax",
"vsEmail",
"vsSkypeID",
"bIsLineMinistry",
"dtStartDate",
"dtEndDate"
};
string[] datacolumn = new string[grdAgencyDetails.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdAgencyDetails.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdAgencyDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "vsAgencyName":
clsPrint.ItemStyle = "style='text-align: Left; width: 400px;'";
break;
case "vsAddress":
clsPrint.ItemStyle = "style='text-align: Left; width: 200px;word-wrap:break-word;'";
break;
case "vsPostalCode":
clsPrint.ItemStyle = "style='text-align: Right; width: 66px;'";
break;
case "vsState":
clsPrint.ItemStyle = "style='width: 70px;'";
break;
case "vsTelephone":
clsPrint.ItemStyle = "style='style='text-align: Right;width: 66px;'";
break;
case "vsCellPhone":
clsPrint.ItemStyle = "style='style='text-align: Right;width: 66px;'";
break;
case "vsFax":
clsPrint.ItemStyle = "style='style='text-align: Right;width: 66px;'";
break;
case "vsEmail":
clsPrint.ItemStyle = "style='width: 100px'";
break;
case "vsSkypeID":
clsPrint.ItemStyle = "style='width: 50px'";
break;
case "dtStartDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center;width: 66px;'";
break;
case "dtEndDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: Center;width: 66px;'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Agency Details";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgBtnPrint_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = null;
if (txtName.Text != "")
{
testFlag = new Flags();
testFlag.key = "Name";
testFlag.value = txtName.Text;
flag.Add(testFlag);
}
if (ddlAgencyName.SelectedIndex > 0)
{
testFlag = new Flags();
testFlag.key = "Agency Name";
testFlag.value = ddlAgencyName.SelectedItem.Text;
flag.Add(testFlag);
}
if (ddlDesignation.SelectedIndex > 0)
{
testFlag = new Flags();
testFlag.key = "Designaiton";
testFlag.value = ddlDesignation.SelectedItem.Text;
flag.Add(testFlag);
}
if (ddlGroupName.SelectedIndex > 0)
{
testFlag = new Flags();
testFlag.key = "Group Name";
testFlag.value = ddlGroupName.SelectedItem.Text;
flag.Add(testFlag);
}
string[] datacolumn = new string[4];
for (int i = 0; i < 4; i++)
{
clsPrint = new clsPrintObject();
clsPrint.ColumnName = dt.Columns[i].ColumnName;
clsPrint.Caption = grdEmailGroup.Columns[i + 2].HeaderText;
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
objPrint.Add(clsPrint);
}
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
excel.TableHeader = "Group Detail";
// Added by keshav on 27 feb 2014
if (((((UserDetails)Session[clsConstant.TOKEN]).EAP).ToString() == "WB"))
{
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint, "WB");
}
else
{
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
}
// Added by keshav on 27 feb 2014
// Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint); Comment by keshav on 27 Feb 2014, To dynamically add logo
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
dt.Columns["DocCategory"].SetOrdinal(10);
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
dt.Columns.Add("ScoreAlias");
foreach (DataRow row in dt.Rows)
{
row["ScoreAlias"] = row["Score"];
}
string[] header = new string[]
{
"Loan",
"DocCategory",
"Completiondelay",
"ContractAward",
"Disbursement",
"AuditedProject",
"CAtarget",
"CAActual",
"CAPercent",
"DisTarget",
"DisActual",
"DisPercent",
"Score",
"ScoreAlias",
"iLastFlag"
};
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupBSummary.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", ""));
if (grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Flag") || grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Last Flag"))
{
clsPrint.FlagColumnName = true;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
if (grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Cont.Awd") ||
grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Disb")
//|| grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Contains("Upto")
//|| grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Contains("As of")
//|| grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Contains("%")
)
{
clsPrint.headerGroup = true;
}
clsPrint.mGroupSize = "2";
//clsPrint.mGroupSizeTwo = "3";
//clsPrint.mGroupSizeThree = "3";
clsPrint.mGroupHeadName = "Projection";
//clsPrint.mGroupHeadNameTwo = "Contract Award";
//clsPrint.mGroupHeadNameThree = "Disbursement";
//if (grdProjectPerformanceGroupBSummary.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Contains("Upto"))
//{
// clsPrint.headerGroup = true;
//}
//clsPrint.mGroupSize = "3";
//clsPrint.mGroupHeadName = "Contract Award";
switch (clsPrint.ColumnName)
{
case "Completiondelay":
clsPrint.ItemStyle = "text-align: right";
break;
case "ContractAward":
clsPrint.ItemStyle = "text-align: right";
break;
case "Disbursement":
clsPrint.ItemStyle = "text-align: right";
break;
case "AuditedProject":
clsPrint.ItemStyle = "text-align: right";
break;
case "Score":
clsPrint.ItemStyle = "text-align: right";
break;
case "ScoreAlias":
clsPrint.Caption = ((Label)(grdProjectPerformanceGroupBSummary.HeaderRow.FindControl("lblHeader"))).Text;
clsPrint.ItemStyle = "text-align: center;";
break;
case "iLastFlag":
clsPrint.Caption = ((Label)(grdProjectPerformanceGroupBSummary.HeaderRow.FindControl("lbllastHeader"))).Text;
clsPrint.ItemStyle = "text-align: center;";
break;
case "CAtarget":
clsPrint.Caption = ViewState["CAupto"] != null ? "CA <br />" + ViewState["CAupto"].ToString():"";
clsPrint.ItemStyle = "text-align: center;";
break;
case "CAActual":
clsPrint.Caption = ViewState["CAas"] != null ? "CA <br />" + ViewState["CAas"].ToString() : "";
clsPrint.ItemStyle = "text-align: center;";
break;
case "DisTarget":
clsPrint.Caption = ViewState["DISupto"] != null ? "Dis <br />" + ViewState["DISupto"].ToString() : "";
clsPrint.ItemStyle = "text-align: center;";
break;
case "DisActual":
clsPrint.Caption = ViewState["DISas"] != null ? "Dis <br />" + ViewState["DISas"].ToString() : "";
clsPrint.ItemStyle = "text-align: center;";
break;
}
objPrint.Add(clsPrint);
counter++;
if ((drpFromQuarter.SelectedIndex == 1) && (drpFromYear.SelectedIndex == 1))
{
for (int i = 0; i < grdProjectPerformanceGroupBSummary.Rows.Count; i++)
{
grdProjectPerformanceGroupBSummary.Columns[9].Visible = false;
}
}
else
{
grdProjectPerformanceGroupBSummary.Columns[9].Visible = true;
}
}
}
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
customTbl.RenderControl(htw);
string conditionalFooter = sw.ToString();
string abbr = ratecrdiv.InnerHtml + " " + conditionalFooter + "<br />" + "<b>Abbrivation Used:</b> <i>Completion Delay - Compl Dly, Cont Awd- Contract Award, Disbursment - Disb, Audited Project Account - Aud Prj Acc </i>";
string footer = "<i style='font-size:xx-small'><b><img height='20px' width='20px' src='../Images/Icons/green.png'/>Green Tick Mark shows Range(0-3), <img height='20px' width='20px' src='../Images/Icons/yellow.png'/>Yellow Exclamation shows Range(4-7), <img height='20px' width='20px' src='../Images/Icons/Red.png'/>Red Hyphen Shows Range(>= 8)</b><i><br/> " + abbr + "";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
//excel.TableHeader = "Effective Loans";
excel.TableHeader = "Effective Loans <br/><span style='padding: 0 70px'> As on "
+ (drplstQuarter.SelectedIndex.ToString() == "1" ? "31st Mar" + drpLstYear.SelectedItem.Text :
drplstQuarter.SelectedIndex.ToString() == "2" ? "30 June" + drpLstYear.SelectedItem.Text :
drplstQuarter.SelectedIndex.ToString() == "3" ? "30 Sep" + drpLstYear.SelectedItem.Text :
drplstQuarter.SelectedIndex.ToString() == "4" ? "31 Dec" + drpLstYear.SelectedItem.Text : "")
+
" TO " + (drpFromQuarter.SelectedIndex.ToString() == "1" ? "31st Mar" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "2" ? "30 June" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "3" ? "30 Sep" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "4" ? "31 Dec" + drpFromYear.SelectedItem.Text : "") + "</span>";
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
string[] header = new string[]
{
"Loan",
"vsDocCatName",
"dtOfApproval",
"dtofClosing",
"dtRevisedClosingDate",
"dtOfMidYear",
"dtLiklyClosing",
"NetDisbursment",
"NoofMonthCurrentToMid",
"RateofCurntDisb",
"remainingLoan",
"NoofAdtnlMonths",
"ImplementationPeriod",
"RevisedImplementationPeriod",
"DelayInMonths",
"PercntDelay"
};
string[] datacolumn = new string[grdProjectPerformanceGroupCDetail.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupCDetail.Columns[iLoop].Visible != false)
{
clsPrint = new clsPrintObject(header[counter], grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br />", ""));
if (grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Flag") || grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Last Flag"))
{
clsPrint.FlagColumnName = true;
}
if (grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Approval") ||
grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Closing") ||
grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Revised Closing") ||
grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Likely Closing") ||
grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Mid")
)
{
clsPrint.headerGroup = true;
}
clsPrint.mGroupSize = "5";
clsPrint.mGroupHeadName = "Date";
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
switch (clsPrint.ColumnName)
{
case "Loan":
clsPrint.ItemStyle = "text-align: Left;width: 400px;";
break;
case "dtOfApproval":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "dtofClosing":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "dtRevisedClosingDate":
clsPrint.Format = "{0:dd MMM yyyy}";
//clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "dtOfMidYear":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "'text-align: center;width: 66px;";
break;
case "dtLiklyClosing":
clsPrint.Format = "{0:dd MMM yyyy}";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "NetDisbursment":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;width: 66px;";
break;
case "NoofMonthCurrentToMid":
clsPrint.Format = "";
clsPrint.ItemStyle = "'text-align: right;width: 66px;";
break;
case "RateofCurntDisb":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "remainingLoan":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "NoofAdtnlMonths":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "ImplementationPeriod":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "RevisedImplementationPeriod":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "DelayInMonths":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "PercntDelay":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: right;";
break;
case "iFlag":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;";
break;
case "Score":
clsPrint.Format = "";
clsPrint.ItemStyle = "text-align: center;";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
string abbr = "<b>Abbrivation Used:</b><i> Rev: Revised,Mths: Months, C-M: Current to Mid,Rt: Rate, Adtnl: Additional, Impl: Implementation</i>";
string footer = "<i style='font-size:xx-small'><b></b><i>" + abbr + "<br/>";
excel.TableStyle = "style:'width:100%;'";
excel.FlagValues = flag;
// excel.TableHeader = "Completion Delay";
excel.TableHeader = "Completion Delay As on "
+ (drpFromQuarter.SelectedIndex.ToString() == "1" ? "Mar" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "2" ? "June" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "3" ? "Sep" + drpFromYear.SelectedItem.Text :
drpFromQuarter.SelectedIndex.ToString() == "4" ? "Dec" + drpFromYear.SelectedItem.Text : "");
excel.TableFooter = footer;
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnPrint_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("iPerformanceFlagsAID"))
{
dt.Columns.Remove("iPerformanceFlagsAID");
}
Print excel = new Print();
List <clsPrintObject> objPrint = new List <clsPrintObject>();
clsPrintObject clsPrint = null;
List <Flags> flag = new List <Flags>();
Flags testFlag = new Flags();
testFlag.key = "Year";
testFlag.value = "2011";
flag.Add(testFlag);
if (drpLoanNumber.SelectedIndex > 0)
{
Flags loanFlag = new Flags();
loanFlag.key = "<br/>Loan Number ";
loanFlag.value = drpLoanNumber.SelectedItem.Text;
flag.Add(loanFlag);
}
if (drpSector.SelectedIndex > 0)
{
Flags sectorFlag = new Flags();
sectorFlag.key = "<br/>Sector ";
sectorFlag.value = drpSector.SelectedItem.Text;
flag.Add(sectorFlag);
}
string[] header = new string[]
{
"vsLoanNumber",
"Old",
"iNewFlag",
"vsReason",
"dtModDate"
};
string[] datacolumn = new string[grdOverrideGroupA.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdOverrideGroupA.Columns[iLoop].HeaderText != "Select Flag")
{
clsPrint = new clsPrintObject(header[counter], grdOverrideGroupA.Columns[iLoop].HeaderText.Replace("<br />", ""));
if (grdOverrideGroupA.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Orginal Flag") || grdOverrideGroupA.Columns[iLoop].HeaderText.Replace("<br />", "").ToString().Equals("Override Flag"))
{
clsPrint.FlagColumnName = true;
}
clsPrint.HeaderStyle = "style='font-weight:bold;width:80%;'";
clsPrint.FooterStyle = "style='font-weight:bold;'";
if (grdOverrideGroupA.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Sign") ||
grdOverrideGroupA.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Eff") ||
grdOverrideGroupA.Columns[iLoop].HeaderText.Replace("<br/>", "").ToString().Equals("Est. PMU")
)
{
clsPrint.headerGroup = true;
}
clsPrint.mGroupSize = "3";
clsPrint.mGroupHeadName = "Approval To";
switch (clsPrint.ColumnName)
{
case "vsLoanNumber": // text header Column
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 350px;'";
break;
case "Old":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 66px;'";
break;
case "iNewFlag":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 350px;'";
break;
case "vsReason":
clsPrint.Format = "";
clsPrint.ItemStyle = "style='text-align: Left;width: 350px;'";
break;
case "dtModDate":
clsPrint.Format = "{0:d}";
clsPrint.ItemStyle = "style='text-align: center;width: 150px;'";
break;
}
objPrint.Add(clsPrint);
counter++;
}
}
//string abbr = "<b>Abbrivation Used:</b> <i></i>";
string footer = "<i style='font-size:xx-small'><b><img height='20px' width='20px' src='../Images/Icons/green.png'/>Green Tick Mark shows Range(0-3), <img height='20px' width='20px' src='../Images/Icons/yellow.png'/>Yellow Exclamation shows Range(4-7), <img height='20px' width='20px' src='../Images/Icons/Red.png'/>Red Hyphen Shows Range(> 8)</b><i><br/> ";
excel.TableFooter = footer;
excel.TableStyle = "style:'width:100%;font-size:10pt;'";
excel.FlagValues = flag;
// excel.TableHeader = "Override Group-A";
excel.TableHeader = "Override Group-A As on "
+ (drpFromMonth.SelectedItem.ToString() + " " + drpFromYear.SelectedItem.ToString());
Session[clsConstant.SESS_PRINTVALUE] = (string)excel.GenerateHTMLString(dt, objPrint);
AddPrintScript();
}
catch (Exception ex)
{
logger.Error(ex);
}
}
