private void BuildReport() { lblState.Text = ""; if (!(User.IsInRole(((int)UserRoles.urFSBDPowerReader).ToString()) || User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString()) || User.IsInRole(((int)UserRoles.urFSBDAdminAllowanceRO).ToString()) || User.IsInRole(((int)UserRoles.urFSBDAdminAllowanceWR).ToString()))) { if (Users.UserAuthorizedForFSReports(CurrentUserID, ctrlCriteria.BusinessLine, ctrlCriteria.Organization) <= 0) { throw new Exception("You are not authorized to see current report. Please select Business Line or Organization that you are allowed to review. Thank you."); } } //first check if the report data is valid: var status = FSSummaryReport.GetReportStateStatus(ctrlCriteria.FiscalYear, ctrlCriteria.Organization, ctrlCriteria.BusinessLine); if (status == (int)FundStatusReportStateStatus.rsDoesNotExist) { divReportState.Visible = true; lblState.Text = String.Format("Fund Status Report for Organization {0}, Fiscal Year {1} is not available at this moment. <p />The report data is updated by automated process every {2} minutes. <br />You can request the report immediately (it might take a few minutes). Thank you.", ctrlCriteria.Organization, ctrlCriteria.FiscalYear, Settings.Default.RebuildReportIntervalInMinutes); } else if (status == (int)FundStatusReportStateStatus.rsObsolete) { divReportState.Visible = true; lblState.Text = String.Format("Fund Status Report for Organization {0}, Fiscal Year {1} is obsolete. <p />The report data is updated by automated process every {2} minutes. <br />You can request the report immediately (it might take a few minutes). Thank you.", ctrlCriteria.Organization, ctrlCriteria.FiscalYear, Settings.Default.RebuildReportIntervalInMinutes); } else { divReportState.Visible = false; lblState.Text = ""; } if (status == (int)FundStatusReportStateStatus.rsObsolete || status == (int)FundStatusReportStateStatus.rsValid) { //draw the table tblData: var drawing_class = new FSReportUI(); drawing_class.FiscalYear = ctrlCriteria.FiscalYear; drawing_class.BookMonth = ctrlCriteria.BookMonth; drawing_class.Organization = ctrlCriteria.Organization; drawing_class.BusinessLine = ctrlCriteria.BusinessLine; drawing_class.TableToDraw = tblData; drawing_class.BuildHTMLTable(); tblData = drawing_class.TableToDraw; } }
protected override void PageLoadEvent(object sender, System.EventArgs e) { try { if (!Page.ClientScript.IsClientScriptBlockRegistered(Page.GetType(), "JS")) { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "JS", "<script language='javascript' src='include/RWAProjection.js'></script>"); Page.ClientScript.RegisterStartupScript(Page.GetType(), "JS_OnLoad", "<script FOR=window EVENT=onload language='javascript'>Page_OnLoad()</script>"); } if (!IsPostBack) { if (!(User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString()) || User.IsInRole(((int)UserRoles.urFSBDPowerReader).ToString()) || User.IsInRole(((int)UserRoles.urFSOrgAdminWR).ToString()) || User.IsInRole(((int)UserRoles.urFSOrgAdminRO).ToString()))) { throw new Exception("You are not authorized to visit this page."); } var org = Request.QueryString["org"]; var business_line = Request.QueryString["bl"]; var fiscal_year = Request.QueryString["fy"]; var book_month = Request.QueryString["bm"]; //int business_line_code = Int32.Parse(business_line); var read_only = true; if (User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString()) && org != "") { read_only = false; } else { var user_role = Users.UserAuthorizedForFSReports(CurrentUserID, business_line, org); if (user_role <= 0) { throw new Exception("You are not authorized to visit this page."); } else if (user_role == (int)UserRoles.urFSOrgAdminWR && org != "") { read_only = false; } } var label_text = "Distribution of RWA Income - Over/Under"; if (org != "") { label_text += "<br />by Function Code for Organization " + org; } else if (business_line != "0") { label_text += "<br />by Organization for Buisness Line " + business_line; //replace to the BL name } label_text += "<br />starting " + String.Format("{0:MMMM}", DateTime.Parse(book_month + "/" + fiscal_year)); label_text += " FY " + fiscal_year; lblMain.Text = label_text; var ds = FSDataServices.GetPaidDaysReference(fiscal_year, book_month); if (ds != null && ds.Tables[0].Rows.Count > 0) { label_text = String.Format("PAID DAYS: {0}. <br />DAYS IN YEAR: {1}.", ds.Tables[0].Rows[0]["CummDays"].ToString(), ds.Tables[0].Rows[0]["DaysInYear"].ToString()); lblPaidDays.Text = label_text; lblD.Value = ds.Tables[0].Rows[0]["CummDays"].ToString(); lblDD.Value = ds.Tables[0].Rows[0]["DaysInYear"].ToString(); } DataSet dsIncome; DataSet dsProjection; if (org != "") { dsIncome = FSSummaryReport.GetSummaryState(fiscal_year, org, ""); dsProjection = FSDataServices.GetRWAProjection(fiscal_year, org, ""); } else { dsIncome = FSSummaryReport.GetSummaryState(fiscal_year, "", business_line); dsProjection = FSDataServices.GetRWAProjection(fiscal_year, "", business_line); } //build Distribution Table: var obj = new RWAProjectionUI(); obj.FiscalYear = fiscal_year; obj.Organization = org; obj.BusinessLine = business_line; obj.BookMonth = book_month; obj.IncomeTable = dsIncome.Tables[0]; obj.ProjectionTable = dsProjection.Tables[0]; obj.ChartTable = tblData; obj.ReadOnly = read_only; obj.DrawDistributionTable(); tblData = obj.ChartTable; if (read_only) { btnApply.Disabled = true; } //get History:. ds = History.GetFundStatusDataUpdateHistory((int)HistoryActions.haUpdateRWADistribution, org, fiscal_year, "", 0, business_line); if (ds != null && ds.Tables[0].Rows.Count > 0) { lblMessage.Text = String.Format("Last updated by {0} on {1}.", ds.Tables[0].Rows[0]["UpdateUserName"].ToString(), String.Format("{0:MMMM dd, yyyy}", ds.Tables[0].Rows[0]["ActionDate"])); } } else { lblError.Visible = false; } } catch (Exception ex) { AddError(ex); } finally { if (Errors.Count > 0) { lblError.Text = GetErrors(); lblError.Visible = true; } } }
private void BuildReport() { lblMessages.Text = ""; lblState.Text = ""; //divData.Attributes["style"] = "display:none;"; if (!(User.IsInRole(((int)UserRoles.urFSBDPowerReader).ToString()) || User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString()) || User.IsInRole(((int)UserRoles.urFSBDAdminAllowanceRO).ToString()) || User.IsInRole(((int)UserRoles.urFSBDAdminAllowanceWR).ToString()))) { if (Users.UserAuthorizedForFSReports(CurrentUserID, ctrlCriteria.BusinessLine, ctrlCriteria.Organization) <= 0) { throw new Exception("You are not authorized to see current report. Please select Business Line or Organization that you are allowed to review. Thank you."); } } //first check if the report data is valid: var status = FSSummaryReport.GetReportStateStatus(ctrlCriteria.FiscalYear, ctrlCriteria.Organization, ctrlCriteria.BusinessLine); if (status == (int)FundStatusReportStateStatus.rsDoesNotExist) { divReportState.Visible = true; lblState.Text = String.Format("Fund Status Report for Organization {0}, Fiscal Year {1} is not available at this moment. <p />The report data is updated by automated process every {2} minutes. <br />You can request the report immediately (it might take a few minutes). Thank you.", ctrlCriteria.Organization, ctrlCriteria.FiscalYear, Settings.Default.RebuildReportIntervalInMinutes); } else if (status == (int)FundStatusReportStateStatus.rsObsolete) { divReportState.Visible = true; lblState.Text = String.Format("Fund Status Report for Organization {0}, Fiscal Year {1} is obsolete. <p />The report data is updated by automated process every {2} minutes. <br />You can request the report immediately (it might take a few minutes). Thank you.", ctrlCriteria.Organization, ctrlCriteria.FiscalYear, Settings.Default.RebuildReportIntervalInMinutes); } else { divReportState.Visible = false; lblState.Text = ""; } if (status == (int)FundStatusReportStateStatus.rsObsolete || status == (int)FundStatusReportStateStatus.rsValid) { if (status == (int)FundStatusReportStateStatus.rsValid) { lblMessages.Text = "TIP: click on the month header to enter Fund Status Report."; } draw = new FSSummaryUI(); draw.FiscalYear = ctrlCriteria.FiscalYear; draw.Organization = ctrlCriteria.Organization; draw.BusinessLine = ctrlCriteria.BusinessLine; CreateReportView((int)FundStatusSummaryReportView.svObligations, "Obligations", "Show/Hide Fund Status Summary Report - Obligations Info"); CreateReportView((int)FundStatusSummaryReportView.svObligationsMonthly, "Obligations - Monthly View", "Show/Hide Fund Status Summary Report - Obligations Monthly Amounts Info"); CreateReportView((int)FundStatusSummaryReportView.svIncome, "Income", "Show/Hide Fund Status Summary Report - Income Info"); CreateReportView((int)FundStatusSummaryReportView.svIncomeMonthly, "Income - Monthly View", "Show/Hide Fund Status Summary Report - Income Monthly Amounts Info"); CreateReportView((int)FundStatusSummaryReportView.svAllowance, "Allowance", "Show/Hide Fund Status Summary Report - Allowance Info"); CreateReportView((int)FundStatusSummaryReportView.svYearEndProjection, "Year End Projection", "Show/Hide Fund Status Summary Report - Year End Projection Info"); CreateReportView((int)FundStatusSummaryReportView.svProjectionVariance, "Projection Variance", "Show/Hide Fund Status Summary Report - Projection Variance Info"); CreateReportView((int)FundStatusSummaryReportView.svProjectedBalance, "Projected Balance", "Show/Hide Fund Status Summary Report - Projected Balance Info"); divData.Attributes["style"] = "display:inline;"; /* * StringBuilder sb = new StringBuilder(); * sb.Append("<script language='javascript'> "); * sb.Append("on_long_load(); "); * sb.Append("</script>"); * Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "load_back", sb.ToString()); */ } else { draw = null; } }
private void DrawTable() { decimal total_amount = 0; var read_only = true; if (User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString()) && Organization != "") { read_only = false; } else if (!User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString())) { var user_role = Users.UserAuthorizedForFSReports(CurrentUserID, BusinessLineCode, Organization); if (user_role <= 0) { throw new Exception("You are not authorized to visit this page."); } else if (user_role == (int)UserRoles.urFSOrgAdminWR && Organization != "") { read_only = false; } } var _add_awards = (AdjustmentsAdditional == "award") ? true : false; var _add_training = (AdjustmentsAdditional == "training") ? true : false; var _add_travel = (AdjustmentsAdditional == "travel") ? true : false; //get the data: var ds = FSDataServices.GetUserEntryData(DataEntryType, FiscalYear, BookMonth, Organization, BusinessLineCode, ReportGroupCode, _add_awards, _add_training, _add_travel, false); HtmlTableRow tr = null; HtmlTableCell td = null; int entry_id; string doc_number; decimal amount; string explanation; string entry_month; //remove first column if there is no permission for edit or delete: if (read_only) { tblData.Rows[0].Cells[0].InnerText = "BookMonth"; } //tblData.Rows[0].Cells[0].AddDisplayNone(); var iRowCount = 0; ds.Tables[0].Columns["Amount"].ColumnName = "$ Amount"; foreach (DataRow dr in ds.Tables[0].Rows) { entry_id = (int)dr["EntryID"]; entry_month = String.Format("{0:MMMM}", DateTime.Parse(dr["BookMonth"].ToString() + "/" + dr["FiscalYear"].ToString())); doc_number = (string)Utility.GetNotNullValue(dr["DocNumber"], "String"); amount = (decimal)dr["$ Amount"]; total_amount += amount; explanation = (string)Utility.GetNotNullValue(dr["Explanation"], "String"); tr = new HtmlTableRow(); tr.AddCssClass((iRowCount++) % 2 > 0 ? "tRowAlt" : "tRow"); if (entry_id >= 0 && !read_only && dr["BookMonth"].ToString() == BookMonth) { td = new HtmlTableCell(); var btnEdit = new HtmlInputImage(); btnEdit.ID = "edit_ctrl_" + entry_id.ToString(); btnEdit.Src = "../images/note.gif"; btnEdit.Alt = "Edit record"; btnEdit.AddOnClick("return edit_row(this," + entry_id.ToString() + "," + DataEntryType.ToString() + ");"); td.Controls.Add(btnEdit); tr.Cells.Add(td); td = new HtmlTableCell(); var btnDelete = new HtmlInputImage(); btnDelete.ID = "delete_ctrl_" + entry_id.ToString(); btnDelete.Src = "../images/btn_contact_delete.gif"; btnDelete.Alt = "Delete record"; btnDelete.AddOnClick("return delete_row(this," + entry_id.ToString() + "," + DataEntryType.ToString() + ");"); td.Controls.Add(btnDelete); tr.Cells.Add(td); } else { td = new HtmlTableCell(); td.ColSpan = 2; td.InnerText = entry_month; tr.Cells.Add(td); } td = new HtmlTableCell(); if (entry_id < 0) { td.InnerHtml = "<font color='green'>Show Details</font>"; td.AddOnClick("Expand(this)"); td.AddTitle("Expand"); td.Style.Add("cursor", "pointer"); } else { td.InnerHtml = doc_number != "" ? doc_number : " "; } tr.Cells.Add(td); td = new HtmlTableCell(); td.InnerText = amount == 0 ? "0" : String.Format("{0:0,0}", Convert.ToInt64(amount)); td.Align = "right"; tr.Cells.Add(td); td = new HtmlTableCell(); td.InnerHtml = explanation != "" ? explanation : " "; tr.Cells.Add(td); tblData.Rows.Add(tr); if (entry_id < 0) //expanded table { tr = new HtmlTableRow(); tr.Style.Add("display", "none"); td = new HtmlTableCell(); tr.Cells.Add(td); td = new HtmlTableCell(); td.ColSpan = 4; var mg = new MultiGrid(); mg = (MultiGrid)Page.LoadControl("..\\Controls\\MultiGrid.ascx"); td.Controls.Add(mg); tr.Cells.Add(td); tblData.Rows.Add(tr); var dtO = FundStatus.GetUserEntryDataList(DataEntryType, FiscalYear, BookMonth, Organization, BusinessLineCode, ReportGroupCode, entry_id).Tables[0]; var dt = dtO.Clone(); dt.Columns["Amount"].DataType = typeof(string); foreach (DataRow r in dtO.Rows) { dt.ImportRow(r); } dt.Columns["Amount"].ColumnName = "$ Amount"; foreach (DataRow r in dt.Rows) { r["Month"] = Month[Convert.ToInt32(r["Month"]) - 1]; r["$ Amount"] = String.Format("{0:0,0}", Convert.ToInt64(Convert.ToDecimal(r["$ Amount"]))); if (r["$ Amount"].ToString() == "00") { r["$ Amount"] = "0"; } } mg.Table = dt; mg.TblCSSClass = "eTbl"; mg.TblBorderClass = "eBorder"; mg.HeaderCSSClass = "reportHeaderGreen"; mg.ItemCSSClass = "eRow"; mg.Height = Unit.Pixel(dt.Rows.Count * 18 + 19); //make it not scrollable by setting full height } } //add row for insert record - if applicable if (!read_only) { HtmlInputText txt; tr = new HtmlTableRow(); tr.AddCssClass((iRowCount++) % 2 > 0 ? "tRowAlt" : "tRow"); td = new HtmlTableCell(); var btnCancel = new HtmlInputImage(); btnCancel.ID = "cancel_ctrl_new"; btnCancel.Src = "../images/back.gif"; btnCancel.Alt = "Cancel changes"; btnCancel.AddWidth(12); btnCancel.AddHeight(12); btnCancel.AddOnClick("return cancel_edit(this);"); td.Controls.Add(btnCancel); tr.Cells.Add(td); td = new HtmlTableCell(); var btnEdit = new HtmlInputImage(); btnEdit.ID = "save_ctrl_new"; btnEdit.Src = "../images/save.gif"; btnEdit.Alt = "Save new record"; btnEdit.AddWidth(12); btnEdit.AddHeight(12); btnEdit.AddOnClick("return save_row(this,0," + DataEntryType.ToString() + ");"); td.Controls.Add(btnEdit); tr.Cells.Add(td); td = new HtmlTableCell(); td.AddStyle("padding-left:5px;padding-right:5px"); txt = new HtmlInputText(); txt.AddStyle("width:100%;height:15px;text-align:center;"); td.Controls.Add(txt); tr.Cells.Add(td); td = new HtmlTableCell(); td.AddStyle("padding-left:5px;padding-right:5px"); txt = new HtmlInputText(); txt.AddStyle("width:100%;height:15px;text-align:center;"); txt.AddOnMouseOut("extractNumber(this,0,true,9999999999);"); txt.AddOnKeyUp("extractNumber(this,0,true,9999999999);"); txt.AddKeyPressBlockNonNumbers(); td.Controls.Add(txt); tr.Cells.Add(td); td = new HtmlTableCell(); td.AddStyle("padding-left:5px;padding-right:5px"); txt = new HtmlInputText(); txt.AddStyle("width:100%;height:15px;text-align:center;"); td.Controls.Add(txt); tr.Cells.Add(td); tblData.Rows.Add(tr); } lblAmount.Text = total_amount == 0 ? "0" : String.Format("{0:$0,0}", Convert.ToInt64(total_amount)); }
private void FundsEntryDataReport() { var Organization = Request.QueryString["org"]; var FiscalYear = Request.QueryString["fy"]; var BookMonth = Request.QueryString["bm"]; var ReportGroupCode = Int32.Parse(Request.QueryString["gcd"]); var BusinessLineCode = Request.QueryString["bl"]; var AdjustmentsAdditional = Request.QueryString["adj"]; //check if user's role allows to get this report: if (!(User.IsInRole(((int)UserRoles.urFSBDAnalystFundsCoordinator).ToString()) || User.IsInRole(((int)UserRoles.urFSBDPowerReader).ToString()) || User.IsInRole(((int)UserRoles.urFSOrgAdminWR).ToString()) || User.IsInRole(((int)UserRoles.urFSOrgAdminRO).ToString()))) { if (Users.UserAuthorizedForFSReports((new PageBase()).CurrentUserID, BusinessLineCode, Organization) <= 0) { throw new Exception("You are not authorized to review this data."); } } HtmlTableRow tr; HtmlTableCell td; var DataEntryType = 0; if (!Int32.TryParse(Request.QueryString["t"], out DataEntryType)) { throw new Exception("Error. Missing parameters."); } var sTitle = ""; switch (DataEntryType) { case (int)FundsStatusUserEntryType.ueOneTimeAdjustment: sTitle = "One Time Adjustments"; break; case (int)FundsStatusUserEntryType.ueOverUnderAccrued: sTitle = "Over/Under Accrued"; break; case (int)FundsStatusUserEntryType.ueExpectedByYearEnd: sTitle = "Expected by Year End"; break; default: throw new Exception("Error. Missing parameters."); } tr = new HtmlTableRow(); tr.Cells.AddCellLeft(sTitle, "title", 9); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); tr.Cells.AddCell("", "", 9); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); tr.Cells.AddCell(Organization, "title2", 2); tr.Cells.AddCell(String.Format("{0:MMMM}", DateTime.Parse(BookMonth + "/" + FiscalYear)), "title2", 2); tr.Cells.AddCellLeft("Fiscal Year: " + FiscalYear, "title2", 5); Sheet.Rows.Add(tr); tr = new HtmlTableRow(); //td = null; var dst = FSDataServices.GetFSReportConfiguration(); if (dst != null && dst.Tables[0] != null && dst.Tables[0].Rows.Count > 0) { var dr_col = dst.Tables[0].Select("GROUP_CD=" + ReportGroupCode.ToString()); if (dr_col.Length > 0) { tr.Cells.AddCell(dr_col[0]["Name"].ToString(), "title2", 2); } else { tr.Cells.AddCell("", "title2", 2); } } else { tr.Cells.AddCell("", "title2", 2); } //tr.Cells.Add(td); tr.Cells.AddCell("", "title2", 2); tr.Cells.AddCell("", "title2", 5); Sheet.Rows.Add(tr); //DisplayLastUpdateInfo DataSet ds = null; switch (DataEntryType) { case (int)FundsStatusUserEntryType.ueOneTimeAdjustment: ds = History.GetFundStatusDataUpdateHistory((int)HistoryActions.haUpdateOneTimeAdjustment, Organization, FiscalYear, BookMonth, ReportGroupCode, BusinessLineCode); break; case (int)FundsStatusUserEntryType.ueOverUnderAccrued: ds = History.GetFundStatusDataUpdateHistory((int)HistoryActions.haUpdateOverUnderAccrued, Organization, FiscalYear, BookMonth, ReportGroupCode, BusinessLineCode); break; case (int)FundsStatusUserEntryType.ueExpectedByYearEnd: ds = History.GetFundStatusDataUpdateHistory((int)HistoryActions.haUpdateExpectedByYearEnd, Organization, FiscalYear, BookMonth, ReportGroupCode, BusinessLineCode); break; default: throw new Exception("Error. Missing parameters."); } if (ds != null && ds.Tables[0].Rows.Count > 0) { var user_name = ds.Tables[0].Rows[0]["UpdateUserName"].ToString(); var update_date = String.Format("{0:MMMM dd, yyyy}", ds.Tables[0].Rows[0]["ActionDate"]); tr = new HtmlTableRow(); tr.Cells.AddCell(String.Format("Last updated by {0} on {1}.", user_name, update_date), "reportCaption", 9); Sheet.Rows.Add(tr); } decimal total_amount = 0; var _add_awards = (AdjustmentsAdditional == "award") ? true : false; var _add_training = (AdjustmentsAdditional == "training") ? true : false; var _add_travel = (AdjustmentsAdditional == "travel") ? true : false; int entry_id; string doc_number; decimal amount; string explanation; string entry_month; tr = new HtmlTableRow(); tr.Cells.AddCell("BookMonth", "reportHeaderBlue", 2); tr.Cells.AddCell("DocNumber", "reportHeaderBlue", 2); tr.Cells.AddCell("$ Amount", "reportHeaderBlue", 1); tr.Cells.AddCell("Explanation", "reportHeaderBlue", 4); Sheet.Rows.Add(tr); ds = FSDataServices.GetUserEntryData(DataEntryType, FiscalYear, BookMonth, Organization, BusinessLineCode, ReportGroupCode, _add_awards, _add_training, _add_travel, false); ds.Tables[0].Columns["Amount"].ColumnName = "$ Amount"; foreach (DataRow dr in ds.Tables[0].Rows) { entry_id = (int)dr["EntryID"]; entry_month = String.Format("{0:MMMM}", DateTime.Parse(dr["BookMonth"].ToString() + "/" + dr["FiscalYear"].ToString())); doc_number = (string)Utility.GetNotNullValue(dr["DocNumber"], "String"); amount = (decimal)dr["$ Amount"]; total_amount += amount; explanation = (string)Utility.GetNotNullValue(dr["Explanation"], "String"); tr = new HtmlTableRow(); tr.Cells.AddCell(entry_month, "extRow", 2); tr.Cells.AddCell(doc_number, "extRow", 2); tr.Cells.AddCell((Convert.ToInt64(amount)).ToString(), "ExtNumber", 1); tr.Cells.AddCell(explanation, "extRow", 4); Sheet.Rows.Add(tr); if (entry_id < 0) //expanded table { var dt = FundStatus.GetUserEntryDataList(DataEntryType, FiscalYear, BookMonth, Organization, BusinessLineCode, ReportGroupCode, entry_id).Tables[0]; dt.Columns["Amount"].ColumnName = "$ Amount"; if (dt == null || dt.Columns.Count == 0) { continue; } tr = new HtmlTableRow(); tr.Cells.AddCell("", "", 1); for (var i = 0; i < dt.Columns.Count; i++) { tr.Cells.AddCell(dt.Columns[i].ToString(), "reportHeaderGreen", 1); } Sheet.Rows.Add(tr); foreach (DataRow r in dt.Rows) { tr = new HtmlTableRow(); tr.Cells.AddCell("", "", 1); r["Month"] = Month[Convert.ToInt32(r["Month"]) - 1]; r["$ Amount"] = String.Format("{0:0,0}", Convert.ToInt64(Convert.ToDecimal(r["$ Amount"]))); if (r["$ Amount"].ToString() == "00") { r["$ Amount"] = "0"; } for (var i = 0; i < dt.Columns.Count; i++) { if (dt.Columns[i].ColumnName == "$ Amount") { tr.Cells.AddCell((Convert.ToInt64(r["$ Amount"])).ToString(), "IntNumber", ""); } else { tr.Cells.AddCell(r[i].ToString(), "intRow", 1); } } Sheet.Rows.Add(tr); } } } Sheet.Rows[3].Cells[2].InnerText = "Amount: " + (total_amount == 0 ? "0" : String.Format("{0:$0,0}", Convert.ToInt64(total_amount))); p_iHeaderLines = 5; }