public ProductivityData GetProductivityData(string year)
{
ProductivityData prod = new ProductivityData();
prod = GetData.GetProductivityData(year);
return(prod);
}
public static ProductivityData GetProductivityData(string year)
{
ProductivityData result = new ProductivityData();
var dtTotalCLS = SqlServerDA.DataTableBindDataCommand(QueryString.GetTotalCLS(year), conString);
var dtCLSRNMapWard = Helper.MapWardDataTable(dtTotalCLS);
var dtProRNPN = SqlServerDA.DataTableBindDataCommand(QueryString.GetProductivityRNPN(year), conString);
result = Helper.DataTableToProductivityData(dtCLSRNMapWard, dtProRNPN, year);
return(result);
}
public static ProductivityData DataTableToProductivityData(DataTable dtTotalCLS, DataTable dtProRNPN, string year)
{
ProductivityData proData = new ProductivityData();
List <ProductivityRNPN> proRNPNList = new List <ProductivityRNPN>();
ProductivityRNPN proRNPN = null;
List <ProductivityWard> proWardList = new List <ProductivityWard>();
ProductivityWard proWard = null;
ProductCalc proCalcRN = null;
ProductCalc proCalcPN = null;
proData.Year = year;
foreach (DataRow rowTotalCLS in dtTotalCLS.Rows)
{
proRNPN = new ProductivityRNPN();
proCalcRN = new ProductCalc();
proWard = new ProductivityWard();
proCalcPN = new ProductCalc();
string month = string.Empty;
if (month != rowTotalCLS["Month"].ToString())
{
proRNPN.Month = rowTotalCLS["Month"].ToString();
}
decimal totalCLSRN = Convert.ToDecimal(rowTotalCLS["TotalCLSRN"].ToString());
decimal totalCLSPN = Convert.ToDecimal(rowTotalCLS["TotalCLSPN"].ToString());
decimal totalNurseX7RN = 0;
decimal totalNurseX7PN = 0;
foreach (DataRow rowProRNPN in dtProRNPN.Rows)
{
proCalcRN = new ProductCalc();
proCalcPN = new ProductCalc();
if (rowTotalCLS["Month"].ToString() == rowProRNPN["Month"].ToString())
{
if (rowTotalCLS["WRD"].ToString() == rowProRNPN["GWard"].ToString())
{
proWard.Ward = rowTotalCLS["WRD"].ToString();
// RN
totalNurseX7RN = Convert.ToDecimal(rowProRNPN["TotalNurseX7RN"].ToString());
proCalcRN.TotalCLS = totalCLSRN;
proCalcRN.TotalNurse = Convert.ToDecimal(rowProRNPN["TotalNurseRN"].ToString());
proCalcRN.TotalHourNurse = totalNurseX7RN;
proCalcRN.Percent = GetPercent(totalCLSRN, totalNurseX7RN);
// PN
totalNurseX7PN = Convert.ToDecimal(rowProRNPN["TotalNursePN"].ToString());
proCalcPN.TotalCLS = totalCLSPN;
proCalcPN.TotalNurse = Convert.ToDecimal(rowProRNPN["TotalNursePN"].ToString());
proCalcPN.TotalHourNurse = totalNurseX7PN;
proCalcPN.Percent = GetPercent(totalCLSPN, totalNurseX7PN);
proWard.ProductCalcRN = proCalcRN;
proWard.ProductCalcPN = proCalcPN;
}
}
proWardList.Add(proWard);
}
proRNPNList.Add(proRNPN);
}
proData.ProductivityRNPNList = proRNPNList;
return(proData);
}
