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