private void RefreshBatchList() { try { _batchcollection = new AutoCompleteStringCollection(); if (m_LocationID > 0 && m_ItemID > 0) { string errorMessage = string.Empty; CIBatchDetail batch = new CIBatchDetail(); List <CIBatchDetail> Lists = batch.GetBatchDetail(string.Empty, m_ItemID, m_LocationID, ref errorMessage); if (Lists != null) { for (int j = 0; j < Lists.Count; j++) { _batchcollection.Add(Lists[j].BatchNo); } } } txtBatchNo.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txtBatchNo.AutoCompleteSource = AutoCompleteSource.CustomSource; txtBatchNo.AutoCompleteCustomSource = _batchcollection; } catch (Exception ex) { throw ex; } }
private void ResetForm() { try { m_Order = new CO(); m_Order.GetCOAllDetails(OrderNo, (int)Common.OrderStatus.Confirmed); if (m_Order != null && !string.IsNullOrEmpty(m_Order.CustomerOrderNo)) { CODetailList = m_Order.CODetailList; dgvCOItemDetails.DataSource = CODetailList; SetHeaderValue(); //RefreshItemList(); // Get Grid View data string errorMessage = string.Empty; ListBatch = CIBatchDetail.GetDefaultBatch(OrderNo, m_LocationID, ref errorMessage); SetGridView(); dgvCOItemDetails.ClearSelection(); dgvInvoiceDetail.ClearSelection(); } else { // Co Detail not Found ErrorCode = "40009"; } } catch (Exception ex) { throw ex; } }
private void AddBatch() { try { bool toadd = true; var q1 = from q in ListBatch where q.ItemId == m_CurrentBatch.ItemId && q.RecordNo == m_CurrentBatch.RecordNo && q.BatchNo == txtBatchNo.Text.Trim() select q; if (q1 != null && q1.ToList().Count > 0) { m_CurrentBatch = (CIBatchDetail)q1.ToList()[0]; toadd = false; } m_CurrentBatch.CreatedBy = m_UserID; m_CurrentBatch.Quantity = Convert.ToDecimal(txtInvoiceQty.Text.Trim()); if (toadd) { ListBatch.Add(m_CurrentBatch); } SetGridView(); ClearDetails(); } catch (Exception ex) { throw ex; } }
private decimal GetAvailableQty(CIBatchDetail batch) { if (batch.AvailableQty > 0) { decimal usedQty = 0; var query = from q in ListBatch where q.ItemId == m_CurrentBatch.ItemId && q.RecordNo != m_CurrentBatch.RecordNo select q.Quantity; if (query != null && query.ToList().Count > 0) { usedQty = query.Sum(); } batch.AvailableQty = batch.AvailableQty; //- usedQty; } return(batch.AvailableQty); }
private CIBatchDetail CreateBatchObject(CODetail ODetail) { try { CIBatchDetail batch = new CIBatchDetail(); batch.ItemCode = ODetail.ItemCode; batch.ItemId = ODetail.ItemId; batch.TotalQuantity = ODetail.Qty; return(batch); } catch (Exception ex) { throw ex; } }
private void txtBatchNo_Validating(object sender, CancelEventArgs e) { try { // m_ItemID = m_CurrentBatch.ItemId; m_CurrentBatch = new CIBatchDetail(); string errorMessage = string.Empty; if (txtBatchNo.Text.Trim().Equals(string.Empty)) { return; } List <CIBatchDetail> List = m_CurrentBatch.GetBatchDetail(txtBatchNo.Text.Trim(), m_ItemID, m_LocationID, ref errorMessage); if (List != null && List.Count > 0 && errorMessage.Trim().Equals(string.Empty)) { m_CurrentBatch = List[0]; m_CurrentBatch.ItemId = m_ItemID; m_CurrentBatch.ItemCode = m_itemCode; m_CurrentBatch.RecordNo = m_Recordno; m_CurrentBatch.TotalQuantity = m_TotalQty; m_CurrentBatch.AvailableQty = GetAvailableQty(m_CurrentBatch); } else { m_CurrentBatch.BatchNo = txtBatchNo.Text.Trim(); } // m_CurrentBatch.ItemCode = txtItemCode.Text.Trim(); m_CurrentBatch.Quantity = txtInvoiceQty.Text.Trim() == string.Empty?0:Convert.ToDecimal(txtInvoiceQty.Text.Trim()); SetBatchDetails(); } catch (Exception ex) { MessageBox.Show(Common.GetMessage("10002"), Common.GetMessage("30007"), MessageBoxButtons.OK, MessageBoxIcon.Error); Common.LogException(ex); } }