private void GetGeneralLedgerTransactionalData(GeneralLedgerReportMasterModel MasterModel) { GlBL BL = new GlBL(); List <GeneralLedgerReportItem> list = new List <GeneralLedgerReportItem>(); MasterModel.GeneralLedgerItems = list; DataSet ds = BL.PerformSearch(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (Convert.ToString(ds.Tables[0].Rows[i]["GL_Number"]).GetType() != Type.GetType("System.DBNull")) { GeneralLedgerReportItem item = new GeneralLedgerReportItem(); item.elt_account_number = Convert.ToString(ds.Tables[0].Rows[i]["elt_account_number"]); item.GL_Name = Convert.ToString(ds.Tables[0].Rows[i]["GL_Name"]); item.GL_Number = Convert.ToString(ds.Tables[0].Rows[i]["GL_Number"]); item.Start_Balance = ds.Tables[0].Rows[i]["Start Balance"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[0].Rows[i]["Start Balance"])).ToString("#.##"); item.Debit = ds.Tables[0].Rows[i]["Debit"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[0].Rows[i]["Debit"])).ToString("#.##"); item.Credit = ds.Tables[0].Rows[i]["Credit"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[0].Rows[i]["Credit"])).ToString("#.##"); for (int k = 0; k < ds.Tables[1].Rows.Count; k++) { if (ds.Tables[0].Rows[i]["GL_Number"].GetType() != Type.GetType("System.DBNull")) // if (Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]) == Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"])) { GeneralLedgerTransactionalItem trans = new GeneralLedgerTransactionalItem(); trans.elt_account_number = Convert.ToString(ds.Tables[1].Rows[k]["elt_account_number"]); trans.GL_Number = Convert.ToString(ds.Tables[1].Rows[k]["GL_Number"]); trans.GL_Name = Convert.ToString(ds.Tables[1].Rows[k]["GL_Name"]); trans.Company_Name = Convert.ToString(ds.Tables[1].Rows[k]["Company_Name"]); trans.Date = Convert.ToString(ds.Tables[1].Rows[k]["Date"]); trans.Debit = ds.Tables[1].Rows[k]["Debit"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[1].Rows[k]["Debit"])).ToString("#.##"); trans.Credit = ds.Tables[1].Rows[k]["Credit"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[1].Rows[k]["Credit"])).ToString("#.##"); trans.Memo = Convert.ToString(ds.Tables[1].Rows[k]["Memo"]); trans.Num = Convert.ToString(ds.Tables[1].Rows[k]["Num"]); trans.Type = Convert.ToString(ds.Tables[1].Rows[k]["Type"]); trans.Split = Convert.ToString(ds.Tables[1].Rows[k]["Split"]); trans.Link = Convert.ToString(ds.Tables[1].Rows[k]["Link"]); item.TransactionItems.Add(trans); } //if (Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) == "Total") //{ // MasterModel.Total = Convert.ToString(ds.Tables[1].Rows[k]["Amount"]); //} if (Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) == "Cumulative Total") //{ // MasterModel.Cumulative_Total = Convert.ToString(ds.Tables[1].Rows[k]["Amount"]); //} } // if (item.Amount != "") { // if (double.Parse(item.Amount) != 0) list.Add(item); } } } }
private IEnumerable GetBankRegisterTransactionalData() { GlBL BL = new GlBL(); List <BankRegisterItem> list = new List <BankRegisterItem>(); DataSet ds = BL.PerformSearch(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (Convert.ToString(ds.Tables[0].Rows[i]["Date"]) != "" && Convert.ToString(ds.Tables[0].Rows[i]["Bank_Account"]) != "") { BankRegisterItem item = new BankRegisterItem(); item.elt_account_number = Convert.ToString(ds.Tables[0].Rows[i]["elt_account_number"]); item.Date = Convert.ToString(ds.Tables[0].Rows[i]["Date"]); item.Credit = ds.Tables[0].Rows[i]["Credit(-)"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[0].Rows[i]["Credit(-)"])).ToString("#.#0"); item.Debit = ds.Tables[0].Rows[i]["Debit(+)"].GetType() == Type.GetType("System.DBNull") ? "" : decimal.Parse(Convert.ToString(ds.Tables[0].Rows[i]["Debit(+)"])).ToString("#.#0"); item.Memo = Convert.ToString(ds.Tables[0].Rows[i]["Memo"]); item.PrintCheckAs = Convert.ToString(ds.Tables[0].Rows[i]["PrintCheckAs"]); item.Type = Convert.ToString(ds.Tables[0].Rows[i]["Type"]); item.Void = Convert.ToString(ds.Tables[0].Rows[i]["Void"]); item.Clear = Convert.ToString(ds.Tables[0].Rows[i]["Clear"]); item.CheckNo = Convert.ToString(ds.Tables[0].Rows[i]["Check_No"]); item.Link = Convert.ToString(ds.Tables[0].Rows[i]["Link"]); item.Bank_Account = Convert.ToString(ds.Tables[0].Rows[i]["Bank_Account"]); item.Description = Convert.ToString(ds.Tables[0].Rows[i]["Description"]); list.Add(item); } } return(list); }
private void GetExpenseDetailTransactionalData(ExpenseReportMasterModel MasterModel) { GlBL BL = new GlBL(); List <ExpenseItem> list = new List <ExpenseItem>(); MasterModel.ExpenseItems = list; DataSet ds = BL.PerformSearch(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (Convert.ToString(ds.Tables[0].Rows[i]["Customer_Number"]).GetType() != Type.GetType("System.DBNull")) { ExpenseItem item = new ExpenseItem(); item.Amount = Convert.ToString(ds.Tables[0].Rows[i]["Amount"]); item.Balance = Convert.ToString(ds.Tables[0].Rows[i]["Balance"]); item.customer_name = Convert.ToString(ds.Tables[0].Rows[i]["customer_name"]); item.customer_number = Convert.ToString(ds.Tables[0].Rows[i]["customer_number"]); for (int k = 0; k < ds.Tables[1].Rows.Count; k++) { if (ds.Tables[0].Rows[i]["Customer_Name"].GetType() != Type.GetType("System.DBNull") && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Total" && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Cumulative Total") { if (Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]) == Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"])) { ExpenseTransactionalItem trans = new ExpenseTransactionalItem(); trans.elt_account_number = Convert.ToString(ds.Tables[1].Rows[k]["elt_account_number"]); trans.Amount = Convert.ToString(ds.Tables[1].Rows[k]["Amount"]); trans.Balance = Convert.ToString(ds.Tables[1].Rows[k]["Balance"]); trans.Customer_Name = Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]); trans.Customer_Number = Convert.ToString(ds.Tables[1].Rows[k]["Customer_Number"]); trans.Date = Convert.ToString(ds.Tables[1].Rows[k]["Date"]); trans.Link = Convert.ToString(ds.Tables[1].Rows[k]["Link"]); trans.Num = Convert.ToString(ds.Tables[1].Rows[k]["Num"]); trans.Memo = Convert.ToString(ds.Tables[1].Rows[k]["Memo"]); trans.Split = Convert.ToString(ds.Tables[1].Rows[k]["Split"]); trans.Num = Convert.ToString(ds.Tables[1].Rows[k]["Num"]); trans.Type = Convert.ToString(ds.Tables[1].Rows[k]["Type"]); item.TransactionItems.Add(trans); } } if (Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) == "Total") { MasterModel.Total = Convert.ToString(ds.Tables[1].Rows[k]["Amount"]); } if (Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) == "Cumulative Total") { MasterModel.Cumulative_Total = Convert.ToString(ds.Tables[1].Rows[k]["Amount"]); } } if (item.Amount != "") { if (double.Parse(item.Amount) != 0) { list.Add(item); } } } } }
private List <ARDetailItem> GetARDetailTransactionalData() { GlBL BL = new GlBL(); List <ARDetailItem> list = new List <ARDetailItem>(); DataSet ds = BL.PerformSearch(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ARDetailItem item = new ARDetailItem(); item.elt_account_number = Convert.ToString(ds.Tables[0].Rows[i]["elt_account_number"]); item.Amount = Convert.ToString(ds.Tables[0].Rows[i]["Amount"]); item.Balance = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["Balance"]).ToString("#0.00")); item.Customer_Name = Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]); item.Invoiced = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["Invoiced"]).ToString("#0.00")); item.Received = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["Received"]).ToString("#0.00")); item.Start = Convert.ToString(ds.Tables[0].Rows[i]["Start"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[0].Rows[i]["Start"]).ToString("#0.00")); item.To_do = Convert.ToString(ds.Tables[0].Rows[i]["To_do"]); for (int k = 0; k < ds.Tables[1].Rows.Count; k++) { if (ds.Tables[0].Rows[i]["Customer_Name"].GetType() != Type.GetType("System.DBNull") && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Total" && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Cumulative Total") { if (Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]) == Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"])) { ARDetailTransactionItem trans = new ARDetailTransactionItem(); trans.elt_account_number = Convert.ToString(ds.Tables[1].Rows[k]["elt_account_number"]); trans.Amount = Convert.ToString(ds.Tables[1].Rows[k]["Amount"]); trans.Balance = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["Balance"]).ToString("#0.00")); trans.Customer_Name = Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]); trans.Invoiced = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["Invoiced"]).ToString("#0.00")); trans.Received = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["Received"]).ToString("#0.00")); trans.Start = Convert.ToString(ds.Tables[1].Rows[k]["Start"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[1].Rows[k]["Start"]).ToString("#0.00")); trans.Link = Convert.ToString(ds.Tables[1].Rows[k]["Link"]); trans.File_No = Convert.ToString(ds.Tables[1].Rows[k]["File No."]); trans.Date = Convert.ToString(ds.Tables[1].Rows[k]["Date"]); trans.Memo = Convert.ToString(ds.Tables[1].Rows[k]["Memo"]); trans.Num = Convert.ToString(ds.Tables[1].Rows[k]["Num"]); trans.Type = Convert.ToString(ds.Tables[1].Rows[k]["Type"]); trans.Customer_Number = Convert.ToString(ds.Tables[1].Rows[k]["Customer_Number"]); item.TransactionItems.Add(trans); } } } list.Add(item); } Session["GetARDetailTransactionalData"] = list; return(list); }
private List <APDisputeItem> GetAPDisputeTransactionalData() { GlBL BL = new GlBL(); DataSet ds = BL.PerformSearch(); List <APDisputeItem> List = new List <APDisputeItem>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { APDisputeItem item = new APDisputeItem(); item.Company_Name = Convert.ToString(ds.Tables[0].Rows[i]["dba_name"]); item.Phone = Convert.ToString(ds.Tables[0].Rows[i]["Phone"]); item.Class = Convert.ToString(ds.Tables[0].Rows[i]["class_code"]); item.Customer_Number = Convert.ToString(ds.Tables[0].Rows[i]["org_account_number"]); item.Balance = Convert.ToString(ds.Tables[0].Rows[i]["Balance"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[0].Rows[i]["Balance"]).ToString("#0.00")); item.Bill_Amount = Convert.ToString(ds.Tables[0].Rows[i]["Bill Amount"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[0].Rows[i]["Bill Amount"]).ToString("#0.00")); item.Paid_Amount = Convert.ToString(ds.Tables[0].Rows[i]["Paid Amount"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[0].Rows[i]["Paid Amount"]).ToString("#0.00")); item.Dispute_Amount = Convert.ToString(ds.Tables[0].Rows[i]["Dispute Amount"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[0].Rows[i]["Dispute Amount"]).ToString("#0.00")); for (int k = 0; k < ds.Tables[1].Rows.Count; k++) { if (ds.Tables[0].Rows[i]["Customer_Name"].GetType() != Type.GetType("System.DBNull") && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Total" && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Cumulative Total") { if (Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]) == Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"])) { List <APDisputeTransactionItem> list = new List <APDisputeTransactionItem>(); APDisputeTransactionItem trans = new APDisputeTransactionItem(); trans.Customer_Number = Convert.ToString(ds.Tables[1].Rows[k]["vendor_number"]); trans.Date = Convert.ToString(ds.Tables[1].Rows[k]["bill_date"]); trans.FileNo = Convert.ToString(ds.Tables[1].Rows[k]["file_no"]); trans.Memo = Convert.ToString(ds.Tables[1].Rows[k]["Memo"]); trans.Payment_Method = Convert.ToString(ds.Tables[1].Rows[k]["pmt_method"]); trans.Dispute_Amount = Convert.ToString(ds.Tables[1].Rows[k]["amt_dispute"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[1].Rows[k]["amt_dispute"]).ToString("#0.00")); trans.Due_Amount = Convert.ToString(ds.Tables[1].Rows[k]["amt_due"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[1].Rows[k]["amt_due"]).ToString("#0.00")); trans.Paid_Amount = Convert.ToString(ds.Tables[1].Rows[k]["amt_paid"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[1].Rows[k]["amt_paid"]).ToString("#0.00")); trans.Company_Name = item.Company_Name; trans.Phone = item.Phone; item.TransactionItems.Add(trans); } } } List.Add(item); } Session["GetAPDisputeTransactionalData"] = List; return(List); }
private List <BalanceSheetItem> GetBalanceSheetTransactionalData() { GlBL BL = new GlBL(); List <BalanceSheetItem> list = new List <BalanceSheetItem>(); DataSet ds = BL.PerformSearch(); for (int i = 0; i < ds.Tables["Detail"].Rows.Count; i++) { { BalanceSheetItem item = new BalanceSheetItem(); item.Amount = Convert.ToString(ds.Tables["Detail"].Rows[i]["Amount"]); item.GLAccountName = Convert.ToString(ds.Tables["Detail"].Rows[i]["gl_name"]); item.GlAccountNumber = Convert.ToString(ds.Tables["Detail"].Rows[i]["gl_number"]); item.Type = Convert.ToString(ds.Tables["Detail"].Rows[i]["Type"]); item.Category = Convert.ToString(ds.Tables["Detail"].Rows[i]["gl_account_type"]); list.Add(item); } } Session["GetBalanceSheetTransactionalData"] = list; return(list); }
private List <APAgingItem> GetAPAgingTransactionalData() { GlBL BL = new GlBL(); List <APAgingItem> list = new List <APAgingItem>(); DataSet ds = BL.PerformSearch(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Posted Transactions") { APAgingItem item = new APAgingItem(); item.Company_Name = Convert.ToString(ds.Tables[0].Rows[i]["vendor_name"]); item.Current = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["Current"]).ToString("#0.00")); item.Customer_Number = Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]); item.One_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["1~30"]).ToString("#0.00")); item.Two_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["31~60"]).ToString("#0.00")); item.Three_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["61~90"]).ToString("#0.00")); item.More_Than_Three_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["+90"]).ToString("#0.00")); item.Total = Convert.ToString(Convert.ToDecimal(ds.Tables[0].Rows[i]["Total"]).ToString("#0.00")); item.Phone = Convert.ToString(ds.Tables[0].Rows[i]["telephone"]); for (int k = 0; k < ds.Tables[1].Rows.Count; k++) { if (ds.Tables[0].Rows[i]["Customer_Name"].GetType() != Type.GetType("System.DBNull") && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Total" && Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"]) != "Cumulative Total") { if (Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]) == Convert.ToString(ds.Tables[0].Rows[i]["Customer_Name"])) { APAgingTransactionalItem trans = new APAgingTransactionalItem(); trans.Aging = Convert.ToString(ds.Tables[1].Rows[k]["Aging"]); trans.Date = Convert.ToString(ds.Tables[1].Rows[k]["Date"]); trans.Company_Name = Convert.ToString(ds.Tables[1].Rows[k]["vendor_name"]); //trans.Current = Convert.ToString(ds.Tables[1].Rows[k]["Current"]); trans.Customer_Number = Convert.ToString(ds.Tables[1].Rows[k]["Customer_Name"]); trans.Due_Date = Convert.ToString(ds.Tables[1].Rows[k]["Due Date"]); trans.Doc_Number = Convert.ToString(ds.Tables[1].Rows[k]["Doc.No."]); trans.Ref_Number = Convert.ToString(ds.Tables[1].Rows[k]["Ref No."]); trans.File_Number = Convert.ToString(ds.Tables[1].Rows[k]["File No."]); trans.Link = Convert.ToString(ds.Tables[1].Rows[k]["Link"]); trans.Type = Convert.ToString(ds.Tables[1].Rows[k]["Type"]); trans.Open_Balance = Convert.ToString(ds.Tables[1].Rows[k]["Open Balance"].GetType() == Type.GetType("System.DBNull") ? "0.00" : Convert.ToDecimal(ds.Tables[1].Rows[k]["Open Balance"]).ToString("#0.00")); trans.Ref_Number = Convert.ToString(ds.Tables[1].Rows[k]["Ref No."]); trans.One_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["1~30"]).ToString("#0.00")); trans.Two_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["31~60"]).ToString("#0.00")); trans.Three_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["61~90"]).ToString("#0.00")); trans.More_Than_Three_Month = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["+90"]).ToString("#0.00")); trans.Total = Convert.ToString(Convert.ToDecimal(ds.Tables[1].Rows[k]["Total"]).ToString("#0.00")); item.TransactionItems.Add(trans); } } } list.Add(item); } } Session["GetAPAgingTransactionalData"] = list; return(list); }