private void linkLabel17_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
IssueDoc iss = new IssueDoc();
DataTable dtIss = iss.GetTopIssuedItemsByCategoryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue));
//groupIssued.Text = "Top 10 Most Issued Items";
PopulateList(dtIss, listIssued);
}
private void PopulateStockStatusByYearForAllStore()
{
// progressBar1.Visible = true;
if (curMont != 0 && curYear != 0)
{
IssueDoc iss = new IssueDoc();
ReceiveDoc rec = new ReceiveDoc();
Balance blnc = new Balance();
DataTable dtbl = blnc.GetSOHForAllStores(curMont, curYear);
DateTime lastRec = rec.GetLastReceivedDateByCategoryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue));
DateTime lastIss = iss.GetLastIssuedDateByCategoryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue));
//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 dtAllItems;
try
{
dtAllItems = (from m in dtbl.AsEnumerable()
where ((ckExclude.Checked == true) ? Convert.ToInt32(m["EverReceived"]) == 1 : true)
select m).CopyToDataTable();
}
catch (InvalidOperationException)
{
dtAllItems = null;
}
PopulateList(dtAllItems, listStatused);
DataTable dtRec = rec.GetTopReceivedItemsByCategoryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue));
// groupRecSummary.Text = "Top 10 Most Received Items";
PopulateList(dtRec, listReceiveSum);
lblNeverRecived.Text = rec.CountNeverReceivedItemsByCateogryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue)).ToString();
if (rec.CountNeverReceivedItems(storeId) == 0)
{
linkLabel10.Visible = false;
}
else
{
linkLabel10.Visible = true;
}
lblNeverIssued.Text = rec.CountReceivedNotIssuedItemsByCategoryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue)).ToString();
if (lblNeverIssued.Text == "0")
{
linkLabel21.Visible = false;
}
else
{
linkLabel21.Visible = true;
}
// progressBar1.PerformStep();
DataTable dtIss = iss.GetTopIssuedItemsByCategoryAndYear(storeId, Convert.ToInt32(lkCategory.EditValue), Convert.ToInt32(cboYear.EditValue));
// 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);
}
}