public List <SalesData> getGraphData(int region_id, int chart_sales_data_type, int month_min, int month_max)
{
if (month_max > 12)
{
DataSet ds = dr.getGraphDataOnMonth(region_id, month_min);
int count = ds.Tables[0].Rows.Count;
List <SalesData> data_list = new List <SalesData>();
foreach (DataRow row in ds.Tables[0].Rows)
{
double quantity = Convert.ToDouble(row["quantity"].ToString());
DateTime date = DateTime.Parse(row["date_of_sale"].ToString());//DateTime.ParseExact(row["date_of_sale"].ToString(), "yyyy-M-d HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
double income = Convert.ToDouble(row["total_income"].ToString());
SalesData temp_sale = new SalesData(quantity, income, date);
data_list.Add(temp_sale);
}
return(data_list);
}
else if (month_max == 0)
{
DataSet ds = dr.getGraphDataAllData(region_id);
int count = ds.Tables[0].Rows.Count;
List <SalesData> data_list = new List <SalesData>();
foreach (DataRow row in ds.Tables[0].Rows)
{
double quantity = Convert.ToDouble(row["quantity"].ToString());
DateTime date = DateTime.Parse(row["date_of_sale"].ToString());//DateTime.ParseExact(row["date_of_sale"].ToString(), "yyyy-M-d HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
double income = Convert.ToDouble(row["total_income"].ToString());
SalesData temp_sale = new SalesData(quantity, income, date);
data_list.Add(temp_sale);
}
return(data_list);
}
else
{
DataSet ds = dr.getGraphDataOnRange(region_id, month_min, month_max);
int count = ds.Tables[0].Rows.Count;
List <SalesData> data_list = new List <SalesData>();
foreach (DataRow row in ds.Tables[0].Rows)
{
double quantity = Convert.ToDouble(row["quantity"].ToString());
DateTime date = DateTime.Parse(row["date_of_sale"].ToString());//DateTime.ParseExact(row["date_of_sale"].ToString(), "yyyy-M-d HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
double income = Convert.ToDouble(row["total_income"].ToString());
SalesData temp_sale = new SalesData(quantity, income, date);
data_list.Add(temp_sale);
}
return(data_list);
}
}
public List<SalesData> getGraphData(int region_id, int chart_sales_data_type, int month_min, int month_max)
{
if (month_max > 12)
{
DataSet ds = dr.getGraphDataOnMonth(region_id, month_min);
int count = ds.Tables[0].Rows.Count;
List<SalesData> data_list = new List<SalesData>();
foreach (DataRow row in ds.Tables[0].Rows)
{
double quantity = Convert.ToDouble(row["quantity"].ToString());
DateTime date = DateTime.Parse(row["date_of_sale"].ToString());//DateTime.ParseExact(row["date_of_sale"].ToString(), "yyyy-M-d HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
double income = Convert.ToDouble(row["total_income"].ToString());
SalesData temp_sale = new SalesData(quantity, income, date);
data_list.Add(temp_sale);
}
return data_list;
}
else if (month_max == 0)
{
DataSet ds = dr.getGraphDataAllData(region_id);
int count = ds.Tables[0].Rows.Count;
List<SalesData> data_list = new List<SalesData>();
foreach (DataRow row in ds.Tables[0].Rows)
{
double quantity = Convert.ToDouble(row["quantity"].ToString());
DateTime date = DateTime.Parse(row["date_of_sale"].ToString());//DateTime.ParseExact(row["date_of_sale"].ToString(), "yyyy-M-d HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
double income = Convert.ToDouble(row["total_income"].ToString());
SalesData temp_sale = new SalesData(quantity, income, date);
data_list.Add(temp_sale);
}
return data_list;
}
else
{
DataSet ds = dr.getGraphDataOnRange(region_id, month_min, month_max);
int count = ds.Tables[0].Rows.Count;
List<SalesData> data_list = new List<SalesData>();
foreach (DataRow row in ds.Tables[0].Rows)
{
double quantity = Convert.ToDouble(row["quantity"].ToString());
DateTime date = DateTime.Parse(row["date_of_sale"].ToString());//DateTime.ParseExact(row["date_of_sale"].ToString(), "yyyy-M-d HH:mm:ss,fff",System.Globalization.CultureInfo.InvariantCulture);
double income = Convert.ToDouble(row["total_income"].ToString());
SalesData temp_sale = new SalesData(quantity, income, date);
data_list.Add(temp_sale);
}
return data_list;
}
}
