private void GeneratCostChartForAllStores()
{
DataTable dtList = new DataTable();
DataTable dtCons = new DataTable();
string[] co = { "Ham", "Neh", "Mes", "Tek", "Hed", "Tah", "Tir", "Yek", "Meg", "Miz", "Gen", "Sen" };
dtList.Columns.Add("Month");
dtList.Columns.Add("Value");
dtList.Columns[1].DataType = typeof(Int64);
dtCons.Columns.Add("Month");
dtCons.Columns.Add("Value");
dtCons.Columns[1].DataType = typeof(Int64);
int[] mon = { 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
double[] cos = new double[12];
DataTable dtBal = new DataTable();
Items recd = new Items();
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
int year = (dtCurrent.Month < 11) ? dtCurrent.Year : dtCurrent.Year + 1;
int selectedYear = Convert.ToInt32(cboYear.EditValue);
for (int i = 0; i < mon.Length; i++)
{
if (selectedYear == dtCurrent.Year)
{
if (((mon[i] == 11 || mon[i] == 12) && (mon[i] <= dtCurrent.Month || year == dtCurrent.Year)) || (mon[i] < 11 && mon[i] <= dtCurrent.Month && year == dtCurrent.Year))
{
int yr = (mon[i] < 11) ? dtCurrent.Year : year;
double recVal = recd.GetCostReceiveByItemPerMonthForAllStores(mon[i], yr);
object[] objrec = { co[i], recVal };
double issVal = recd.GetCostIssuedByItemPerMonthForAllStores(mon[i], yr);
object[] objiss = { co[i], issVal };
dtList.Rows.Add(objrec);
dtCons.Rows.Add(objiss);
}
}
else
{
int yr = (mon[i] < 11) ? selectedYear : selectedYear - 1 ;
double recVal = recd.GetCostReceiveByItemPerMonthForAllStores(mon[i], yr);
object[] objrec = { co[i], recVal };
double issVal = recd.GetCostIssuedByItemPerMonthForAllStores(mon[i], yr);
object[] objiss = { co[i], issVal };
dtList.Rows.Add(objrec);
dtCons.Rows.Add(objiss);
}
}
chartReceiveCost.Series.Clear();
Series ser = new Series("Received Cost In Birr", ViewType.Line) { DataSource = dtList, ArgumentScaleType = ScaleType.Qualitative, ArgumentDataMember = "Month", ValueScaleType = ScaleType.Numerical };
ser.ValueDataMembers.AddRange(new string[] { "Value" });
ser.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
// ser.PointOptions.ValueNumericOptions.Precision = 1;
chartReceiveCost.Series.Add(ser);
Series serIss = new Series("Issued Cost In Birr", ViewType.Line) { DataSource = dtCons, ArgumentScaleType = ScaleType.Qualitative, ArgumentDataMember = "Month", ValueScaleType = ScaleType.Numerical };
serIss.ValueDataMembers.AddRange(new string[] { "Value" });
serIss.PointOptions.ValueNumericOptions.Format = NumericFormat.Number;
//serIss.PointOptions.ValueNumericOptions.Precision = 1;
chartReceiveCost.Series.Add(serIss);
((XYDiagram)chartReceiveCost.Diagram).AxisY.NumericOptions.Format = NumericFormat.Number;
((XYDiagram)chartReceiveCost.Diagram).AxisY.NumericOptions.Precision = 0;
}