private void gvItemList_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex >= 0) { if (cmbMRType.SelectedItem.Equals("Material")) { objMRMaterial = (MRMaterial)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRMaterial.Description; txtQty.Text = objMRMaterial.ReqdQty.ToString(); cmbItem.SelectedValue = objMRMaterial.Material.MaterialCode; } else if (cmbMRType.SelectedItem.Equals("Basic Products")) { objMRBasicProduct = (MRBasicProduct)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRBasicProduct.Description; txtQty.Text = objMRBasicProduct.ReqdQty.ToString(); cmbItem.SelectedValue = objMRBasicProduct.BasicProduct.BasicProductCode; } else if (cmbMRType.SelectedItem.Equals("Finish Products")) { objMRFinishProduct = (MRFinishProduct)gvItemList.Rows[e.RowIndex].DataBoundItem; txtDescription.Text = objMRFinishProduct.Description; txtQty.Text = objMRFinishProduct.ReqdQty.ToString(); cmbItem.SelectedItem = objMRFinishProduct.FinishProduct.FinishProductCode; } ItemSelect = true; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public int Issue(MRFinishProduct obj, String StoreID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRItemCode", obj.FinishProduct.FinishProductCode), new SqlParameter("@StoreID", StoreID), new SqlParameter("@MRIssuedQty", obj.IssuedQty) }; return(Execute.RunSP_Int(Connection, "SPUPDATE_MRFinishProduct_Issue", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MRFinishProductCollec Get(long MRNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProducts_ByMRNO", paramList); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); for (int i = 0; i < dt.Rows.Count; i++) { MRFinishProduct objMRFinishProduct = new MRFinishProduct(); objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRFinishProductID"])); objMRFinishProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]); objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRNO"])); objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRBINNo"]); objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["ReqdQty"]); objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["IssuedQty"]); objMRFinishProduct.UnitCode = "Nos"; if (dt.Rows[i]["MRUnitRate"] != DBNull.Value) { objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRUnitRate"]); } else { objMRFinishProduct.UniRate = 0; } objMRFinishProductCollec.Add(objMRFinishProduct); } return(objMRFinishProductCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(MRFinishProduct obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRFinishProductID", obj.FinishProduct.FinishProductCode), new SqlParameter("@MRDescription", obj.Description), new SqlParameter("@MRReqdQty", obj.ReqdQty), new SqlParameter("@MRIssuedQty", obj.IssuedQty), new SqlParameter("@MRBINNo", obj.MRBINNo) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_MRFinishProduct", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(MRFinishProduct obj, long OriginalMRNO, String OriginalFinishProductCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", obj.MR.MRNO), new SqlParameter("@MRFinishProductID", obj.FinishProduct.FinishProductCode), new SqlParameter("@MRDescription", obj.Description), new SqlParameter("@MRReqdQty", obj.ReqdQty), new SqlParameter("@MRIssuedQty", obj.IssuedQty), new SqlParameter("@MRBINNo", obj.MRBINNo), new SqlParameter("@Original_MRNO", OriginalMRNO), new SqlParameter("@Original_MRFinishProductID", OriginalFinishProductCode) }; return(Execute.RunSP_RowsEffected(Connection, "SPGET_MRBasicProduct", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MRFinishProduct Get(long MRNO, String FinishProductCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MRNO", MRNO), new SqlParameter("@FinishProductCode", FinishProductCode) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProductCode", paramList); MRFinishProduct objMRFinishProduct = new MRFinishProduct(); objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[0]["MRFinishProductID"])); objMRFinishProduct.Description = Convert.ToString(dt.Rows[0]["MRDescription"]); objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[0]["MRNO"])); objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[0]["MRBINNo"]); objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[0]["MRReqdQty"]); objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[0]["MRIssuedQty"]); //objMRFinishProduct.UniRate = Convert.ToDecimal(dr.MRUnitRate); if (dt.Rows[0]["MRIssuedQty"] != null) { objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[0]["MRIssuedQty"]); } else { objMRFinishProduct.UniRate = 0; } return(objMRFinishProduct); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public MRFinishProductCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRFinishProduct"); MRFinishProductCollec objMRFinishProductCollec = new MRFinishProductCollec(); for (int i = 0; i < dt.Rows.Count; i++) { MRFinishProduct objMRFinishProduct = new MRFinishProduct(); objMRFinishProduct.FinishProduct = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["MRFinishProductID"])); objMRFinishProduct.Description = Convert.ToString(dt.Rows[i]["MRDescription"]); objMRFinishProduct.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[i]["MRIssuedQty"])); objMRFinishProduct.MRBINNo = Convert.ToString(dt.Rows[i]["MRIssuedQty"]); objMRFinishProduct.ReqdQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); objMRFinishProduct.IssuedQty = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); //objMRFinishProduct.UniRate = Convert.ToDecimal(dr.MRUnitRate); if (dt.Rows[i]["MRIssuedQty"] != null) { objMRFinishProduct.UniRate = Convert.ToDecimal(dt.Rows[i]["MRIssuedQty"]); } else { objMRFinishProduct.UniRate = 0; } objMRFinishProductCollec.Add(objMRFinishProduct); } return(objMRFinishProductCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void IssueFinishFinished() { if (cmbStore.Items.Count > 0) { Store objStore = (Store)cmbStore.SelectedItem; if (this.ItemSelect) { if (objMR.MRType == MR.Type.FinishProduct) { bool isZero = false; bool Transfer = true; int Stock = 0; int zerocount = 0; foreach (DataGridViewRow dr in gvItemList.Rows) { MRFinishProduct objMRFinish = new MRFinishProduct(); objMRFinish = (MRFinishProduct)dr.DataBoundItem; Stock = objMRBasicProduct_DL.Get_FGStockByStore(objStore.StoreID, objMRFinish.FinishProduct.FinishProductCode, objMRFinish.IssuedQty); if (Stock == 0 && objMRFinish.IssuedQty != 0) { MessageBox.Show(this, objMRFinish.FinishProduct.FinishProductCode + " Stock is lower than Issued Quantity,Please enter lower quantity", "Stock is not Enough", MessageBoxButtons.OK, MessageBoxIcon.Information); Transfer = false; break; } if (objMRFinish.IssuedQty == 0) { isZero = true; zerocount++; } } if (Transfer) { DialogResult drRes; if (zerocount >= gvItemList.Rows.Count) { MessageBox.Show(this, "Please enter a Issue Quantity", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (isZero) { drRes = MessageBox.Show(this, "One more items does not have a quantity, Do you want to continue\n\nClick Yes to continue", "Empty Quantities", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (drRes == DialogResult.Yes) { foreach (DataGridViewRow dr in gvItemList.Rows) { MRFinishProduct objMRFinish = new MRFinishProduct(); objMRFinish = (MRFinishProduct)dr.DataBoundItem; objMRFinishProduct_DL.Issue(objMRFinish, objStore.StoreID); } objMR.MRIssuedBy = CurrentUser.UserEmp.EmployeeID; objMR.MRStatus = MR.Status.Issued; int x = objMRDL.Update_Issue(objMR); if (x > 0) { bindItemList.DataSource = null; Clear(); if (objStore != null) { bindMRList.DataSource = objMRDL.GetDataView(objStore.StoreID, MR.Status.Approved); } } } } else { foreach (DataGridViewRow dr in gvItemList.Rows) { MRFinishProduct objMRFinish = new MRFinishProduct(); objMRFinish = (MRFinishProduct)dr.DataBoundItem; objMRFinishProduct_DL.Issue(objMRFinish, objStore.StoreID); } objMR.MRIssuedBy = CurrentUser.UserEmp.EmployeeID; objMR.MRStatus = MR.Status.Issued; int x = objMRDL.Update_Issue(objMR); if (x > 0) { bindItemList.DataSource = null; Clear(); if (objStore != null) { bindMRList.DataSource = objMRDL.GetDataView(objStore.StoreID, MR.Status.Approved); } } } } } } } } }
private void btnItemAdd_Click(object sender, EventArgs e) { if (txtQty.Text.Equals("")) { MessageBox.Show(this, "Please fill the quantity field", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { bool ItemList = false; MRMaterial objMRMat = new MRMaterial(); MRBasicProduct objMRBasic = new MRBasicProduct(); MRFinishProduct objMRFinish = new MRFinishProduct(); try { if (this.ItemSelect) { if (cmbMRType.SelectedItem.Equals("Material")) { objMRMat.Description = txtDescription.Text; objMRMat.Material = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); objMRMat.ReqdQty = Convert.ToDecimal(txtQty.Text); if (objMRMaterial.Material.MaterialCode != objMRMat.Material.MaterialCode) { foreach (MRMaterial obj in objMRMaterialCollec) { if (obj.Material.MaterialCode == objMRMat.Material.MaterialCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRMaterialCollec.Delete(objMRMaterial); objMRMaterialCollec.Add(objMRMat); ClearItem(); } } else { objMRMaterialCollec.Delete(objMRMaterial); objMRMaterialCollec.Add(objMRMat); ClearItem(); } bindItemList.DataSource = objMRMaterialCollec; bindItemList.ResetBindings(false); } else if (cmbMRType.SelectedItem.Equals("Basic Products")) { objMRBasic.BasicProduct = objBasicProductDL.Get(cmbItem.SelectedValue.ToString()); objMRBasic.Description = txtDescription.Text; objMRBasic.ReqdQty = Convert.ToDecimal(txtQty.Text); if (objMRBasicProduct.BasicProduct.BasicProductCode != objMRBasic.BasicProduct.BasicProductCode) { foreach (MRBasicProduct obj in objMRBasicProductCollec) { if (obj.BasicProduct.BasicProductCode == objMRBasic.BasicProduct.BasicProductCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRBasicProductCollec.Delete(objMRBasicProduct); objMRBasicProductCollec.Add(objMRBasic); ClearItem(); } } else { objMRBasicProductCollec.Delete(objMRBasicProduct); objMRBasicProductCollec.Add(objMRBasic); ClearItem(); } bindItemList.DataSource = objMRBasicProductCollec; bindItemList.ResetBindings(false); } else if (cmbMRType.SelectedItem.Equals("Finish Products")) { objMRFinish.Description = txtDescription.Text; objMRFinish.FinishProduct = objFinishProductDL.Get(cmbItem.SelectedValue.ToString()); objMRFinish.ReqdQty = Convert.ToDecimal(txtQty.Text); if (objMRFinishProduct.FinishProduct.FinishProductCode != objMRFinish.FinishProduct.FinishProductCode) { foreach (MRFinishProduct obj in objMRFinishhProductCollec) { if (obj.FinishProduct.FinishProductCode == objMRFinish.FinishProduct.FinishProductCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRFinishhProductCollec.Delete(objMRFinishProduct); objMRFinishhProductCollec.Add(objMRFinish); ClearItem(); } } else { objMRFinishhProductCollec.Delete(objMRFinishProduct); objMRFinishhProductCollec.Add(objMRFinish); ClearItem(); } bindItemList.DataSource = objMRFinishhProductCollec; bindItemList.ResetBindings(false); } } else { if (cmbMRType.SelectedItem.Equals("Material")) { objMRMat.Description = txtDescription.Text; objMRMat.Material = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); objMRMat.ReqdQty = Convert.ToDecimal(txtQty.Text); if (objMRMaterialCollec.Count > 0) { foreach (MRMaterial obj in objMRMaterialCollec) { if (obj.Material.MaterialCode == objMRMat.Material.MaterialCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRMaterialCollec.Add(objMRMat); ClearItem(); } } else { objMRMaterialCollec.Add(objMRMat); ClearItem(); } bindItemList.DataSource = objMRMaterialCollec; bindItemList.ResetBindings(false); } else if (cmbMRType.SelectedItem.Equals("Basic Products")) { objMRBasic.BasicProduct = objBasicProductDL.Get(cmbItem.SelectedValue.ToString()); objMRBasic.Description = txtDescription.Text; objMRBasic.ReqdQty = Convert.ToDecimal(txtQty.Text); if (objMRBasicProductCollec.Count > 0) { foreach (MRBasicProduct obj in objMRBasicProductCollec) { if (obj.BasicProduct.BasicProductCode == objMRBasic.BasicProduct.BasicProductCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRBasicProductCollec.Add(objMRBasic); ClearItem(); } } else { objMRBasicProductCollec.Add(objMRBasic); ClearItem(); } bindItemList.DataSource = objMRBasicProductCollec; bindItemList.ResetBindings(false); } else if (cmbMRType.SelectedItem.Equals("Finish Products")) { objMRFinish.Description = txtDescription.Text; objMRFinish.FinishProduct = objFinishProductDL.Get(cmbItem.SelectedValue.ToString()); objMRFinish.ReqdQty = Convert.ToDecimal(txtQty.Text); if (objMRFinishhProductCollec.Count > 0) { foreach (MRFinishProduct obj in objMRFinishhProductCollec) { if (obj.FinishProduct.FinishProductCode == objMRFinish.FinishProduct.FinishProductCode) { MessageBox.Show(this, "This item already in the list,Please Select the item from List and Update", "Item in the List", MessageBoxButtons.OK, MessageBoxIcon.Information); ItemList = true; break; } } if (!ItemList) { objMRFinishhProductCollec.Add(objMRFinish); ClearItem(); } } else { objMRFinishhProductCollec.Add(objMRFinish); ClearItem(); } bindItemList.DataSource = objMRFinishhProductCollec; bindItemList.ResetBindings(false); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { objMRMat = null; } } }