private void btnAddFinishProduct_Click(object sender, EventArgs e) { if (txtFinishProductAvgCost.Text.Equals("") || txtProductCode.Text.Equals("") || txtFinishProductDescription.Text.Equals("")) { MessageBox.Show(this, "Please Fill all Fields", "Blank Fields", MessageBoxButtons.OK, MessageBoxIcon.Stop); } else { try { objFinishProduct.FinishProductCode = txtProductCode.Text; objFinishProduct.BasicProduct = objbasicProductDL.Get(cmbBasicProduct.SelectedValue.ToString()); objFinishProduct.FinishProductPackingType = objPackingTypeDL.Get(Convert.ToInt64(cmbPackType.SelectedValue)); objFinishProduct.FinishProductDescription = txtFinishProductDescription.Text; objFinishProduct.BasicProductQty = Convert.ToDecimal(txtBasicProductQty.Text); objFinishProduct.FinishProductAvgCost = Convert.ToDecimal(txtFinishProductAvgCost.Text); if (chkEnablePr.Checked == true) { objFinishProduct.FinishProductStatus = true; } else { objFinishProduct.FinishProductStatus = false; } objFinishProduct.PrimaryFinishProductCode = txtProductCode.Text; objFinishProduct.PrimaryFinishProductQty = 1; objFinishProduct.FinishProductType = "Primary"; int x; x = objFinishProductDL.Add(objFinishProduct); gvFinishProduct.DataSource = objFinishProductDL.GetDataView("Primary", cmbBasicProduct.SelectedValue.ToString()); if (x > 0) { MessageBox.Show(this, "Succesfully Added to Database", "Succesfull", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ClearFinishProduct(); } else if (x == -1) { MessageBox.Show(this, "Product Code already in the Database,Please enter another Product Code", "Problem with Product Code", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (FormatException) { MessageBox.Show(this, "Please enter valid data", "Input Data Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { } } }
private void LoadMaterial() { if (cmbGRNType.SelectedIndex + 1 == Convert.ToInt32(GRN.Type.Material)) { cmbMaterial.DataSource = null; cmbMaterial.Items.Clear(); bsMaterialList.DataSource = objMaterial_DL.GetDataView(); cmbMaterial.DataSource = bsMaterialList; cmbMaterial.BindingContext = this.BindingContext; cmbMaterial.DisplayMember = "Material"; cmbMaterial.ValueMember = "MaterialCode"; } else if (cmbGRNType.SelectedIndex + 1 == Convert.ToInt32(GRN.Type.BasicProduct)) { cmbMaterial.DataSource = null; cmbMaterial.Items.Clear(); bsMaterialList.DataSource = objBasicProduct_DL.GetDataView(); cmbMaterial.DataSource = bsMaterialList; cmbMaterial.BindingContext = this.BindingContext; cmbMaterial.DisplayMember = "BasicProduct"; cmbMaterial.ValueMember = "BasicProductCode"; } else if (cmbGRNType.SelectedIndex + 1 == Convert.ToInt32(GRN.Type.FinishProduct)) { cmbMaterial.DataSource = null; cmbMaterial.Items.Clear(); bsMaterialList.DataSource = objFinishProduct_DL.GetDataView(1); cmbMaterial.DataSource = bsMaterialList; cmbMaterial.BindingContext = this.BindingContext; cmbMaterial.DisplayMember = "FinishProduct"; cmbMaterial.ValueMember = "FinishProductCode"; } }
private void cmbMRType_SelectedIndexChanged(object sender, EventArgs e) { Material objMat = new Material(); BasicProduct objBasic = new BasicProduct(); FinishProduct objFinish = new FinishProduct(); bindItemList.DataSource = null; objMRFinishhProductCollec.Clear(); objMRMaterialCollec.Clear(); objMRBasicProductCollec.Clear(); try { if (cmbMRType.SelectedItem.Equals("Material")) { cmbItem.DataSource = objMaterialDL.GetDataView(); cmbItem.DisplayMember = "Material"; cmbItem.ValueMember = "MaterialCode"; objMat = objMaterialDL.Get(cmbItem.SelectedValue.ToString()); if (objMat != null) { lblUnit.Text = objMat.MatUnit.UnitCode; } } else if (cmbMRType.SelectedItem.Equals("Basic Products")) { cmbItem.DataSource = objBasicProductDL.GetDataView(true); cmbItem.DisplayMember = "Code"; cmbItem.ValueMember = "BasicProductCode"; objBasic = objBasicProductDL.Get(cmbItem.SelectedValue.ToString()); if (objBasic != null) { lblUnit.Text = objBasic.BasicProductUnit.UnitCode; } } else if (cmbMRType.SelectedItem.Equals("Finish Products")) { cmbItem.DataSource = objFinishProductDL.GetDataView(1); cmbItem.DisplayMember = "Code"; cmbItem.ValueMember = "FinishProductCode"; objFinish = objFinishProductDL.Get(cmbItem.SelectedValue.ToString()); if (objFinish != null) { lblUnit.Text = objFinish.FinishProductPackingType.PackingTitle; } } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//--------------- Methods -------------------- public void LoadDirect() { try { if (cmbGRNType.SelectedItem.Equals("Material")) { cmbItem.DataSource = objMaterialDL.GetDataView(); cmbItem.DisplayMember = "Material"; cmbItem.ValueMember = "MaterialCode"; objGRN.GRNType = GRN.Type.Material; } else if (cmbGRNType.SelectedItem.Equals("Basic Product")) { cmbItem.DataSource = objBasicProductDL.GetDataView(); cmbItem.DisplayMember = "BasicProduct"; cmbItem.ValueMember = "BasicProductCode"; objGRN.GRNType = GRN.Type.BasicProduct; } else if (cmbGRNType.SelectedItem.Equals("Finish Product")) { cmbItem.DataSource = objFinishProductDL.GetDataView(1); cmbItem.DisplayMember = "FinishProduct"; cmbItem.ValueMember = "FinishProductCode"; objGRN.GRNType = GRN.Type.FinishProduct; } } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//----------------------- Methods ---------------------------- public void LoadItems() { try { cmbFinishProduct.DataSource = objFinishProductDL.GetDataView(1); } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Load_Products() { try { dtStartProduct = objFinishProduct_DL.GetDataView(objBasicProduct.BasicProductCode); objSourceFinishProductStart.DataSource = dtStartProduct; cmbStartProduct.DataSource = objSourceFinishProductStart; dtEndProduct = objFinishProduct_DL.GetDataView(objBasicProduct.BasicProductCode); objSourceFinishProductStop.DataSource = dtEndProduct; cmbEndProduct.DataSource = objSourceFinishProductStop; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void frmFormula_Load(object sender, EventArgs e) { try { cmbMaterials.DataSource = objMaterialDL.GetDataView(); cmbMaterials.DisplayMember = "Material"; cmbMaterials.ValueMember = "MaterialCode"; cmbBasicProducts.DataSource = objBasicProductDL.GetDataView(true); cmbBasicProducts.DisplayMember = "BasicProduct"; cmbBasicProducts.ValueMember = "BasicProductCode"; cmbFinishProducts.DataSource = objFinishProductDL.GetDataView(1); cmbFinishProducts.DisplayMember = "FinishProduct"; cmbFinishProducts.ValueMember = "FinishProductCode"; } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Load_ProductList() { try { if (lstBasicProductList.SelectedValue != null) { FinishProduct_DL objFinishProduct_DL = new FinishProduct_DL(ConnectionStringClass.GetConnection()); DataTable dtStart = objFinishProduct_DL.GetDataView(lstBasicProductList.SelectedValue.ToString()); DataTable dtStop = objFinishProduct_DL.GetDataView(lstBasicProductList.SelectedValue.ToString()); objSourceFinishProductStart.DataSource = dtStart; objSourceFinishProductStop.DataSource = dtStop; cmbStartProduct.DataSource = objSourceFinishProductStart; cmbEndProduct.DataSource = objSourceFinishProductStop; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
private void Load_Products() { try { if ((cmbProductType.Text == "Semi Processed Product") | (cmbProductType.Text == "Basic Product")) { if (cmbProductType.Text == "Semi Processed Product") { dtProducts = objBasicProductDL.GetDataView("Semi Processed Product", true); cmbProductCode.DisplayMember = "BasicProductDescription"; cmbProductCode.ValueMember = "BasicProductCode"; } else { dtProducts = objBasicProductDL.GetDataView("Product", true); cmbProductCode.DisplayMember = "BasicProductDescription"; cmbProductCode.ValueMember = "BasicProductCode"; } } else if (cmbProductType.Text == "Finish Product") { dtProducts = objFinishProductDL.GetDataView(true); cmbProductCode.DisplayMember = "FinishProdutDescription"; cmbProductCode.ValueMember = "FinishProductCode"; } objSourceProducts.DataSource = dtProducts; cmbProductCode.DataSource = objSourceProducts; } catch (Exception ex) { MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }