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