public static DataTable GetDataByPeriodAndClientID(HttpContextBase context, int year, int month, int clientId)
{
BillingTableType btt = BillingTablesBL.GetToolByOrgBillingTableType(new DateTime(year, month, 1));
DataTable dtSource = BillingTablesBL.GetMultipleTables(context, year, month, clientId, btt);
if (!dtSource.Columns.Contains("UsageFeeDisplay"))
{
dtSource.Columns.Add("UsageFeeDisplay", typeof(double));
}
if (!dtSource.Columns.Contains("TotalCharge"))
{
dtSource.Columns.Add("TotalCharge", typeof(double));
}
if (!dtSource.Columns.Contains("SubsidyDiscount"))
{
dtSource.Columns.Add("SubsidyDiscount", typeof(double));
}
if (!dtSource.Columns.Contains("TransferredFee"))
{
dtSource.Columns.Add("TransferredFee", typeof(double));
}
if (!dtSource.Columns.Contains("ForgivenFee"))
{
dtSource.Columns.Add("ForgivenFee", typeof(double));
}
foreach (DataRow dr in dtSource.Rows)
{
int billingTypeId = dr.Field <int>("BillingTypeID");
if (billingTypeId == BillingTypes.Grower_Observer)
{
dr["UsageFeeDisplay"] = dr["UsageFeeCharged"];
}
else if (billingTypeId == BillingTypes.Other)
{
dr["ToolCharge"] = 0;
dr["TotalUsageCharge"] = dr["ToolMisc"];
}
else
{
dr["UsageFeeDisplay"] = dr.Field <decimal>("UsageFeeCharged") + dr.Field <decimal>("TransferredFee") + dr.Field <decimal>("ForgivenFee");
}
dr["SubsidyDiscount"] = dr.Field <decimal>("SubsidyDiscount") + dr.Field <decimal>("ToolMiscSubsidyDiscount");
dr["TotalCharge"] = dr.Field <decimal>("TotalUsageCharge") - dr.Field <decimal>("SubsidyDiscount");
}
return(dtSource);
}
public static DataTable GetDataByPeriodAndClientID20110401(HttpContextBase context, int year, int month, int clientId)
{
BillingTableType bt = BillingTablesBL.GetToolByOrgBillingTableType(new DateTime(year, month, 1));
DataTable dtSource = BillingTablesBL.GetMultipleTables(context, year, month, clientId, bt);
foreach (DataRow dr in dtSource.Rows)
{
int billingTypeId = dr.Field <int>("BillingTypeID");
if (billingTypeId == BillingTypes.Other)
{
dr["ToolCharge"] = 0;
dr["TotalUsageCharge"] = dr["ToolMisc"];
}
}
return(dtSource);
}
public static DataTable GetMultipleTables(HttpContextBase context, int year, int month, int clientId, BillingTableType bt)
{
DataSet ds = GetDataSet(context, year, month, clientId);
return(ds.Tables[(int)bt]);
}
public static BillingTableType GetToolByAccountBillingTableType(DateTime period)
{
BillingTableType result = (period < CutoffPeriod) ? BillingTableType.ToolByAccount : BillingTableType.ToolByAccount20110401;
return(result);
}
