public MTNMaterial Get(long MTNNO, String MaterialCode) { Material_DL objMaterial_DL = new Material_DL(Connection); MTN_DL objMTN_DL = new MTN_DL(Connection); MTNMaterial objMTNMaterial = new MTNMaterial(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Original_MTNNO", MTNNO), new SqlParameter("@Original_MTNMaterialCode", MaterialCode) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPDELETE_MTNMaterial", paramList); objMTNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[0]["MTNMaterialCode"])); objMTNMaterial.Batch = "No"; objMTNMaterial.Description = Convert.ToString(dt.Rows[0]["MTNDescription"]); objMTNMaterial.MTN = objMTN_DL.Get(Convert.ToInt64(dt.Rows[0]["MTNNO"])); objMTNMaterial.TransferQty = Convert.ToDecimal(dt.Rows[0]["MTNTransferQty"]); objMTNMaterial.UnitRate = Convert.ToDecimal(dt.Rows[0]["MTNUnitRate"]); objMTNMaterial.ReceivedQty = Convert.ToDecimal(dt.Rows[0]["ReceivedQty"]); return(objMTNMaterial); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(MTNMaterial obj) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", obj.MTN.MTNNo), new SqlParameter("@MTNMaterialCode", obj.Material.MaterialCode), new SqlParameter("@MTNTransferQty", obj.TransferQty), new SqlParameter("@MTNUnitRate", obj.UnitRate), new SqlParameter("@MTNRceivedQty", obj.ReceivedQty) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_MTNMaterial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Add(MTNMaterial obj, String StoreID, long GRNNO) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", obj.MTN.MTNNo), new SqlParameter("@MTNMaterialCode", obj.Material.MaterialCode), new SqlParameter("@MTNDescription", obj.Description), new SqlParameter("@MTNTransferQty", obj.TransferQty), new SqlParameter("@MTNUnitRate", obj.UnitRate), new SqlParameter("@GRNNO", GRNNO), new SqlParameter("@StoreID", StoreID) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_MTNMaterial_BY_GRN", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public int Update(MTNMaterial obj, long OriginalMTNNO, String OriginalMaterialCode) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@MTNNO", obj.MTN.MTNNo), new SqlParameter("@MTNMaterialCode", obj.Material.MaterialCode), new SqlParameter("@MTNBatchNo", obj.MTN.MTNBatch), new SqlParameter("@MTNDescription", obj.Description), new SqlParameter("@MTNTransferQty", obj.TransferQty), new SqlParameter("@MTNUnitRate", obj.UnitRate), new SqlParameter("@MTNRceivedQty", obj.ReceivedQty), new SqlParameter("@Original_MTNNO", OriginalMTNNO), new SqlParameter("@Original_MTNMaterialCode", OriginalMaterialCode) }; return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_MTNMaterial", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void btnSave_Click(object sender, EventArgs e) { MTNMaterial objMTNMat = new MTNMaterial(); MTNBasicProduct objMTNBasic = new MTNBasicProduct(); MTNFinishProduct objMTNFinish = new MTNFinishProduct(); Department objDepFrom = new Department(); Department objDepTo = new Department(); Store objStore = new Store(); Material objMaterial = new Material(); FinishProduct objFinishProduct = new FinishProduct(); BasicProduct objBasicProduct = new BasicProduct(); GRN objGRN = new GRN(); try { String ItemCode = ""; if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null) { ItemCode = cmbItem.SelectedValue.ToString(); } if (cmbDepartmentFrom.Items.Count > 0) { objDepFrom = (Department)cmbDepartmentFrom.SelectedItem; objDepTo = (Department)cmbDepartmentFrom.SelectedItem; } if (cmbStoreFrom.Items.Count > 0) { objStore = (Store)cmbStoreFrom.SelectedItem; } objMTN.MTNDepartmentFrom = objDepFrom; objMTN.MTNDepartmentTo = objDepTo; objMTN.MTNEnterdBy = CurrentUser.UserEmp; objMTN.MTNStatus = MTN.Status.Initial; objMTN.MTNType = MTN.Type.Dispose; objMTN.MTNStore = objStore; if (cmbMTNType.SelectedItem.Equals("Basic Product")) { objMTN.MTNItemType = MTN.ItemType.Basic_Product; objMTN.MTNNo = objMTNDL.Add_Other(objMTN); if (objMTN.MTNNo > 0) { foreach (DataRow dr in dt.Rows) { objBasicProduct = objBasicProductDL.Get(dr["ItemCode"].ToString()); objMTNBasic.Batch = ""; objMTNBasic.Description = dr["Remarks"].ToString(); objMTNBasic.BasicProduct = objBasicProduct; objMTNBasic.MTN = objMTN; objMTNBasic.TransferQty = Convert.ToDecimal(dr["Qty"].ToString()); objMTNBasicProductDL.Add(objMTNBasic); } } } else if (cmbMTNType.SelectedItem.Equals("Material")) { objMTN.MTNItemType = MTN.ItemType.Material; objMTN.MTNNo = objMTNDL.Add_Other(objMTN); if (objMTN.MTNNo > 0) { foreach (DataRow dr in dt.Rows) { objMaterial = objMaterialDL.Get(dr["ItemCode"].ToString()); objMTNMat.Batch = ""; objMTNMat.Description = dr["Remarks"].ToString(); objMTNMat.Material = objMaterial; objMTNMat.MTN = objMTN; objMTNMat.TransferQty = Convert.ToDecimal(dr["Qty"]); objMTNMaterialDL.Add(objMTNMat); } } } else if (cmbMTNType.SelectedItem.Equals("Finish Product")) { objMTN.MTNItemType = MTN.ItemType.Finish_Product; objMTN.MTNNo = objMTNDL.Add_Other(objMTN); if (objMTN.MTNNo > 0) { foreach (DataRow dr in dt.Rows) { objFinishProduct = objFinishProductDL.Get((cmbItem.SelectedValue.ToString())); objMTNFinish.Batch = ""; objMTNFinish.Description = dr["Remarks"].ToString(); objMTNFinish.FinishProduct = objFinishProduct; objMTNFinish.MTN = objMTN; objMTNFinish.TransferQty = Convert.ToDecimal(dr["Qty"]); objMTNFinisProductDL.Add(objMTNFinish); } } } int x = Approve(); if (x > 0) { MessageBox.Show(this, "Stock Reduced", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { MTNMaterial objMTNMat = new MTNMaterial(); MTNBasicProduct objMTNBasic = new MTNBasicProduct(); MTNFinishProduct objMTNFinish = new MTNFinishProduct(); Department objDepFrom = new Department(); Department objDepTo = new Department(); Store objStore = new Store(); Material objMaterial = new Material(); FinishProduct objFinishProduct = new FinishProduct(); BasicProduct objBasicProduct = new BasicProduct(); GRN objGRN = new GRN(); try { if (cmbGRNNO.Items.Count > 0 && cmbGRNNO.SelectedValue != null) { objGRN.GRNNo = Convert.ToInt64(cmbGRNNO.SelectedValue); } String ItemCode = ""; if (cmbItem.Items.Count > 0 && cmbItem.SelectedValue != null) { ItemCode = cmbItem.SelectedValue.ToString(); } if (cmbDepartmentFrom.Items.Count > 0) { objDepFrom = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentFrom.SelectedValue)); } if (cmbDepartmentTo.Items.Count > 0) { objDepTo = objDepartmentDL.Get(Convert.ToInt64(cmbDepartmentTo.SelectedValue)); } if (cmbStoreFrom.Items.Count > 0) { objStore = (Store)cmbStoreFrom.SelectedItem; } if (!ItemCode.Equals("") && !objGRN.GRNNo.Equals("") && objDepTo != null && objDepFrom != null) { if (txtQty.Text.Equals("")) { MessageBox.Show(this, "Please enter Valid Quantity for Transfer", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (Convert.ToDecimal(txtQty.Text) > Convert.ToDecimal(txtAvailableQty.Text)) { MessageBox.Show(this, "Available Quantity is " + txtAvailableQty.Text + ",Transfer quantity cannot be more than available", "Available Quantity Exceed", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { objMTN.MTNDepartmentFrom = objDepFrom; objMTN.MTNDepartmentTo = objDepTo; objMTN.MTNEnterdBy = CurrentUser.UserEmp; objMTN.MTNStatus = MTN.Status.Initial; objMTN.MTNType = MTN.Type.General; objMTN.MTNStore = objStore; if (cmbMTNType.SelectedItem.Equals("Basic Product")) { objMTN.MTNItemType = MTN.ItemType.Basic_Product; objMTN.MTNNo = objMTNDL.Add(objMTN); if (objMTN.MTNNo > 0) { objBasicProduct = objBasicProductDL.Get((cmbItem.SelectedValue.ToString())); objMTNBasic.Batch = "No"; objMTNBasic.Description = txtRemarks.Text; objMTNBasic.BasicProduct = objBasicProduct; objMTNBasic.MTN = objMTN; objMTNBasic.TransferQty = Convert.ToDecimal(txtQty.Text); objMTNBasic.UnitRate = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text); objMTNBasicProductDL.Add(objMTNBasic); MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (cmbMTNType.SelectedItem.Equals("Material")) { objMTN.MTNItemType = MTN.ItemType.Material; objMTN.MTNNo = objMTNDL.Add(objMTN); if (objMTN.MTNNo > 0) { objMaterial = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); objMTNMat.Batch = "No"; objMTNMat.Description = txtRemarks.Text; objMTNMat.Material = objMaterial; objMTNMat.MTN = objMTN; objMTNMat.TransferQty = Convert.ToDecimal(txtQty.Text); objMTNMat.UnitRate = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text); objMTNMaterialDL.Add(objMTNMat); MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (cmbMTNType.SelectedItem.Equals("Finish Product")) { objMTN.MTNItemType = MTN.ItemType.Finish_Product; objMTN.MTNNo = objMTNDL.Add(objMTN); if (objMTN.MTNNo > 0) { objFinishProduct = objFinishProductDL.Get((cmbItem.SelectedValue.ToString())); objMTNFinish.Batch = "No"; objMTNFinish.Description = txtRemarks.Text; objMTNFinish.FinishProduct = objFinishProduct; objMTNFinish.MTN = objMTN; objMTNFinish.TransferQty = Convert.ToDecimal(txtQty.Text); objMTNFinish.UnitRate = Convert.ToDecimal(txtGRNUnitCost.Text) + Convert.ToDecimal(txtStockHoldingCost.Text); objMTNFinisProductDL.Add(objMTNFinish); MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } } else { MessageBox.Show(this, "Please check Item, Department and GRN that you selected", "Selection Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnTransfer_Click(object sender, EventArgs e) { try { if (objPRPDBatch.Type != PRPDBatch.PRPDType.Rework) { if (objProcessed.MaterialCode != "") { MTN objMTN = new MTN(); objMTN.MTNDate = DateTime.Today; objMTN.MTNDepartmentFrom = objDepartment_DL.GetByDepType("PRPD"); objMTN.MTNDepartmentFromName = objMTN.MTNDepartmentFrom.DepName; objMTN.MTNDepartmentTo = objDepartment_DL.GetByDepType("Store"); objMTN.MTNEnterdBy = objEmployee_DL.Get(CurrentUser.EmployeeID); objMTN.MTNItemType = MTN.ItemType.Material; objMTN.MTNStatus = MTN.Status.Initial; objMTN.MTNType = MTN.Type.PRPD; int ID = objMTN_DL.Add_PRPDTransfer(objMTN); if (ID > 0) { objMTN.MTNNo = ID; MTNMaterial objMTNMat = new MTNMaterial(); objMTNMat.Description = "PRPD batch Transfer"; objMTNMat.Material = objProcessed; objMTNMat.MTN = objMTN; objMTNMat.TransferQty = objPRPDBatch.PRPDBatchFinalQty; objMTNMat.UnitRate = objPRPDBatch_DL.UnitPrice(objPRPDBatch.PRPDBatchID); objMTNMat.Batch = "No"; int res = objMTNMaterial_DL.Add(objMTNMat); if (res > 0) { objPRPDBatch.UnitCost = objPRPDBatch_DL.UnitPrice(objPRPDBatch.PRPDBatchID); objPRPDBatch.Status = PRPDBatch.PRPDBatchStatus.Transfered; objPRPDBatch.PRPDBatchHandOverBy = CurrentUser.UserEmp; objPRPDBatch.PRPDBatchMTNOUT = objMTN; objPRPDBatch_DL.Update_Transfer(objPRPDBatch); MessageBox.Show(this, "Successfully Transferd, MTN No :- " + objMTN.MTNNo.ToString(), "Successful", MessageBoxButtons.OK, MessageBoxIcon.Warning); Clear(); this.frmPRPDBatchTransfer_Preperation_Load(sender, e); } } } else { MessageBox.Show(this, "There are no Processed Materials", "Invalid Material", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MTN objMTN = new MTN(); objMTN.MTNDate = DateTime.Today; objMTN.MTNDepartmentFrom = objDepartment_DL.GetByDepType("PRPD"); objMTN.MTNDepartmentFromName = objMTN.MTNDepartmentFrom.DepName; objMTN.MTNDepartmentTo = objDepartment_DL.GetByDepType("Store"); objMTN.MTNEnterdBy = objEmployee_DL.Get(CurrentUser.EmployeeID); objMTN.MTNItemType = MTN.ItemType.Material; objMTN.MTNStatus = MTN.Status.Initial; objMTN.MTNType = MTN.Type.PRPD; int ID = objMTN_DL.Add_PRPDTransfer(objMTN); if (ID > 0) { objMTN.MTNNo = ID; MTNMaterial objMTNMat = new MTNMaterial(); objMTNMat.Description = "PRPD batch Transfer"; objMTNMat.Material = objProcessed; objMTNMat.MTN = objMTN; objMTNMat.TransferQty = objPRPDBatch.PRPDBatchFinalQty; objMTNMat.UnitRate = objPRPDBatch_DL.UnitPrice(objPRPDBatch.PRPDBatchID); objMTNMat.Batch = "No"; int res = objMTNMaterial_DL.Add(objMTNMat); if (res > 0) { objPRPDBatch.UnitCost = objPRPDBatch_DL.UnitPrice(objPRPDBatch.PRPDBatchID); objPRPDBatch.Status = PRPDBatch.PRPDBatchStatus.Transfered; objPRPDBatch.PRPDBatchHandOverBy = CurrentUser.UserEmp; objPRPDBatch.PRPDBatchMTNOUT = objMTN; objPRPDBatch_DL.Update_Transfer(objPRPDBatch); MessageBox.Show(this, "Successfully Transferd, MTN No :- " + objMTN.MTNNo.ToString(), "Successful", MessageBoxButtons.OK, MessageBoxIcon.Warning); Clear(); this.frmPRPDBatchTransfer_Preperation_Load(sender, e); } } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }