protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
string CaptionFlag = ((Label)grdProjectPerformanceGroupBSummary.HeaderRow.FindControl("lblHeader")).Text;
string CaptionLastFlag = ((Label)grdProjectPerformanceGroupBSummary.HeaderRow.FindControl("lbllastHeader")).Text;
excelObject = new clsExcelObject("Loan", "Loan No");
arrayList.Add(excelObject);
excelObject = new clsExcelObject("DocCategory", "Sector");
arrayList.Add(excelObject);
excelObject = new clsExcelObject("Score", CaptionFlag);
arrayList.Add(excelObject);
if ((drpFromQuarter.SelectedIndex != 1) || (drpFromYear.SelectedIndex != 1))
{
excelObject = new clsExcelObject("iLastFlag", CaptionLastFlag);
arrayList.Add(excelObject);
}
excel.ExportToExcel(dt, "Effective Loans", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgbtnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
Utility objUtil = new Utility();
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsTAName",
"iTANumber",
"cTAAmount",
"vsProjectName",
"dtStartDate",
"dtEndDate",
"bTAActive",
};
string[] datacolumn = new string[grdTaDetails.Columns.Count - 1];
int counter = 0;
for (int i = 1; i <= header.Length; i++)
{
if (grdTaDetails.Columns[i].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdTaDetails.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Technical Assistance Details", list);
}
protected void imgBtnExportToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsModuleName",
"memoModuleDesc",
};
string[] datacolumn = new string[2];
int counter = 0;
for (int i = 1; i <= 2; i++)
{
objExcel = new clsExcelObject(header[counter], gridViewModuleDetails.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
excel.ExportToExcel(dt, "Module Details", list);
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"DocCategory",
"Tar",
"act",
"percentage"
};
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)
{
objExcel = new clsExcelObject(header[counter], grdDisbursementSummary.Columns[iLoop].HeaderText.Replace("<br/>", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Summary of Disbursement", list);
}
protected void btnExportToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsLoanNumber",
"vsPackageNumber",
"vsPackageName",
"dtStartDate",
"dtEndDate",
};
string[] datacolumn = new string[grdPackage.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdPackage.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdPackage.Columns[iLoop].HeaderText.Replace("<br/>", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Package Details", list);
}
protected void imgButtonExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
int j = 0;
if (dt.Columns.Contains("iDisbursementID"))
{
j = 1;
}
else
{
j = 0;
}
for (int i = 1; i < grdDisbursement.Columns.Count - 1; i++)
{
excelObject = new clsExcelObject(dt.Columns[j].ColumnName, grdDisbursement.Columns[i].HeaderText.Replace("</br>", ""));
arrayList.Add(excelObject);
j++;
}
excel.ExportToExcel(dt, "Disbursement List", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
List <Flags> flag = new List <Flags>();
string[] header = new string[]
{
"LoanNumber",
"vsAgencyName",
"vsProjectName",
"VendorGroupName",
"dtAdvertisement",
"dtSubmission",
"iAmount",
"dtAdvertisementSent",
"DocSentStatus"
};
string[] datacolumn = new string[grdAdvertisementDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdAdvertisementDetails.Columns[iLoop].HeaderText.Equals("Send Email"))
{
continue;
}
if (grdAdvertisementDetails.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdAdvertisementDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.FlagValues = flag;
excel.ExportToExcel(dt, "Advertisement_Details", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
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");
}
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsAgencyCode",
"vsAgencyName",
"vsAddress",
"vsPostalCode",
"vsState",
"vsTelephone",
"vsCellPhone",
"vsFax",
"vsEmail",
"vsSkypeID",
"dtStartDate",
"dtEndDate"
};
string[] datacolumn = new string[grdAgencyDetails.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdAgencyDetails.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdAgencyDetails.Columns[iLoop].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Agency Details", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
dt.Columns.Remove("iFundingAgencyID");
dt.Columns.Remove("iDocCatFAID");
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsPipelineNumber",
"vsPipelineName",
"vsAgencyName",
"vsDocCatFAName",
"vsDocCatName",
"vsDEAFileNo",
"cAmount",
"NegotiationDate",
"ApprovalDate",
"SigningDate",
"dtClosingDate",
"dtRevisedClosingDate",
"TypeName"
};
string[] datacolumn = new string[grdProjectDetailsMaster.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectDetailsMaster.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdProjectDetailsMaster.Columns[iLoop].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Project Details", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"Loan",
"vsDocCatName",
"dtofClosing",
"dtOfApproval",
"dtOfMidYear",
"dtLiklyClosing",
"NetDisbursment",
"NoofMonthCurrentToMid",
"RateofCurntDisb",
"remainingLoan",
"NoofAdtnlMonths",
"ImplementationPeriod",
"RevisedImplementationPeriod",
"DelayInMonths",
"PercntDelay"
};
string[] datacolumn = new string[grdProjectPerformanceGroupCDetail.Columns.Count];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupCDetail.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Completion Delay", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
string[] headerTextForExcel =
{
"Loan",
"Agency",
"State",
"Sector",
"Year",
"Target Qtr1",
"Target Qtr2",
"Target Qtr3",
"Target Qtr4",
"Actual Jan",
"Actual Feb",
"Actual Mar",
"Actual Apr",
"Actual May",
"Actual Jun",
"Actual Jul",
"Actual Aug",
"Actual Sep",
"Actual Oct",
"Actual Nov",
"Actual Dec",
"Target Total",
"Actual Total",
};
for (int i = 1; i <= headerTextForExcel.Length; i++)
{
excelObject = new clsExcelObject(dt.Columns[i].ColumnName, headerTextForExcel[i - 1]);
arrayList.Add(excelObject);
}
excel.ExportToExcel(dt, "Contract_Award_List", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
dt1 = new DataTable();
dt1 = dt.Copy();
dt1.Columns["LnName"].SetOrdinal(1);
dt1.Columns["orgScore"].SetOrdinal(2);
dt1.Columns["iYear"].SetOrdinal(3);
dt1.Columns["iQuarter"].SetOrdinal(4);
dt1.Columns["iNewFlag"].SetOrdinal(5);
dt1.Columns["vsReason"].SetOrdinal(6);
dt1.Columns["dtModDate"].SetOrdinal(7);
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
for (int i = 1; i <= grdOverrideGroupB.Columns.Count - 2; i++)
{
//grdOverrideGroupB.Columns[5].Visible = false;
if (grdOverrideGroupB.Columns[i].HeaderText == "Select Flag")
{
excelObject = new clsExcelObject(dt1.Columns[i].ColumnName, grdOverrideGroupB.Columns[i + 1].HeaderText);
arrayList.Add(excelObject);
}
else if (grdOverrideGroupB.Columns[i].HeaderText == "Reason")
{
excelObject = new clsExcelObject(dt1.Columns[i].ColumnName, grdOverrideGroupB.Columns[i + 1].HeaderText);
arrayList.Add(excelObject);
}
else
{
excelObject = new clsExcelObject(dt1.Columns[i].ColumnName, grdOverrideGroupB.Columns[i].HeaderText);
arrayList.Add(excelObject);
}
}
excel.ExportToExcel(dt1, "Override - Group B Report", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsFirstName",
"vsLastName",
"vsUserName",
"vsDesignationName",
"vsCellPhone",
"vsEmailID",
"vsAgencyName",
"vsSkypeID",
"vsParentUser",
"vsEmailID",
"bSuperUser"
};
string[] datacolumn = new string[grdMyProfile.Rows.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdMyProfile.Rows[iLoop].Visible != false)
{
//objExcel = new clsExcelObject(header[counter], grdMyProfile.Rows[iLoop].HeaderText.Replace("<br />", ""));
objExcel = new clsExcelObject(header[counter], grdMyProfile.Rows[iLoop].Height.ToString());
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "My Profile", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
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 = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdUser.Columns[iLoop].Visible != false)
{
excelObject = new clsExcelObject(header[counter], grdUser.Columns[iLoop].HeaderText.Replace("<br/>", ""));
arrayList.Add(excelObject);
counter++;
}
}
excel.ExportToExcel(dt, "User Details", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
string[] header = new string[]
{
"vsAgencyName",
"vsFirmName",
"vsFirmtype",
"dtEvalDate",
"vsCWWP",
"vsQOO",
"vsPS",
"vsTA",
"vsAR",
"vsComments",
"btFinal"
};
string[] datacolumn = new string[grdFirmEvaluation.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdFirmEvaluation.Columns[iLoop].Visible != false)
{
excelObject = new clsExcelObject(header[counter], grdFirmEvaluation.Columns[iLoop].HeaderText.Replace("<br/>", ""));
arrayList.Add(excelObject);
counter++;
}
}
excel.ExportToExcel(dt, "Firm Evaluation", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("CFDRelationID"))
{
dt.Columns.Remove("CFDRelationID");
}
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsLoanNumber",
"vsPackageNumber",
"vsFirmName",
"vsDesignationName",
"vsFirstName"
};
string[] datacolumn = new string[grdCFD.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdCFD.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdCFD.Columns[iLoop].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Consultant To Firm", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsLoanNumber",
"vsLoanName",
"Sector",
"dtApprovalDate",
"dtClosingDate",
"dtRevisedClosingDate",
};
string[] datacolumn = new string[grdProjectPerformanceGroupCDetail.Columns.Count];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectPerformanceGroupCDetail.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdProjectPerformanceGroupCDetail.Columns[iLoop].HeaderText.Replace("<br/>", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Loan Under Financial Closure", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgbtnExporttoExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsFirstName",
"vsPackageName",
"vsLoannumber",
"vsFirmName",
"vsConsCompaliance",
"vsConsOutput",
"vsPersonalStability",
"vsConsultantRating",
"vsConsAvailability",
"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)
{
objExcel = new clsExcelObject(header[counter], grdConsEvaluation.Columns[iLoop].HeaderText.Replace("<br/>", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Consultant Evaluation", list);
}
protected void imgbtnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
Utility objUtil = new Utility();
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsPortfolioNumber",
"CreditID",
"IDType",
"vsPortfolioName",
"vsAgencyName",
"vsDocCatFAName",
"vsDocCatName",
"vsDEAFileNo",
"cAmount",
"NegotiationDate",
"ApprovalDate",
"SigningDate",
"dtClosingDate",
"dtRevisedClosingDate"
};
string[] datacolumn = new string[grdTaDetails.Columns.Count - 1];
int counter = 0;
for (int i = 1; i <= header.Length; i++)
{
if (grdTaDetails.Columns[i].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdTaDetails.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Loan/Credit/Grant Details", list);
}
protected void imgBtnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsLoanNumber",
"vsLoanName",
"vsAgencyName",
"cAmount",
"dtApprovalDate",
"dtSigningDate",
"dtEffectivenessDate",
"dtEST_PMU",
"dtFirstContractAwardDate",
"dtClosingDate",
"dtRevisedClosingDate",
"vsProjectNumber",
"dtStartDate",
"dtEndDate",
"vsDocCatName"
};
string[] datacolumn = new string[2];
for (int i = 1; i <= header.Length; i++)
{
objExcel = new clsExcelObject(header[i - 1], grdLoanDetails.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
}
excel.ExportToExcel(dt, "Loan Details", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExporToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] datacolumn = new string[1];
objExcel = new clsExcelObject("vsDocCatName", grdDocumentCategoryDetails.Columns[2].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
excel.ExportToExcel(dt, "Document Cat Details", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
for (int i = 1; i < grdContractAwardReport.Columns.Count; i++)
{
excelObject = new clsExcelObject(dt.Columns[i].ColumnName, grdContractAwardReport.Columns[i].HeaderText.Replace("</br>", ""));
arrayList.Add(excelObject);
}
excel.ExportToExcel(dt, "Contractaward By Loan", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
for (int i = 0; i < grdProjectPerformanceGroupCSummary.Columns.Count - 1; i++)
{
excelObject = new clsExcelObject(dt.Columns[i].ColumnName, grdProjectPerformanceGroupCSummary.Columns[i + 1].HeaderText.Replace("<br />", ""));
arrayList.Add(excelObject);
}
excel.ExportToExcel(dt, "Completion Delay Summary", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
if (!dt.Columns.Contains("iPackConsID"))
{
dt.Columns.Remove("iPackConsID");
}
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsLoanNumber",
"vsPackageNumber",
"vsFirmType",
"vsFirmStatus",
"FirmID1"
};
string[] datacolumn = new string[grdPackageConsultant.Columns.Count - 1];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length + 1; iLoop++)
{
if (grdPackageConsultant.Columns[iLoop].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdPackageConsultant.Columns[iLoop].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Package To Firm", list);
}
protected void imgbtnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
string[] header = new string[]
{
"loanNumberWithName",
"vsProjectComponent",
"LineMinister",
"NodalOfficer",
"ProjectDirector",
"ADBTaskManager"
};
string[] datacolumn = new string[grdProjectComponentDetails.Columns.Count - 2];
int counter = 0;
for (int iLoop = 1; iLoop <= header.Length; iLoop++)
{
if (grdProjectComponentDetails.Columns[iLoop].Visible != false)
{
excelObject = new clsExcelObject(header[counter], grdProjectComponentDetails.Columns[iLoop].HeaderText.Replace("<br/>", ""));
arrayList.Add(excelObject);
counter++;
}
}
excel.ExportToExcel(dt, "Project Component Details", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgExportToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsTopic",
"Sector",
"dtFromDate",
"dtToDate",
"vsVenue",
"vsTargetAudienceName",
"vsInviteType",
"iSeats",
"vsName",
"dtLastDate",
"vsFile"
};
string[] datacolumn = new string[grdNominationManagementSystem.Columns.Count - 2];
int counter = 0;
for (int i = 1; i <= header.Length + 1; i++)
{
if (grdNominationManagementSystem.Columns[i].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdNominationManagementSystem.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Nomination Details", list);
}
protected void imgBtnExportToExcel_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"iDocSendID",
"vsFileTrackID",
"vsDocTypeName",
"vsDocName",
"vsDocCatName",
"vsLoanNumber",
"iTANumber",
"NAME",
"dtDueDate",
"LapsedDays",
"dtCreateDate"
};
string[] datacolumn = new string[grdDocReceived.Columns.Count - 4];
for (int i = 3; i < header.Length + 3; i++)
{
objExcel = new clsExcelObject(header[i - 3], grdDocReceived.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
}
excel.ExportToExcel(dt, "DocumentReceived", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void btnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
dt = new DataTable();
dt = (Session[clsConstant.SESS_TABLE] as DataTable);
DataTable dtabtemp = dt;
Excel excel = new Excel();
ArrayList arrayList = new ArrayList();
clsExcelObject excelObject = null;
string CaptionFlag = ((Label)(grdProjectPerformanceGroupA.HeaderRow.FindControl("lblHeader"))).Text;
string CaptionLastFlag = ((Label)(grdProjectPerformanceGroupA.HeaderRow.FindControl("lbllastHeader"))).Text;
excelObject = new clsExcelObject("vsLoanNumber", "Loan Number");
arrayList.Add(excelObject);
excelObject = new clsExcelObject("DocCategory", "Sector");
arrayList.Add(excelObject);
excelObject = new clsExcelObject("iAppFCount", CaptionFlag);
arrayList.Add(excelObject);
if ((drpFromMonth.SelectedIndex != 1) || (drpFromYear.SelectedIndex != 1))
{
excelObject = new clsExcelObject("iLastFlag", CaptionLastFlag);
arrayList.Add(excelObject);
}
excel.ExportToExcel(dtabtemp, "Loans Not Yet Effective", arrayList);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
protected void imgBtnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"MFFCode",
"vsLoanName",
"vsDocCatName",
"MFFApproval",
"LastDatePFR",
"MFFAmount",
"vsLoanNumber",
"dtApprovalDate",
"closing_date",
"cOrgAmount",
"MFFBalance"
};
string[] datacolumn = new string[2];
for (int i = 1; i <= header.Length; i++)
{
objExcel = new clsExcelObject(header[i - 1], grdMFFDetails.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
}
excel.ExportToExcel(dt, "MFF Details", list);
}
catch (Exception ex)
{
//logger.Error(ex);
}
}
protected void imgbtnExportToExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
Utility objUtil = new Utility();
DataTable dt = new DataTable();
dt = Session[clsConstant.SESS_TABLE] as DataTable;
Excel excel = new Excel();
ArrayList list = new ArrayList();
clsExcelObject objExcel = null;
string[] header = new string[]
{
"vsFirstName",
"vsLastName",
"dtDateOfBirth",
"dtStartDate",
"dtEndDate",
};
string[] datacolumn = new string[grdConsultantDetails.Columns.Count - 1];
int counter = 0;
for (int i = 1; i <= header.Length; i++)
{
if (grdConsultantDetails.Columns[i].Visible != false)
{
objExcel = new clsExcelObject(header[counter], grdConsultantDetails.Columns[i].HeaderText.Replace("<br />", ""));
list.Add(objExcel);
counter++;
}
}
excel.ExportToExcel(dt, "Consultant Details", list);
}
catch (Exception ex)
{
logger.Error(ex);
}
}
