public GRNFinishProductsCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNFinishProduct"); GRNFinishProductsCollec objGRNFinishProductsCollec = new GRNFinishProductsCollec(); for (int i = 0; i < dt.Rows.Count; i++) { GRNFinishProducts objGRNFinishProduct = new GRNFinishProducts(); objGRNFinishProduct.FinishProducts = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["FinishProductCode"])); objGRNFinishProduct.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"])); objGRNFinishProduct.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]); objGRNFinishProduct.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]); objGRNFinishProduct.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]); objGRNFinishProduct.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]); objGRNFinishProductsCollec.Add(objGRNFinishProduct); } return(objGRNFinishProductsCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnSave_Click(object sender, EventArgs e) { BasicProduct objBasic = new BasicProduct(); FinishProduct objFinishProduct = new FinishProduct(); Material objMaterial = new Material(); GRNMaterials objGRNMaterialsTemp = new GRNMaterials(); GRNBasicProducts objGRNBasicProductTemp = new GRNBasicProducts(); GRNFinishProducts objGRNFinishProductTemp = new GRNFinishProducts(); bool ItemInList = false; try { if (txtNetQty.Text.Equals("") || txtUnitCost.Text.Equals("")) { MessageBox.Show(this, "Please Fill all fields", "Empty Fields", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { bool Quantity = true; if (Quantity) { if (objGRN.GRNType == GRN.Type.Material) { if (ItemSelect) { objGRNMaterialsCollec.Delete(objGRNMaterials); } objMaterial = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); objGRNMaterialsTemp.Material = objMaterial; objGRNMaterialsTemp.GrossQty = Convert.ToDecimal(txtNetQty.Text); objGRNMaterialsTemp.NetQty = Convert.ToDecimal(txtNetQty.Text); objGRNMaterialsTemp.Remarks = txtRemarks.Text; objGRNMaterialsTemp.UnitPrice = Convert.ToDecimal(txtUnitCost.Text); foreach (GRNMaterials obj in objGRNMaterialsCollec) { if (obj.Material.MaterialCode == objMaterial.MaterialCode) { MessageBox.Show(this, "This item already added to the list, You can't add same item repeatedly to a GRN. If you want GRN same item again Please create a another GRN", "Item already Added", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemInList = true; break; } } if (!ItemInList) { objGRNMaterialsCollec.Add(objGRNMaterialsTemp); bindItemList.DataSource = objGRNMaterialsCollec; ClearItem(); } ItemInList = false; bindItemList.ResetBindings(false); } else if (objGRN.GRNType == GRN.Type.BasicProduct) { if (ItemSelect) { objGRNBasicProductCollec.Delete(objGRNBasicProduct); } objBasic = objBasicProductDL.Get(cmbItem.SelectedValue.ToString()); objGRNBasicProductTemp.GrossQty = Convert.ToDecimal(txtNetQty.Text); objGRNBasicProductTemp.BasicProduct = objBasic; objGRNBasicProductTemp.NetQty = Convert.ToDecimal(txtNetQty.Text); objGRNBasicProductTemp.Remarks = txtRemarks.Text; objGRNBasicProductTemp.UnitPrice = Convert.ToDecimal(txtUnitCost.Text); foreach (GRNBasicProducts obj in objGRNBasicProductCollec) { if (obj.BasicProduct.BasicProductCode == objBasic.BasicProductCode) { MessageBox.Show(this, "This item already added to the list, You can't add same item repeatedly to a GRN. If you want GRN same item again Please create a another GRN", "Item already Added", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemInList = true; break; } } if (!ItemInList) { objGRNBasicProductCollec.Add(objGRNBasicProductTemp); bindItemList.DataSource = objGRNBasicProductCollec; ClearItem(); } ItemInList = false; bindItemList.ResetBindings(false); } else if (objGRN.GRNType == GRN.Type.FinishProduct) { if (ItemSelect) { objGRNFinishProductCollec.Delete(objGRNFinishProduct); } objFinishProduct = objFinishProductDL.Get(cmbItem.SelectedValue.ToString()); objGRNFinishProductTemp.GrossQty = Convert.ToDecimal(txtNetQty.Text); objGRNFinishProductTemp.FinishProducts = objFinishProduct; objGRNFinishProductTemp.NetQty = Convert.ToDecimal(txtNetQty.Text); objGRNFinishProductTemp.Remarks = txtRemarks.Text; objGRNFinishProductTemp.UnitPrice = Convert.ToDecimal(txtUnitCost.Text); foreach (GRNFinishProducts obj in objGRNFinishProductCollec) { if (obj.FinishProducts.FinishProductCode == objFinishProduct.FinishProductCode) { MessageBox.Show(this, "This item already added to the list, You can't add same item repeatedly to a GRN. If you want GRN same item again Please create a another GRN", "Item already Added", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemInList = true; break; } } if (!ItemInList) { objGRNFinishProductCollec.Add(objGRNFinishProductTemp); bindItemList.DataSource = objGRNFinishProductCollec; ClearItem(); } ItemInList = false; bindItemList.ResetBindings(false); } } } } catch (FormatException fex) { MessageBox.Show(this, fex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objMaterial = null; objBasic = null; objFinishProduct = null; } }