private void PopulateStockStatus()
{
// progressBar1.Visible = true;
if (curMont != 0 && curYear != 0)
{
IssueDoc iss = new IssueDoc();
ReceiveDoc rec = new ReceiveDoc();
Balance blnc = new Balance();
DataTable dtbl = blnc.GetSOH(storeId, curMont, curYear);
DateTime lastRec = rec.GetLastReceivedDate(storeId);
DateTime lastIss = iss.GetLastIssuedDate(storeId);
//time here
TimeSpan tt = new TimeSpan();
string noDays = "";
tt = new TimeSpan(dtCurrent.Ticks - lastRec.Ticks);
noDays = (tt.TotalDays < 30000) ? tt.TotalDays.ToString() + " Days" : "Never";
lblLastReceived.Text = (tt.TotalDays < 30000) ? lastRec.ToString("MM dd,yyyy") : "Never";
lblRecDays.Text = noDays;
//progressBar1.PerformStep();
tt = new TimeSpan(dtCurrent.Ticks - lastIss.Ticks);
noDays = (tt.TotalDays < 30000) ? tt.TotalDays.ToString() + " Days" : "Never";
lblLastIssued.Text = (tt.TotalDays < 30000) ? lastIss.ToString("MM dd,yyyy") : "Never";
lblIssuedDays.Text = noDays;
DataTable dtStockout = (from m in dtbl.AsEnumerable()
where m["Status"].ToString() == "Normal"
&& ((ckExclude.Checked == true)? Convert.ToInt32(m["EverReceived"]) == 1 : true)
select m).CopyToDataTable();
//StatusGroup.Text = "Stocked In Items";
PopulateList(dtStockout, listStatused);
DataTable dtFreeStockOut = (from m in dtbl.AsEnumerable()
where m["Status"].ToString() == "Stock Out"
&& ((ckExclude.Checked == true) ? Convert.ToInt32(m["EverReceived"]) == 1 : true)
select m).CopyToDataTable();
//groupStatusTrend.Text = "Stocked out Free Items ";
PopulateList(dtFreeStockOut, listStatused);
DataTable dtRec = rec.GetTopReceivedItems(storeId);
// groupRecSummary.Text = "Top 10 Most Received Items";
PopulateList(dtRec, listReceiveSum);
lblNeverRecived.Text = rec.CountNeverReceivedItems(storeId).ToString();
if (rec.CountNeverReceivedItems(storeId) == 0)
{
linkLabel10.Visible = false;
}
else
{
linkLabel10.Visible = true;
}
lblNeverIssued.Text = rec.CountReceivedNotIssuedItems(storeId).ToString();
if (rec.CountReceivedNotIssuedItems(storeId) == 0)
{
linkLabel21.Visible = false;
}
else
{
linkLabel21.Visible = true;
}
// progressBar1.PerformStep();
DataTable dtIss = iss.GetTopIssuedItems(storeId);
// groupIssued.Text = "Top 10 Most Issued Items";
PopulateList(dtIss, listIssued);
//Balance bal = new Balance();
GeneralInfo info = new GeneralInfo();
info.LoadAll();
DataTable dtList = new DataTable();
DataTable dtCons = new DataTable();
string[] co = { "Ham", "Neh", "Mes", "Tek", "Hed", "Tah", "Tir", "Yek", "Meg", "Miz", "Gen", "Sen" };
//foreach(string s in co)
//{
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();
//time here
int year = dtCurrent.Year;
chartReceiveCost.Series.Clear();
Series ser = new Series("Received Cost In Birr", ViewType.Line);
ser.DataSource = dtList;
ser.ArgumentScaleType = ScaleType.Qualitative;
ser.ArgumentDataMember = "Month";
ser.ValueScaleType = ScaleType.Numerical;
ser.ValueDataMembers.AddRange(new string[] { "Value" });
chartReceiveCost.Series.Add(ser);
chartIssueCost.Series.Clear();
Series serIss = new Series("Issued Cost In Birr", ViewType.Line);
serIss.DataSource = dtCons;
serIss.ArgumentScaleType = ScaleType.Qualitative;
serIss.ArgumentDataMember = "Month";
serIss.ValueScaleType = ScaleType.Numerical;
serIss.ValueDataMembers.AddRange(new string[] { "Value" });
chartIssueCost.Series.Add(serIss);
}
}