/// <summary> /// Calcs the total RPL qty. /// </summary> private void CalcTotalRplQty() { decimal totalQty = 0; string query = "HeaderId = '" + this.HeaderId.ToString() + "'"; InvtBatchRPL_DetailsCollection oDetailList = InvtBatchRPL_Details.LoadCollection(query); foreach (InvtBatchRPL_Details oDetail in oDetailList) { totalQty += oDetail.QtyRequested; } txtTotalReplenishQty.Text = totalQty.ToString("n0"); }
/// <summary> /// Saves the detail info. /// </summary> private void SaveDetailInfo() { for (int i = 0; i < listView.Items.Count; i++) { ListViewItem oItem = listView.Items[i]; if (!oItem.SubItems[1].Text.Contains("D")) { string query = "STKCODE = '" + oItem.SubItems[2].Text + "' AND APPENDIX1 = '" + oItem.SubItems[3].Text + @"' AND APPENDIX2 = '" + oItem.SubItems[4].Text + "' AND APPENDIX3 = '" + oItem.SubItems[5].Text + "'"; Product oProduct = Product.LoadWhere(query); if (oProduct != null) { productId = oProduct.ProductId; query = "ProductId = '" + productId.ToString() + "' AND DetailsId = '" + oItem.SubItems[0].Text + "'"; InvtBatchRPL_Details oDetail = InvtBatchRPL_Details.LoadWhere(query); if (oDetail == null) { oDetail = new InvtBatchRPL_Details(); oDetail.HeaderId = this.HeaderId; oDetail.TxNumber = txNumber; oDetail.LineNumber = i + 1; oDetail.ProductId = productId; } oDetail.QtyRequested = Convert.ToDecimal(oItem.SubItems[8].Text); oDetail.Save(); } } else { if (RT2020.DAL.Common.Utility.IsGUID(oItem.SubItems[0].Text)) { InvtBatchRPL_Details oDetail = InvtBatchRPL_Details.Load(new Guid(oItem.SubItems[0].Text)); if (oDetail != null) { oDetail.Delete(); } } } } }
/// <summary> /// Saves this instance. /// </summary> private void Save(bool bConfirmed) { string sheaderid = string.Empty; for (int i = 0; i < dgvConfirmationList.Rows.Count; i++) { DataGridViewRow oRow = dgvConfirmationList.Rows[i]; if (RT2020.DAL.Common.Utility.IsGUID(oRow.Cells[0].Value.ToString())) { System.Guid detailId = new Guid(oRow.Cells[0].Value.ToString()); InvtBatchRPL_Details oDetail = InvtBatchRPL_Details.Load(detailId); if (oDetail != null) { oDetail.QtyIssued = Convert.ToDecimal(oRow.Cells[9].Value); oDetail.Save(); } } } InvtBatchRPL_Header oHeader = InvtBatchRPL_Header.Load(this.HeaderId); if (oHeader != null) { if (bConfirmed) { oHeader.Confirmed = true; oHeader.ConfirmedBy = Common.Utility.CurrentUserId; oHeader.ConfirmedOn = DateTime.Now; } oHeader.ModifiedBy = Common.Utility.CurrentUserId; oHeader.ModifiedOn = DateTime.Now; oHeader.Save(); } }