private void GenerateDataTableToList(DataSet aDataSet)
{
foreach (DataRow aRow in aDataSet.Tables[0].Rows)
{
var aData = new BusinessplanData
{
BusinessName = aRow["BPName"].ToString() == "" ? "0" : aRow["BPName"].ToString(),
Month1 = aRow["Month1"].ToString() == "" ? "0" : aRow["Month1"].ToString(),
Month2 = aRow["Month2"].ToString() == "" ? "0" : aRow["Month2"].ToString(),
Month3 = aRow["Month3"].ToString() == "" ? "0" : aRow["Month3"].ToString(),
Month4 = aRow["Month4"].ToString() == "" ? "0" : aRow["Month4"].ToString(),
Month5 = aRow["Month5"].ToString() == "" ? "0" : aRow["Month5"].ToString(),
Month6 = aRow["Month6"].ToString() == "" ? "0" : aRow["Month6"].ToString(),
Month7 = aRow["Month7"].ToString() == "" ? "0" : aRow["Month7"].ToString(),
Month8 = aRow["Month8"].ToString() == "" ? "0" : aRow["Month8"].ToString(),
Month9 = aRow["Month9"].ToString() == "" ? "0" : aRow["Month9"].ToString(),
Month10 = aRow["Month10"].ToString() == "" ? "0" : aRow["Month10"].ToString(),
Month11 = aRow["Month11"].ToString() == "" ? "0" : aRow["Month11"].ToString(),
Month12 = aRow["Month12"].ToString() == "" ? "0" : aRow["Month12"].ToString()
};
_aBusinessplanData.Add(aData);
}
}
public DataTable GetAll(string companyCode, string fromDate, string toDate)
{
return(BusinessplanData.GetLineKpiDataTable(DbConnection.ConnectionString, companyCode, fromDate, toDate));
}
