//------------------ Methods ------------------------------- public void Clear() { txtDate.Text = ""; txtDepartment.Text = ""; txtMRNo.Text = ""; txtRemarks.Text = ""; txtReqestBy.Text = ""; txtType.Text = ""; bindItemList.DataSource = null; objMR = null; try { Department objDep = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue)); if (rbInitial.Checked) { bindMRList.DataSource = objMRDL.GetMR_ToDep_or_ToStore(objDep.DepID, MR.Status.Initial, MR.Origin.ToBatch); } else if (rbApproved.Checked) { bindMRList.DataSource = objMRDL.GetMR_ToDep_or_ToStore(objDep.DepID, MR.Status.Approved, MR.Origin.ToBatch); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void LoadStore() { try { cmbDepartment.DataSource = objDepDL.Get(); cmbStoreKeeper.DataSource = objEmpDL.Get(); bindStoreList.DataSource = objStoreDL.Get(); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSubmit_Click(object sender, EventArgs e) { Store objStore = new Store(); objStore.StoreID = CurrStore; objDepTo = objDepartmentDL.Get(25); objDepFrom = objDepartmentDL.Get(25); //objMTN.MTNDate = DateTime.Now; //objMTN.MTNApprovedBy = null; objMTN.MTNDepartmentFrom = objDepFrom; objMTN.MTNDepartmentTo = objDepTo; objMTN.MTNEnterdBy = CurrentUser.UserEmp; objMTN.MTNStatus = MTN.Status.Initial; objMTN.MTNType = MTN.Type.Dispose; objMTN.MTNStore = objStore; objMTN.MTNItemType = MTN.ItemType.Finish_Product; objMTN.MTNItemType = MTN.ItemType.Finish_Product; objMTN.MTNNo = objMTNDL.Add_FinishedGoodsReturns(objMTN); //objMTN.MTNNo = //objMTNDL.Add(objMTN); if (objMTN.MTNNo > 0) { foreach (DataGridViewRow dr in dgvProduct.Rows) { String tempproductCode = dr.Cells[0].Value.ToString(); String tempproduct = dr.Cells[1].Value.ToString(); long tempqty = Convert.ToInt64(dr.Cells[2].Value.ToString()); string tempstore = dr.Cells[3].Value.ToString(); objFinishProduct = objFinishProductDL.Get(tempproductCode); //objMTNFinish.Batch = "No"; //objMTNFinish.Description = "No"; objMTNFinish.FinishProduct = objFinishProduct; objMTNFinish.MTN = objMTN; objMTNFinish.ReceivedQty = 0; objMTNFinish.UnitRate = 0; objMTNFinish.UnitRate_Budget = 0; objMTNFinish.TransferQty = tempqty; objMTNFinisProductDL.Add(objMTNFinish); } MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } }
private void LoadMaterialList() { try { if ((cmbBatchNo.SelectedValue != null) && (cmbPart.Text != "")) { objBatch = objBatch_DL.Get(cmbBatchNo.SelectedValue.ToString()); dt = objBatchFormulaMaterial_DL.GetView(objBatch.BatchID, cmbPart.Text); dgvItemList.AutoGenerateColumns = false; objSourceMaterialList.DataSource = dt; dgvItemList.DataSource = objSourceMaterialList; objSourceMaterialList.ResetBindings(true); DepID = objDepDL.Get(objBatch.StandardBatch.STDBatchBasicProduct.BasicProductCode, "Manf"); DataTable dtMR = new DataTable(); if (rdbMaterial.Checked == true) { dtMR = objMRDL.GetActiveMR(cmbBatchNo.SelectedValue.ToString(), cmbPart.Text, (int)BatchMR.Status.Rejected, (int)MR.Type.Material, objStore.StoreID); } if (rdbSemiFinished.Checked == true) { dtMR = objMRDL.GetActiveMR(cmbBatchNo.SelectedValue.ToString(), cmbPart.Text, (int)BatchMR.Status.Rejected, (int)MR.Type.BasicProduct, objStore.StoreID); } if (dtMR.Rows.Count > 0) { lblMessage.Text = "There is a request already made from MRNO : " + dtMR.Rows[0]["MRNO"].ToString() + ". Please check the status of that requisition"; btnSendMR.Enabled = false; } else { lblMessage.Text = "This will request material list of the selected Part at once"; btnSendMR.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Set(Sections obj) { try { Department objDep = objDepartmentDL.Get(obj.DepID); cmbDivision.SelectedValue = objDep.DivisionID; cmDepartment.SelectedValue = objDep.DepID; cmbSection.SelectedValue = obj.SectionID; } catch (Exception) { } }
private void frmGRNMATDirect_Load(object sender, EventArgs e) { try { LoadDirect(); objStore = objStoreDL.Get(StoreID); objDepartment = objDepartmentDL.Get(objStore.StoreDepartment.DepID); txtDepartment.Text = objDepartment.DepName; txtStores.Text = objStore.StoreDescription; } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { objMR.MRDepartmentFrom = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue)); objMR.MREnterdBy = CurrentUser.UserEmp.EmployeeID; if (txtDescription.Text != "") { objMR.MRRemarks = txtDescription.Text; } else { objMR.MRRemarks = "No"; } objMR.MRStore = objStore; objMR.MRStatus = MR.Status.Initial; objMR.MRType = MR.Type.BasicProduct; objMR.OriginType = MR.Origin.ToStore; if (objMRBasicProductCollec.Count > 0) { long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; foreach (MRBasicProduct obj in objMRBasicProductCollec) { obj.MR = objMR; objMRBasicProduct_DL.Add(obj); } MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearItem(); ClearMR(); } } else { MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmbDepartment_SelectedIndexChanged(object sender, EventArgs e) { try { Load_Stores(); if (cmbDepartment.SelectedValue != null) { objDepartment = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue)); } Load_MRList(); } catch (Exception ex) { MessageBox.Show(this, "Error occured while Receiving", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//-------------------Events ------------------------ private void frmMaterialsReceipt_Load(object sender, EventArgs e) { try { dt = objUserDepartments_DL.Get_Default(CurrentUser.UserID); objDepartment = objDepDL.Get(Convert.ToInt64((dt.Rows[0]["Department"]))); objStore = objStoreDL.Get_Default(objDepartment.DepID); txtDepartment.Text = objDepartment.DepName; txtStore.Text = objStore.StoreID; Load_MRList(); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void frmRemoveStock_Load(object sender, EventArgs e) { try { cmbMTNType.SelectedIndex = 0; cmbDepartmentFrom.DataSource = objDepartmentDL.Get(); //cmbDepartmentTo.DataSource = objDepartmentDL.Get(); dt.Columns.Add("ItemCode"); dt.Columns.Add("Item"); dt.Columns.Add("Remarks"); dt.Columns.Add("Qty"); dt.Columns.Add("Unit"); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnSave_Click(object sender, EventArgs e) { try { objMR.MRDepartmentFrom = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue)); objMR.MREnterdBy = CurrentUser.UserEmp.EmployeeID; objMR.MRRemarks = "No"; objMR.MRStore = objStore; objMR.MRStatus = MR.Status.Initial; objMR.MRType = MR.Type.Material; objMR.OriginType = MR.Origin.ToSection; if (objMRMaterialCollec.Count > 0) { long MRNO = objMRDL.Add_Packing_ToSections(objStore.StoreID, Convert.ToInt32(cmbSection.SelectedValue), Convert.ToInt32(cmbDepartment.SelectedValue), CurrentUser.UserEmp.EmployeeID, "Packing for RPD Batches", MR.Status.Initial, MR.Type.Material, (int)MR.Origin.ToSection); if (MRNO > 0) { objMR.MRNO = MRNO; foreach (MRMaterial obj in objMRMaterialCollec) { obj.MR = objMR; objMRMaterialDL.Add(obj); } MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearItem(); ClearMR(); } } else { MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void gvDepartment_CellClick(object sender, DataGridViewCellEventArgs e) { try { Department_DL objDepDL = new Department_DL(ConnectionStringClass.GetConnection()); Section_DL objSection_DL = new Section_DL(ConnectionStringClass.GetConnection()); OverheadRates objOverheadRates = new OverheadRates(); OverheadRates_DL objOverheadRates_DL = new OverheadRates_DL(ConnectionStringClass.GetConnection()); Employee_DL objEmpDL = new Employee_DL(ConnectionStringClass.GetConnection()); ClearDep(); if (true) { Sections objSection = objSection_DL.Get(Convert.ToInt64(gvDepartment.Rows[e.RowIndex].Cells["colDepID"].Value)); Department objDep = objDepDL.Get(objSection.DepID); if (objDep.DepID != 0) { txtSection.Text = objSection.SectionName; objSelectedSections = objSection; txtDID.Text = objDep.DepID.ToString(); txtDepartmentName.Text = objDep.DepName; objOverheadRates = objOverheadRates_DL.Get(objSection.SectionID); if (objOverheadRates.SectionID != 0) { txtDepCurrent.Text = objOverheadRates.Rate.ToString(); Employee objEmp = objEmpDL.Get(objOverheadRates.EnterdBy); txtDepEnterdBy.Text = objEmp.EmployeeName; txtDepEnterdDate.Text = objOverheadRates.EnterdDate.ToShortDateString(); } } } } catch (Exception) { MessageBox.Show(this, "Error occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
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 btnSave_Click(object sender, EventArgs e) { try { objMR.MRDate = DateTime.Now; objMR.MRDepartmentFrom = objDepDL.Get(Convert.ToInt64(cmbDepartment.SelectedValue)); objMR.MREnterdBy = CurrentUser.UserEmp.EmployeeID; objMR.MRRemarks = txtRemarks.Text; objMR.MRStatus = MR.Status.Initial; objMR.MRStore = (Store)cmbStore.SelectedItem; if (cbSection.Checked) { objMR.SectionID = Convert.ToInt64(cmbSection.SelectedValue); } else { objMR.SectionID = null; } if (cmbMRType.SelectedItem.Equals("Material")) { objMR.MRType = MR.Type.Material; if (objMRMaterialCollec.Count > 0) { long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; foreach (MRMaterial obj in objMRMaterialCollec) { obj.MR = objMR; objMRMaterialDL.Add(obj); } MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearItem(); ClearMR(); } } else { MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (cmbMRType.SelectedItem.Equals("Basic Products")) { objMR.MRType = MR.Type.BasicProduct; if (objMRBasicProductCollec.Count > 0) { long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; foreach (MRBasicProduct obj in objMRBasicProductCollec) { obj.MR = objMR; objMRBasicProductDL.Add(obj); } MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearItem(); ClearMR(); } } else { MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else if (cmbMRType.SelectedItem.Equals("Finish Products")) { objMR.MRType = MR.Type.FinishProduct; if (objMRFinishhProductCollec.Count > 0) { long MRNO = objMRDL.Add_M(objMR); if (MRNO > 0) { objMR.MRNO = MRNO; foreach (MRFinishProduct obj in objMRFinishhProductCollec) { obj.MR = objMR; objMRFinishProductDL.Add(obj); } MessageBox.Show(this, "Successfully Added to Database", "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearItem(); ClearMR(); objMRMaterialCollec.Clear(); } } else { MessageBox.Show(this, "Item List is Empty,Please add Items before continue", "Item List is Empty", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } 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 { 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; } 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_Other(objMTN); if (objMTN.MTNNo > 0) { foreach (DataRow dr in dt.Rows) { objBasicProduct = objBasicProductDL.Get(dr["ItemCode"].ToString()); objMTNBasic.Batch = "No"; objMTNBasic.Description = dr["Remarks"].ToString(); objMTNBasic.BasicProduct = objBasicProduct; objMTNBasic.MTN = objMTN; objMTNBasic.TransferQty = Convert.ToDecimal(dr["Qty"].ToString()); objMTNBasicProductDL.Add(objMTNBasic); } MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } 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 = "No"; objMTNMat.Description = dr["Remarks"].ToString(); objMTNMat.Material = objMaterial; objMTNMat.MTN = objMTN; objMTNMat.TransferQty = Convert.ToDecimal(dr["Qty"]); objMTNMaterialDL.Add(objMTNMat); } MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } 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 = "No"; objMTNFinish.Description = dr["Remarks"].ToString(); objMTNFinish.FinishProduct = objFinishProduct; objMTNFinish.MTN = objMTN; objMTNFinish.TransferQty = Convert.ToDecimal(dr["Qty"]); objMTNFinisProductDL.Add(objMTNFinish); } MessageBox.Show(this, "Successfully Saved, MTN No is " + objMTN.MTNNo, "Successfull", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }