public Chart ImportMoney(DateTime Start, DateTime End, DateStatistics format)
{
Chart chart = new Chart();
if (DateTime.Compare(Start, End) == 1)
{
return(chart);
}
if (format == DateStatistics.THANG)
{
TimeSpan timespan = End - Start;
int monthCount = timespan.Days / 30 + 1;
DateTime time = Start;
int Pmonth;
chart.NameChart = "Thống kê tiền nhập thuốc theo tháng";
chart.NameX = "tháng";
chart.NameY = "doanh thu / VNĐ";
chart.ColumnCount = monthCount;
chart.Counting = 0;
ControllerInputCoupon ctr = new ControllerInputCoupon();
DataTable dt = ctr.SearchMonth(Start.Month, End.Month);
chart.ListColumn = new List <column>(monthCount);
for (int i = 0; i < monthCount; i++)
{
column cl;
cl.value = 0;
cl.percent = 0;
time = time.AddMonths(i);
cl.name = time.Month + "/" + time.Year;
chart.ListColumn.Add(cl);
}
long maxValue = 0;
for (int i = 0; i < monthCount; i++)
{
time = time.AddMonths(i);
Pmonth = time.Month;
column cl = chart.listColumn[i];
foreach (DataRow row in dt.Rows)
{
DateTime createDate; try { createDate = Convert.ToDateTime(row["createDate"].ToString()); } catch { continue; }
if (createDate.Month == Pmonth)
{
long v; try { v = Convert.ToInt64(row["totalMoney"].ToString()); } catch { v = 0; }
cl.value += v;
++chart.Counting;
}
}
chart.listColumn[i] = cl;
if (cl.value > maxValue)
{
maxValue = cl.value;
}
}
if (maxValue != 0)
{
for (int i = 0; i < monthCount; i++)
{
column cl = chart.listColumn[i];
cl.percent = cl.value / maxValue;
chart.listColumn[i] = cl;
}
}
}
if (format == DateStatistics.NGAY)
{
TimeSpan timespan = End - Start;
int dayCount = timespan.Days + 1;
DateTime time = Start;
int Pday;
chart.NameChart = "Thống kê tiền nhập thuốc theo ngày";
chart.NameX = "tháng";
chart.NameY = "doanh thu / VNĐ";
chart.ColumnCount = dayCount;
chart.Counting = 0;
ControllerInputCoupon ctr = new ControllerInputCoupon();
DataTable dt = ctr.SearchDay(Start.Day, End.Day);
chart.ListColumn = new List <column>(dayCount);
for (int i = 0; i < dayCount; i++)
{
column cl;
cl.value = 0;
cl.percent = 0;
time = time.AddDays(i);
cl.name = time.Day + "/" + time.Month + "/" + time.Year;
chart.ListColumn.Add(cl);
}
long maxValue = 0;
for (int i = 0; i < dayCount; i++)
{
time = time.AddDays(i);
Pday = time.Day;
column cl = chart.listColumn[i];
foreach (DataRow row in dt.Rows)
{
DateTime createDate; try { createDate = Convert.ToDateTime(row["createDate"].ToString()); } catch { continue; }
if (createDate.Day == Pday)
{
long v; try { v = Convert.ToInt64(row["totalMoney"].ToString()); } catch { v = 0; }
cl.value += v;
++chart.Counting;
}
}
chart.listColumn[i] = cl;
if (cl.value > maxValue)
{
maxValue = cl.value;
}
}
if (maxValue != 0)
{
for (int i = 0; i < dayCount; i++)
{
column cl = chart.listColumn[i];
cl.percent = cl.value / maxValue;
chart.listColumn[i] = cl;
}
}
}
if (format == DateStatistics.NAM)
{
TimeSpan timespan = End - Start;
int namCount = timespan.Days / 365 + 1;
DateTime time = Start;
int Pyear;
chart.NameChart = "Thống kê doanh thu theo năm";
chart.NameX = "năm";
chart.NameY = "doanh thu / VNĐ";
chart.ColumnCount = namCount;
chart.Counting = 0;
ControllerInputCoupon ctr = new ControllerInputCoupon();
DataTable dt = ctr.SearchYear(Start.Year, End.Year);
chart.ListColumn = new List <column>(namCount);
for (int i = 0; i < namCount; i++)
{
column cl;
cl.value = 0;
cl.percent = 0;
time = time.AddYears(i);
cl.name = "" + time.Year;
chart.ListColumn.Add(cl);
}
long maxValue = 0;
for (int i = 0; i < namCount; i++)
{
time = time.AddMonths(i);
Pyear = time.Year;
column cl = chart.listColumn[i];
foreach (DataRow row in dt.Rows)
{
DateTime createDate; try { createDate = Convert.ToDateTime(row["createDate"].ToString()); } catch { continue; }
if (createDate.Year == Pyear)
{
long v; try { v = Convert.ToInt64(row["totalMoney"].ToString()); } catch { v = 0; }
cl.value += v;
++chart.Counting;
}
}
chart.listColumn[i] = cl;
if (cl.value > maxValue)
{
maxValue = cl.value;
}
}
if (maxValue != 0)
{
for (int i = 0; i < namCount; i++)
{
column cl = chart.listColumn[i];
cl.percent = cl.value / maxValue;
chart.listColumn[i] = cl;
}
}
}
return(chart);
}