public ActionResult SearchColumnsChartCompareForMonth([DataSourceRequest] DataSourceRequest request, int month, int year, string reportTypeID)
{
List <ReportForTotalPayment> listData = new ReportBL().DataReportTPCompareForMonth(year, month, reportTypeID);
GradationCompare[] arrayGradation = null;
if (listData.Count.Equals(3))
{
arrayGradation = new GradationCompare[3];
int count = 0;
foreach (ReportForTotalPayment item in listData)
{
// Tạo mảng insert dữ liệu để vẽ biểu đồ cột
arrayGradation[count] = new GradationCompare()
{
NameGradationCompare = string.Format("Tháng {0}/{1}", item.Month, item.Year),
amount = item.Payed,
NameType = string.Format("Tháng {0}/{1}", item.Month, item.Year)
};
count++;
}
}
else
{
arrayGradation = new GradationCompare[1];
arrayGradation[0] = new GradationCompare()
{
NameGradationCompare = "1",
NameType = ""
};
}
return(Json(arrayGradation));
}
public ActionResult ColumnsChartGradationCompare(string reportTypeID)
{
// typeID trong sql
int typeID = 1;
int toYear = DateTime.Today.Year;
List <ReportForTotalPayment> listData = new ReportBL().DataReportTPForGradationCompare(toYear, typeID, reportTypeID);
GradationCompare[] arrayGradation = null;
if (listData.Count.Equals(2))
{
arrayGradation = new GradationCompare[2];
int count = 0;
foreach (ReportForTotalPayment item in listData)
{
// Tạo mảng insert dữ liệu để vẽ biểu đồ cột
arrayGradation[count] = new GradationCompare()
{
NameGradationCompare = string.Concat("Lũy thừa 3 tháng năm ", item.Year),
amount = item.Payed,
NameType = string.Concat("Lũy thừa 3 tháng năm ", item.Year)
};
count++;
}
}
else
{
arrayGradation = new GradationCompare[1];
arrayGradation[0] = new GradationCompare()
{
NameGradationCompare = "1",
NameType = ""
};
}
return(Json(arrayGradation));
}
public ActionResult SearchLineChartTotalPaymentReportForYear([DataSourceRequest] DataSourceRequest request, DateTime fromDate, DateTime toDate, string reportTypeID)
{
List <ReportForTotalPayment> listData = new ReportBL().SearchReportTPForYear(fromDate, toDate, reportTypeID);
GradationCompare[] arrayGradation = null;
if (listData.Count > 0)
{
int countList = listData.Count;
arrayGradation = new GradationCompare[countList];
int count = 0;
foreach (ReportForTotalPayment item in listData)
{
// Tạo mảng insert dữ liệu để vẽ biểu đồ cột
arrayGradation[count] = new GradationCompare()
{
NameGradationCompare = item.Year,
amount = item.Payed,
NameType = string.Concat("Tháng ", item.Month)
};
count++;
}
}
else
{
arrayGradation = new GradationCompare[1];
arrayGradation[0] = new GradationCompare()
{
NameGradationCompare = "1",
NameType = ""
};
}
return(Json(arrayGradation));
}
public ActionResult SearchColumnChartMaketReportForGradation([DataSourceRequest] DataSourceRequest request, int gradation, int year, string reportTypeID)
{
//string typeID = "1";
List <ReportForTotalPayment> listData = new ReportBL().DataReportTPForGradationCompare(year, gradation, reportTypeID);
GradationCompare[] arrayGradation = null;
string text = " tháng đầu năm ";
switch (gradation)
{
case 1:
text = string.Concat("3", text);
break;
case 2:
text = string.Concat("6", text);
break;
case 3:
text = string.Concat("9", text);
break;
default:
text = string.Concat("12", text);
break;
}
if (listData.Count.Equals(2))
{
arrayGradation = new GradationCompare[2];
int count = 0;
foreach (ReportForTotalPayment item in listData)
{
// Tạo mảng insert dữ liệu để vẽ biểu đồ cột
arrayGradation[count] = new GradationCompare()
{
NameGradationCompare = string.Format("Lũy thừa {0} {1}", text, item.Year),
amount = item.Payed,
NameType = string.Format("Lũy thừa {0} {1}", text, item.Year)
};
count++;
}
}
else
{
arrayGradation = new GradationCompare[1];
arrayGradation[0] = new GradationCompare()
{
NameGradationCompare = "1",
NameType = ""
};
}
return(Json(arrayGradation));
}
