protected void Page_Load(object sender, EventArgs e)
{
LastADEntities entities = new LastADEntities();
var c = entities.AdjVouchers.Where(p => p.Status == "PendingDHAuthorisation")
.Join(entities.ItemLists, m => m.ItemId, f => f.ItemId,
(m, f) => new {
AdjVoucherId = m.AdjVoucherId,
Datechecked = m.SubmitDate,
ItemId = m.ItemId,
Item = f.Description,
QuantityAdjusted = m.QuantityAdj,
Reason = m.Reason
})
.ToList();
DataTable dt = new DataTable();
if (dt.Columns.Count == 0)
{
dt.Columns.Add("AdjVoucherId", typeof(int));
dt.Columns.Add("DateChecked", typeof(DateTime));
dt.Columns.Add("Item", typeof(string));
dt.Columns.Add("QuantityAdjusted", typeof(int));
dt.Columns.Add("Cost", typeof(decimal));
dt.Columns.Add("Reason", typeof(string));
}
for (int i = 0; i < c.Count(); i++)
{
DataRow NewRow = dt.NewRow();
NewRow[0] = c[i].AdjVoucherId;
NewRow[1] = c[i].Datechecked.Value.Date;
NewRow[2] = c[i].Item;
NewRow[3] = c[i].QuantityAdjusted;
decimal Cost = Math.Round((decimal)(Business.Findavgitempricebyid(c[i].ItemId) * c[i].QuantityAdjusted), 2);
NewRow[4] = Cost;
NewRow[5] = c[i].Reason;
dt.Rows.Add(NewRow);
}
GridView2.DataSource = dt;
GridView2.DataBind();
}
