protected override void OnAppearing()
{
decimal TotalQnty, TotalAmount = 0;
base.OnAppearing();
DataTable dt = ADO_Manager.GetADO_ReqDetails(CompanyName, DocNo);
var doDetailList = ADODM.ADO_DetailList(dt);
if (dt.Rows.Count > 0)
{
TotalQnty = decimal.Parse(dt.Compute("Sum(Quantity)", "").ToString());
TotalAmount = decimal.Parse(dt.Compute("Sum(TotalAmount)", "").ToString());
lblTotalAmount.Text = "Total qty: " + TotalQnty.ToString("0.00") + " Amount: " + TotalAmount.ToString("0.00");
lblADOReqNo.Text = dt.Rows[0]["AdvNO"].ToString();
}
foreach (var item in doDetailList)
{
items.Add(item);
}
ADOReq_DetailList.ItemsSource = items;
}
private void GetDataByUser()
{
DataTable dt = ADO_Manager.GetAllUnApprovedAdvReqByUser(getUserName);
var DODetaillist = ADODM.ADO_DetailList(dt);
foreach (var item in DODetaillist)
{
items.Add(item);
}
}