private void GetDataByUser() { DataTable dt = AltDO_Manager.GetAltDelRequestToApprove(getUserName); var DODetaillist = ADODM.Alt_DODetailList(dt); foreach (var item in DODetaillist) { items.Add(item); } }
protected override void OnAppearing() { decimal TotalQnty, TotalAmount = 0; base.OnAppearing(); DataTable dt = AltDO_Manager.GetUnApprovedAdvAlternateReq(CompanyName, DocNo, LCNo); var Alt_doDetailList = Alt_DODM.Alt_DODetailList(dt); if (dt.Rows.Count > 0) { TotalQnty = decimal.Parse(dt.Compute("Sum(Quantity)", "").ToString()); TotalAmount = decimal.Parse(dt.Compute("Sum(Amount)", "").ToString()); lblTotalAmount.Text = "Total qty: " + TotalQnty.ToString("0.00") + " Amount: " + TotalAmount.ToString("0.00"); lblAlt_DOReqNo.Text = DocNo; } foreach (var item in Alt_doDetailList) { items.Add(item); } Alt_DOReqlist.ItemsSource = items; }