public IEnumerable <Revenue> GetRunDate()
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = MPRContext.GetDataConnection();
var revenues = new List <Revenue>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_mpr_getDistinctrevenueRundate", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var revenue = new Revenue();
if (reader["RunDate"] != DBNull.Value)
{
revenue.RunDate = DateTime.Parse(reader["RunDate"].ToString());
}
revenues.Add(revenue);
}
con.Close();
}
return(revenues);
}
public List <PLIncomeReportAdjustment> GetCodebyUser(string username)
{
var connectionString = MPRContext.GetDataConnection();
var mprbalancesheetadjustments = new List <PLIncomeReportAdjustment>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_getplcurrentuser", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "username",
Value = username,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var mprbalancesheetadjustment = new PLIncomeReportAdjustment();
if (reader["Code"] != DBNull.Value)
{
mprbalancesheetadjustment.Code = reader["Code"].ToString();
}
mprbalancesheetadjustments.Add(mprbalancesheetadjustment);
}
con.Close();
}
return(mprbalancesheetadjustments);
}
public List <PLIncomeReportAdjustment> GetPLIncomeReportAdjustmentBySearch(string searchType, string searchValue, int number)
{
var connectionString = MPRContext.GetDataConnection();
var plIncomeAdjs = new List <PLIncomeReportAdjustment>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_mpr_pl_income_report_adjustment", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchType",
Value = searchType,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchValue",
Value = searchValue,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Number",
Value = number,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var plIncomeAdj = new PLIncomeReportAdjustment();
if (reader["id"] != DBNull.Value)
{
plIncomeAdj.Id = int.Parse(reader["id"].ToString());
}
if (reader["GLCode"] != DBNull.Value)
{
plIncomeAdj.GLCode = reader["GLCode"].ToString();
}
if (reader["Narrative"] != DBNull.Value)
{
plIncomeAdj.Narrative = reader["Narrative"].ToString();
}
if (reader["TeamCode"] != DBNull.Value)
{
plIncomeAdj.TeamCode = reader["TeamCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
plIncomeAdj.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
}
if (reader["Caption"] != DBNull.Value)
{
plIncomeAdj.Caption = reader["Caption"].ToString();
}
if (reader["BranchCode"] != DBNull.Value)
{
plIncomeAdj.BranchCode = reader["BranchCode"].ToString();
}
if (reader["RelatedAccount"] != DBNull.Value)
{
plIncomeAdj.RelatedAccount = reader["RelatedAccount"].ToString();
}
if (reader["Amount"] != DBNull.Value)
{
plIncomeAdj.Amount = decimal.Parse(reader["Amount"].ToString());
}
if (reader["CompanyCode"] != DBNull.Value)
{
plIncomeAdj.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["RunDate"] != DBNull.Value)
{
plIncomeAdj.RunDate = DateTime.Parse(reader["RunDate"].ToString());
}
plIncomeAdjs.Add(plIncomeAdj);
}
con.Close();
}
return(plIncomeAdjs);
}
public List <BalanceSheetBudgetOfficer> GetBalanceSheetBySearch(string searchValue)
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = MPRContext.GetDataConnection();
var balSheets = new List <BalanceSheetBudgetOfficer>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_mpr_balancesheetbudgetOfficer", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchValue",
Value = searchValue,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var balSheet = new BalanceSheetBudgetOfficer();
if (reader["BalancesheetBudgetOffId"] != DBNull.Value)
{
balSheet.BudgetId = int.Parse(reader["BalancesheetBudgetOffId"].ToString());
}
if (reader["CompanyCode"] != DBNull.Value)
{
balSheet.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
balSheet.MisCode = reader["AccountOfficerCode"].ToString();
}
if (reader["Year"] != DBNull.Value)
{
balSheet.Year = reader["Year"].ToString();
}
if (reader["CaptionName"] != DBNull.Value)
{
balSheet.CaptionName = reader["CaptionName"].ToString();
}
if (reader["Mth1"] != DBNull.Value)
{
balSheet.Mth1 = decimal.Parse(reader["Mth1"].ToString());
}
if (reader["Mth2"] != DBNull.Value)
{
balSheet.Mth2 = decimal.Parse(reader["Mth2"].ToString());
}
if (reader["Mth3"] != DBNull.Value)
{
balSheet.Mth3 = decimal.Parse(reader["Mth3"].ToString());
}
if (reader["Mth4"] != DBNull.Value)
{
balSheet.Mth4 = decimal.Parse(reader["Mth4"].ToString());
}
if (reader["Mth5"] != DBNull.Value)
{
balSheet.Mth5 = decimal.Parse(reader["Mth5"].ToString());
}
if (reader["Mth6"] != DBNull.Value)
{
balSheet.Mth6 = decimal.Parse(reader["Mth6"].ToString());
}
if (reader["Mth7"] != DBNull.Value)
{
balSheet.Mth7 = decimal.Parse(reader["Mth7"].ToString());
}
if (reader["Mth8"] != DBNull.Value)
{
balSheet.Mth8 = decimal.Parse(reader["Mth8"].ToString());
}
if (reader["Mth9"] != DBNull.Value)
{
balSheet.Mth9 = decimal.Parse(reader["Mth9"].ToString());
}
if (reader["Mth10"] != DBNull.Value)
{
balSheet.Mth10 = decimal.Parse(reader["Mth10"].ToString());
}
if (reader["Mth11"] != DBNull.Value)
{
balSheet.Mth11 = decimal.Parse(reader["Mth11"].ToString());
}
if (reader["Mth12"] != DBNull.Value)
{
balSheet.Mth12 = decimal.Parse(reader["Mth12"].ToString());
}
balSheets.Add(balSheet);
}
con.Close();
}
return(balSheets);
}
public List <Revenue> GetAllRevenueBySearch(string searchType, string searchValue, int number, DateTime fromDate, DateTime toDate)
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = MPRContext.GetDataConnection();
var revenues = new List <Revenue>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_mpr_revenueAll", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchType",
Value = searchType,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchValue",
Value = searchValue,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Number",
Value = number,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "FromDate",
Value = fromDate,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "ToDate",
Value = toDate,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var revenue = new Revenue();
if (reader["RevenueId"] != DBNull.Value)
{
revenue.RevenueId = int.Parse(reader["RevenueId"].ToString());
}
if (reader["TransId"] != DBNull.Value)
{
revenue.TransId = reader["TransId"].ToString();
}
if (reader["TransDate"] != DBNull.Value)
{
revenue.TransDate = DateTime.Parse(reader["TransDate"].ToString());
}
if (reader["GLCode"] != DBNull.Value)
{
revenue.GLCode = reader["GLCode"].ToString();
}
if (reader["Narrative"] != DBNull.Value)
{
revenue.Narrative = reader["Narrative"].ToString();
}
if (reader["TeamCode"] != DBNull.Value)
{
revenue.TeamCode = reader["TeamCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
revenue.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
}
if (reader["Caption"] != DBNull.Value)
{
revenue.Caption = reader["Caption"].ToString();
}
if (reader["BranchCode"] != DBNull.Value)
{
revenue.BranchCode = reader["BranchCode"].ToString();
}
if (reader["RelatedAccount"] != DBNull.Value)
{
revenue.RelatedAccount = reader["RelatedAccount"].ToString();
}
if (reader["Amount_LCY"] != DBNull.Value)
{
revenue.Amount_LCY = decimal.Parse(reader["Amount_LCY"].ToString());
}
if (reader["AccountTitle"] != DBNull.Value)
{
revenue.AccountTitle = reader["AccountTitle"].ToString();
}
if (reader["Indicator"] != DBNull.Value)
{
revenue.Indicator = reader["Indicator"].ToString();
}
if (reader["CompanyCode"] != DBNull.Value)
{
revenue.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["RunDate"] != DBNull.Value)
{
revenue.RunDate = DateTime.Parse(reader["RunDate"].ToString());
}
revenues.Add(revenue);
}
con.Close();
}
return(revenues);
}
public List <MPRBalanceSheetAdjustment> GetBalanceSheetAdjustmentByCode(string code, string userName)
{
var connectionString = MPRContext.GetDataConnection();
var balSheetAdjs = new List <MPRBalanceSheetAdjustment>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_getmprbalancesheetadjustmentbyCode", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "code",
Value = code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "username",
Value = userName,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var balSheetAdj = new MPRBalanceSheetAdjustment();
if (reader["BalancesheetAdjustmentId"] != DBNull.Value)
{
balSheetAdj.BalancesheetAdjustmentId = int.Parse(reader["BalancesheetAdjustmentId"].ToString());
}
if (reader["AccountNo"] != DBNull.Value)
{
balSheetAdj.AccountNo = reader["AccountNo"].ToString();
}
if (reader["AccountName"] != DBNull.Value)
{
balSheetAdj.AccountName = reader["AccountName"].ToString();
}
if (reader["TeamCode"] != DBNull.Value)
{
balSheetAdj.TeamCode = reader["TeamCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
balSheetAdj.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
}
if (reader["ProductCode"] != DBNull.Value)
{
balSheetAdj.ProductCode = reader["ProductCode"].ToString();
}
if (reader["Category"] != DBNull.Value)
{
balSheetAdj.Category = reader["Category"].ToString();
}
if (reader["CurrencyType"] != DBNull.Value)
{
balSheetAdj.CurrencyType = reader["CurrencyType"].ToString();
}
if (reader["ActualBal"] != DBNull.Value)
{
balSheetAdj.ActualBal = double.Parse(reader["ActualBal"].ToString());
}
if (reader["AverageBal"] != DBNull.Value)
{
balSheetAdj.AverageBal = double.Parse(reader["AverageBal"].ToString());
}
if (reader["Interest"] != DBNull.Value)
{
balSheetAdj.Interest = decimal.Parse(reader["Interest"].ToString());
}
if (reader["CompanyCode"] != DBNull.Value)
{
balSheetAdj.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["Code"] != DBNull.Value)
{
balSheetAdj.Code = reader["Code"].ToString();
}
if (reader["RunDate"] != DBNull.Value)
{
balSheetAdj.Rundate = DateTime.Parse(reader["RunDate"].ToString());
}
balSheetAdjs.Add(balSheetAdj);
}
con.Close();
}
return(balSheetAdjs);
}
//public List<MPRBalanceSheet> GetBalanceSheetBySearch(string searchType, string searchValue, int number)
//{
// string clientcode = ConfigurationManager.AppSettings["ClientCode"].ToString();
// if (clientcode == "CMB")
// return GetBalanceSheetBySearch_A(searchType, searchValue, number);
// else
// return GetBalanceSheetBySearch_B(searchType, searchValue, number);
//}
//public List<MPRBalanceSheet> GetBalanceSheetBySearch_A(string searchType, string searchValue, int number)
//{
// //var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
// var connectionString = MPRContext.GetDataConnection();
// var balSheets = new List<MPRBalanceSheet>();
// using (var con = new SqlConnection(connectionString))
// {
// var cmd = new SqlCommand("spp_mpr_balancesheet", con);
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
// cmd.CommandTimeout = 0;
// cmd.Parameters.Add(new SqlParameter
// {
// ParameterName = "SearchType",
// Value = searchType,
// });
// cmd.Parameters.Add(new SqlParameter
// {
// ParameterName = "SearchValue",
// Value = searchValue,
// });
// cmd.Parameters.Add(new SqlParameter
// {
// ParameterName = "Number",
// Value = number,
// });
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// var balSheet = new MPRBalanceSheet();
// if (reader["BalancesheetId"] != DBNull.Value)
// balSheet.BalanceSheetId = int.Parse(reader["BalancesheetId"].ToString());
// if (reader["AccountNo"] != DBNull.Value)
// balSheet.AccountNo = reader["AccountNo"].ToString();
// if (reader["AccountName"] != DBNull.Value)
// balSheet.AccountName = reader["AccountName"].ToString();
// if (reader["TeamCode"] != DBNull.Value)
// balSheet.TeamCode = reader["TeamCode"].ToString();
// if (reader["AccountOfficerCode"] != DBNull.Value)
// balSheet.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
// if (reader["CaptionName"] != DBNull.Value)
// balSheet.CaptionName = reader["CaptionName"].ToString();
// if (reader["BranchCode"] != DBNull.Value)
// balSheet.BranchCode = reader["BranchCode"].ToString();
// if (reader["ProductCode"] != DBNull.Value)
// balSheet.ProductCode = reader["ProductCode"].ToString();
// if (reader["Category"] != DBNull.Value)
// balSheet.Category = reader["Category"].ToString();
// if (reader["CurrencyType"] != DBNull.Value)
// balSheet.CurrencyType = reader["CurrencyType"].ToString();
// if (reader["Currency"] != DBNull.Value)
// balSheet.Currency = reader["Currency"].ToString();
// if (reader["ActualBal"] != DBNull.Value)
// balSheet.ActualBal = double.Parse(reader["ActualBal"].ToString());
// if (reader["AverageBal"] != DBNull.Value)
// balSheet.AverageBal = double.Parse(reader["AverageBal"].ToString());
// if (reader["Interest"] != DBNull.Value)
// balSheet.Interest = double.Parse(reader["Interest"].ToString());
// if (reader["EffIntRate"] != DBNull.Value)
// //balSheet.EffIntRate = double.Parse(reader["EffIntRate"].ToString());
// balSheet.EffIntRate = double.Parse(reader["EffIntRate"].ToString());
// if (reader["Pool"] != DBNull.Value)
// balSheet.Pool = double.Parse(reader["Pool"].ToString());
// if (reader["PoolRate"] != DBNull.Value)
// balSheet.PoolRate = double.Parse(reader["PoolRate"].ToString());
// if (reader["ContractRate"] != DBNull.Value)
// balSheet.ContractRate = double.Parse(reader["ContractRate"].ToString());
// if (reader["VolumeGL"] != DBNull.Value)
// balSheet.VolumeGL = reader["VolumeGL"].ToString();
// if (reader["InterestGL"] != DBNull.Value)
// balSheet.InterestGL = reader["InterestGL"].ToString();
// if (reader["EntryStatus"] != DBNull.Value)
// balSheet.EntryStatus = reader["EntryStatus"].ToString();
// if (reader["MaxRate"] != DBNull.Value)
// balSheet.MaxRate = double.Parse(reader["MaxRate"].ToString());
// if (reader["PenalCharge"] != DBNull.Value)
// balSheet.PenalCharge = decimal.Parse(reader["PenalCharge"].ToString());
// if (reader["PenalRate"] != DBNull.Value)
// balSheet.PenalRate = double.Parse(reader["PenalRate"].ToString());
// if (reader["AcctStatus"] != DBNull.Value)
// balSheet.AcctStatus = reader["AcctStatus"].ToString();
// if (reader["CreditRating"] != DBNull.Value)
// balSheet.CreditRating = reader["CreditRating"].ToString();
// if (reader["CompanyCode"] != DBNull.Value)
// balSheet.CompanyCode = reader["CompanyCode"].ToString();
// if (reader["RunDate"] != DBNull.Value)
// balSheet.Rundate = DateTime.Parse(reader["RunDate"].ToString());
// balSheets.Add(balSheet);
// }
// con.Close();
// }
// return balSheets;
//}
//public List<MPRBalanceSheet> GetBalanceSheetBySearch_B(string searchType, string searchValue, int number)
// {
// //var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
// var connectionString = MPRContext.GetDataConnection();
// var balSheets = new List<MPRBalanceSheet>();
// using (var con = new SqlConnection(connectionString))
// {
// var cmd = new SqlCommand("spp_mpr_balancesheet", con);
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
// cmd.CommandTimeout = 0;
// cmd.Parameters.Add(new SqlParameter
// {
// ParameterName = "SearchType",
// Value = searchType,
// });
// cmd.Parameters.Add(new SqlParameter
// {
// ParameterName = "SearchValue",
// Value = searchValue,
// });
// cmd.Parameters.Add(new SqlParameter
// {
// ParameterName = "Number",
// Value = number,
// });
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// var balSheet = new MPRBalanceSheet();
// if (reader["BalancesheetId"] != DBNull.Value)
// balSheet.BalanceSheetId = int.Parse(reader["BalancesheetId"].ToString());
// if (reader["AccountNo"] != DBNull.Value)
// balSheet.AccountNo = reader["AccountNo"].ToString();
// if (reader["AccountName"] != DBNull.Value)
// balSheet.AccountName = reader["AccountName"].ToString();
// if (reader["TeamCode"] != DBNull.Value)
// balSheet.TeamCode = reader["TeamCode"].ToString();
// if (reader["AccountOfficerCode"] != DBNull.Value)
// balSheet.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
// if (reader["CaptionName"] != DBNull.Value)
// balSheet.CaptionName = reader["CaptionName"].ToString();
// if (reader["BranchCode"] != DBNull.Value)
// balSheet.BranchCode = reader["BranchCode"].ToString();
// if (reader["ProductCode"] != DBNull.Value)
// balSheet.ProductCode = reader["ProductCode"].ToString();
// if (reader["Category"] != DBNull.Value)
// balSheet.Category = reader["Category"].ToString();
// if (reader["CurrencyType"] != DBNull.Value)
// balSheet.CurrencyType = reader["CurrencyType"].ToString();
// if (reader["Currency"] != DBNull.Value)
// balSheet.Currency = reader["Currency"].ToString();
// if (reader["ActualBal"] != DBNull.Value)
// balSheet.ActualBal = double.Parse(reader["ActualBal"].ToString());
// if (reader["AverageBal"] != DBNull.Value)
// balSheet.AverageBal = double.Parse(reader["AverageBal"].ToString());
// if (reader["Interest"] != DBNull.Value)
// balSheet.Interest = double.Parse(reader["Interest"].ToString());
// if (reader["EffIntRate"] != DBNull.Value)
// balSheet.EffIntRate = double.Parse(reader["EffIntRate"].ToString());
// if (reader["Pool"] != DBNull.Value)
// balSheet.Pool = double.Parse(reader["Pool"].ToString());
// if (reader["PoolRate"] != DBNull.Value)
// balSheet.PoolRate = double.Parse(reader["PoolRate"].ToString());
// if (reader["ContractRate"] != DBNull.Value)
// balSheet.ContractRate = double.Parse(reader["ContractRate"].ToString());
// if (reader["VolumeGL"] != DBNull.Value)
// balSheet.VolumeGL = reader["VolumeGL"].ToString();
// if (reader["InterestGL"] != DBNull.Value)
// balSheet.InterestGL = reader["InterestGL"].ToString();
// if (reader["EntryStatus"] != DBNull.Value)
// balSheet.EntryStatus = reader["EntryStatus"].ToString();
// if (reader["MaxRate"] != DBNull.Value)
// balSheet.MaxRate = double.Parse(reader["MaxRate"].ToString());
// if (reader["PenalCharge"] != DBNull.Value)
// balSheet.PenalCharge = decimal.Parse(reader["PenalCharge"].ToString());
// if (reader["PenalRate"] != DBNull.Value)
// balSheet.PenalRate = double.Parse(reader["PenalRate"].ToString());
// if (reader["AcctStatus"] != DBNull.Value)
// balSheet.AcctStatus = reader["AcctStatus"].ToString();
// if (reader["CreditRating"] != DBNull.Value)
// balSheet.CreditRating = reader["CreditRating"].ToString();
// if (reader["CompanyCode"] != DBNull.Value)
// balSheet.CompanyCode = reader["CompanyCode"].ToString();
// if (reader["RunDate"] != DBNull.Value)
// balSheet.Rundate = DateTime.Parse(reader["RunDate"].ToString());
// balSheets.Add(balSheet);
// }
// con.Close();
// }
// return balSheets;
// }
public List <MPRBalanceSheet> GetBalanceSheetBySearch(string searchType, string searchValue, int number)
{
//var connectionString = ConfigurationManager.ConnectionStrings["FintrakDBConnection"].ConnectionString;
var connectionString = MPRContext.GetDataConnection();
var balSheets = new List <MPRBalanceSheet>();
using (var con = new SqlConnection(connectionString))
{
var cmd = new SqlCommand("spp_mpr_balancesheet", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchType",
Value = searchType,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchValue",
Value = searchValue,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Number",
Value = number,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var balSheet = new MPRBalanceSheet();
if (reader["BalancesheetId"] != DBNull.Value)
{
balSheet.BalanceSheetId = int.Parse(reader["BalancesheetId"].ToString());
}
if (reader["AccountNo"] != DBNull.Value)
{
balSheet.AccountNo = reader["AccountNo"].ToString();
}
if (reader["AccountName"] != DBNull.Value)
{
balSheet.AccountName = reader["AccountName"].ToString();
}
if (reader["TeamCode"] != DBNull.Value)
{
balSheet.TeamCode = reader["TeamCode"].ToString();
}
if (reader["AccountOfficerCode"] != DBNull.Value)
{
balSheet.AccountOfficerCode = reader["AccountOfficerCode"].ToString();
}
if (reader["CaptionName"] != DBNull.Value)
{
balSheet.CaptionName = reader["CaptionName"].ToString();
}
if (reader["BranchCode"] != DBNull.Value)
{
balSheet.BranchCode = reader["BranchCode"].ToString();
}
if (reader["ProductCode"] != DBNull.Value)
{
balSheet.ProductCode = reader["ProductCode"].ToString();
}
if (reader["Category"] != DBNull.Value)
{
balSheet.Category = reader["Category"].ToString();
}
if (reader["CurrencyType"] != DBNull.Value)
{
balSheet.CurrencyType = reader["CurrencyType"].ToString();
}
if (reader["Currency"] != DBNull.Value)
{
balSheet.Currency = reader["Currency"].ToString();
}
if (reader["ActualBal"] != DBNull.Value)
{
//balSheet.ActualBal = decimal.Parse(reader["ActualBal"].ToString
balSheet.ActualBal = double.Parse(reader["ActualBal"].ToString());
}
if (reader["AverageBal"] != DBNull.Value)
{
//balSheet.AverageBal = decimal.Parse(reader["AverageBal"].ToString());
balSheet.AverageBal = double.Parse(reader["AverageBal"].ToString());
}
if (reader["Interest"] != DBNull.Value)
{
//balSheet.Interest = decimal.Parse(reader["Interest"].ToString());
balSheet.Interest = double.Parse(reader["Interest"].ToString());
}
if (reader["EffIntRate"] != DBNull.Value)
{
//balSheet.EffIntRate = decimal.Parse(reader["EffIntRate"].ToString());
balSheet.EffIntRate = double.Parse(reader["EffIntRate"].ToString());
}
if (reader["Pool"] != DBNull.Value)
{
//balSheet.Pool = decimal.Parse(reader["Pool"].ToString());
balSheet.Pool = double.Parse(reader["Pool"].ToString());
}
if (reader["PoolRate"] != DBNull.Value)
{
balSheet.PoolRate = double.Parse(reader["PoolRate"].ToString());
}
if (reader["ContractRate"] != DBNull.Value)
{
balSheet.ContractRate = double.Parse(reader["ContractRate"].ToString());
}
if (reader["VolumeGL"] != DBNull.Value)
{
balSheet.VolumeGL = reader["VolumeGL"].ToString();
}
if (reader["InterestGL"] != DBNull.Value)
{
balSheet.InterestGL = reader["InterestGL"].ToString();
}
if (reader["EntryStatus"] != DBNull.Value)
{
balSheet.EntryStatus = reader["EntryStatus"].ToString();
}
if (reader["MaxRate"] != DBNull.Value)
{
balSheet.MaxRate = double.Parse(reader["MaxRate"].ToString());
}
if (reader["PenalCharge"] != DBNull.Value)
{
balSheet.PenalCharge = decimal.Parse(reader["PenalCharge"].ToString());
}
if (reader["PenalRate"] != DBNull.Value)
{
balSheet.PenalRate = double.Parse(reader["PenalRate"].ToString());
}
if (reader["AcctStatus"] != DBNull.Value)
{
balSheet.AcctStatus = reader["AcctStatus"].ToString();
}
if (reader["CreditRating"] != DBNull.Value)
{
balSheet.CreditRating = reader["CreditRating"].ToString();
}
if (reader["CompanyCode"] != DBNull.Value)
{
balSheet.CompanyCode = reader["CompanyCode"].ToString();
}
if (reader["RunDate"] != DBNull.Value)
{
balSheet.Rundate = DateTime.Parse(reader["RunDate"].ToString());
}
balSheets.Add(balSheet);
}
con.Close();
}
return(balSheets);
}