private void getData(AutoCompleteStringCollection dataCollection) { materialBAL = new BAL.MaterialBAL(); DataSet ds = new DataSet(); ds = materialBAL.getMaterials(null); try { DataTable dt = new DataTable(); dt = ds.Tables[0]; dt.Columns.Remove("MaterialId"); dt.Columns.Remove("MaterialDescription"); dt.Columns.Remove("PriceId"); dt.Columns.Remove("CreatedOn"); dt.Columns.Remove("ModifiedOn"); foreach (DataRow row in dt.Rows) { dataCollection.Add(row[0].ToString()); dataCollection.Add(row[1].ToString()); dataCollection.Add(row[2].ToString()); } } catch (Exception ex) { MessageBox.Show("Can not open connection ! "); } }
private void BindEditForm(object[] data) { materialBAL = new BAL.MaterialBAL(); DataSet table = new DataSet(); table = materialBAL.getMaterials(data); BindFields(table); }
private DataTable GetTablesToExport() { materialBAL = new BAL.MaterialBAL(); DataTable table = new DataTable(); table = materialBAL.getMaterialsForExcel(); return(table); }
public Challan() { InitializeComponent(); customerBAL = new BAL.CustomerBAL(); materialBAL = new BAL.MaterialBAL(); orderBAL = new BAL.OrderBAL(); BindCustomer(); BindProducts(); }
private void btnYes_Click(object sender, EventArgs e) { switch (OfModule) { case "User": BAL.UserBAL userBAL = new BAL.UserBAL(); if (userBAL.deleteUser(ToDeleteId)) { MessageBox.Show("Deleted Successfully"); this.Close(); } break; case "Customer": BAL.CustomerBAL customerBAL = new BAL.CustomerBAL(); if (customerBAL.deleteCustomer(ToDeleteId)) { MessageBox.Show("Deleted Successfully"); this.Close(); } break; case "Supplier": BAL.SupplierBAL supplierBAL = new BAL.SupplierBAL(); if (supplierBAL.deleteSupplier(ToDeleteId)) { MessageBox.Show("Deleted Successfully"); this.Close(); } break; case "Material": BAL.MaterialBAL materialBAL = new BAL.MaterialBAL(); if (materialBAL.deleteMaterial(ToDeleteId)) { MessageBox.Show("Deleted Successfully"); this.Close(); } break; default: break; } }
private void BindMaterialPanel() { materialBAL = new BAL.MaterialBAL(); DataSet tables = new DataSet(); DataTable dt = new DataTable(); tables = materialBAL.getMaterials(null); dt = tables.Tables[0]; tables.Relations.Add("DetailsPrices", tables.Tables[0].Columns["MaterialId"], tables.Tables[1].Columns["MaterialId"]); BindingSource bsMaterials = new BindingSource(); bsMaterials.DataSource = tables; bsMaterials.DataMember = "Table"; BindingSource bsPrices = new BindingSource(); bsPrices.DataSource = bsMaterials; bsPrices.DataMember = "DetailsPrices"; dataGridMaterial.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.EnableResizing; dataGridMaterial.DataSource = bsMaterials; dataGridPrice.DataSource = bsPrices; this.dataGridUser.RowPostPaint += new System.Windows.Forms.DataGridViewRowPostPaintEventHandler(this.dataGridMaterial_RowPostPaint); //dataGridMaterial.DataSource = tables.Tables[0]; this.dataGridMaterial.Columns["MaterialId"].Visible = false; this.dataGridPrice.Columns["MaterialId"].Visible = false; this.dataGridMaterial.Columns["PriceId"].Visible = false; dataGridMaterial.Columns["CreatedOn"].DefaultCellStyle.Format = "MM/dd/yyyy"; // Auto Resize dataGridMaterial.AutoResizeColumns(); dataGridMaterial.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridPrice.AutoResizeColumns(); dataGridPrice.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; BindAutoCompleteToMaterial(dt); }
private void AddMaterials() { materialBAL = new BAL.MaterialBAL(); material = new Entity.Material(); material.Prices = new Entity.Price(); try { // Material try { material.MaterialCode = txtMaterialCode.Text.ToString(); } catch { } try { material.MaterialName = txtmaterialName.Text.ToString(); } catch { } try { material.MaterialDescription = txtMatDescription.Text.ToString(); } catch { } try { material.HSNCode = txtHSNCode.Text.ToString(); } catch { } //Prices try { material.Prices.MaterialCode = txtMaterialCode.Text.ToString(); } catch { } try { material.Prices.OneKGSize = txtSize1.Text.ToString(); } catch { } try { material.Prices.OneKGPrice = Convert.ToDouble(txtPrice1.Text); } catch { } try { material.Prices.HalfKGSize = txtSize2.Text.ToString(); } catch { } try { material.Prices.HalfKGPrice = Convert.ToDouble(txtPrice2.Text); } catch { } try { material.Prices.Size1 = txtSize3.Text.ToString(); } catch { } try { material.Prices.Price1 = Convert.ToDouble(txtPrice3.Text); } catch { } try { material.Prices.Size2 = txtSize4.Text.ToString(); } catch { } try { material.Prices.Price2 = Convert.ToDouble(txtPrice4.Text); } catch { } try { material.Prices.Size3 = txtSize5.Text.ToString(); } catch { } try { material.Prices.Price3 = Convert.ToDouble(txtPrice5.Text); } catch { } try { material.Prices.Size4 = txtSize6.Text.ToString(); } catch { } try { material.Prices.Price4 = Convert.ToDouble(txtPrice6.Text); } catch { } try { material.Prices.Size5 = txtSize7.Text.ToString(); } catch { } try { material.Prices.Price5 = Convert.ToDouble(txtPrice7.Text); } catch { } try { material.Prices.Size6 = txtSize8.Text.ToString(); } catch { } try { material.Prices.Price6 = Convert.ToDouble(txtPrice8.Text); } catch { } try { material.Prices.Size7 = txtSize9.Text.ToString(); } catch { } try { material.Prices.Price7 = Convert.ToDouble(txtPrice9.Text); } catch { } try { material.Prices.Size8 = txtSize10.Text.ToString(); } catch { } try { material.Prices.Price8 = Convert.ToDouble(txtPrice10.Text); } catch { } try { material.Prices.Size9 = txtSize11.Text.ToString(); } catch { } try { material.Prices.Price9 = Convert.ToDouble(txtPrice11.Text); } catch { } // Common material.CreatedBy = "admin"; material.IsActive = true; material.IsDeleted = false; if (materialBAL.addMaterial(material)) { MessageBox.Show("Material added Successfully."); } else { MessageBox.Show("Something went Wrong."); } } catch (Exception ex) { Exceptions.WriteExceptionLog(ex); } }
private void btnSave_Click(object sender, EventArgs e) { materialBAL = new BAL.MaterialBAL(); material = new Entity.Material(); material.Prices = new Entity.Price(); try { // Material try { material.MaterialId = Convert.ToInt32(lblMaterialId.Text.ToString()); } catch { } try { material.MaterialCode = txtEditMaterialCode.Text.ToString(); } catch { } try { material.MaterialName = txtEditMaterialName.Text.ToString(); } catch { } try { material.MaterialDescription = txtEditMatDescription.Text.ToString(); } catch { } try { material.HSNCode = txtEditHSNCode.Text.ToString(); } catch { } //Prices try { material.Prices.MaterialCode = txtEditMaterialCode.Text.ToString(); } catch { } try { material.Prices.OneKGSize = txtEditSize1.Text.ToString(); } catch { } try { material.Prices.OneKGPrice = Convert.ToDouble(txtEditPrice1.Text); } catch { } try { material.Prices.HalfKGSize = txtEditSize2.Text.ToString(); } catch { } try { material.Prices.HalfKGPrice = Convert.ToDouble(txtEditPrice2.Text); } catch { } try { material.Prices.Size1 = txtEditSize3.Text.ToString(); } catch { } try { material.Prices.Price1 = Convert.ToDouble(txtEditPrice3.Text); } catch { } try { material.Prices.Size2 = txtEditSize4.Text.ToString(); } catch { } try { material.Prices.Price2 = Convert.ToDouble(txtEditPrice4.Text); } catch { } try { material.Prices.Size3 = txtEditSize5.Text.ToString(); } catch { } try { material.Prices.Price3 = Convert.ToDouble(txtEditPrice5.Text); } catch { } try { material.Prices.Size4 = txtEditSize6.Text.ToString(); } catch { } try { material.Prices.Price4 = Convert.ToDouble(txtEditPrice6.Text); } catch { } try { material.Prices.Size5 = txtEditSize7.Text.ToString(); } catch { } try { material.Prices.Price5 = Convert.ToDouble(txtEditPrice7.Text); } catch { } try { material.Prices.Size6 = txtEditSize8.Text.ToString(); } catch { } try { material.Prices.Price6 = Convert.ToDouble(txtEditPrice8.Text); } catch { } try { material.Prices.Size7 = txtEditSize9.Text.ToString(); } catch { } try { material.Prices.Price7 = Convert.ToDouble(txtEditPrice9.Text); } catch { } try { material.Prices.Size8 = txtEditSize10.Text.ToString(); } catch { } try { material.Prices.Price8 = Convert.ToDouble(txtEditPrice10.Text); } catch { } try { material.Prices.Size9 = txtEditSize11.Text.ToString(); } catch { } try { material.Prices.Price9 = Convert.ToDouble(txtEditPrice11.Text); } catch { } // Common material.ModifiedBy = "admin"; if (materialBAL.updateMaterial(material)) { MessageBox.Show("Material updated successfully."); this.Hide(); } else { MessageBox.Show("Something went wrong."); } } catch { } }
public EditMaterial(int MaterialId) { InitializeComponent(); materialBAL = new BAL.MaterialBAL(); BindEditForm(new object[] { MaterialId, "" }); }