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