private void mtAdd_Click(object sender, EventArgs e) { String name; String add; int mob; String status; int flag = 0; if (txtname.Text.Any(Char.IsDigit)) { flag = 1; MessageBox.Show("Name cannot contain digits", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } // if (txttele.Text.Length != 10) //{ // flag = 1; //MessageBox.Show("Wrong Telephone Number", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); // } if (String.IsNullOrEmpty(txtname.Text) || String.IsNullOrEmpty(txtadd.Text) || String.IsNullOrEmpty(txttele.Text)) { flag = 1; MessageBox.Show("Do not keep any fields empty", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } if (flag == 0) { name = txtname.Text; add = txtadd.Text; mob = Convert.ToInt32(txttele.Text); status = txtstatus.Text; DBSupplier c = new DBSupplier(); c.setSupplier(name, add, mob, status, u_id); } }
private void Purchase_Returns_Load(object sender, EventArgs e) { txtdate.Text = System.DateTime.Now.ToString("MM/dd/yyyy"); DBSupplier s = new DBSupplier(); DR = s.getSupplier(); while (DR.Read()) { cmbsupname.Items.Add(DR[0]); } }
private void Suppliers_Load(object sender, EventArgs e) { SqlDataAdapter da; DBSupplier i = new DBSupplier(); da = i.getSup(); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; }
private void mtadd_Click(object sender, EventArgs e) { int error = 0; if (txtprice.Text.Length == 0 && txtstatus.Text.Length == 0 && txtqty.Text.Length == 0) { error = 1; MessageBox.Show("Please fill out all the fields", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } if (cmbitemname.SelectedIndex == 0) { error = 1; MessageBox.Show("Please select an Item Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cmbsupname.SelectedIndex == 0) { error = 1; MessageBox.Show("Please select a Supplier Name", "Ërror", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (txtprice.Text.Any(Char.IsLetter)) { error = 1; MessageBox.Show("Price cannot contain letters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (txtqty.Text.Any(Char.IsLetter)) { error = 1; MessageBox.Show("Quantity cannot contain letters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (error != 1) { String date = txtdate.Text; String status = txtstatus.Text; String supname = cmbsupname.SelectedItem.ToString(); DBSupplier sup = new DBSupplier(); int sup_no = sup.getSupNo(supname); DBPurchases dp = new DBPurchases(); int po_no = dp.setPurchaseOrder(date, status, count_tot, count_qty, Users_ID, sup_no); DBPurchase_Item_reference P_I_ref = new DBPurchase_Item_reference(); foreach (DataGridViewRow Datarow in dataGridView1.Rows) { if (Datarow.Cells[0].Value != null && Datarow.Cells[1].Value != null && Datarow.Cells[2].Value != null) { String itemName = dataGridView1.CurrentRow.Cells["Item_Name"].Value.ToString(); int itemqty = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Item_Qty"].Value); int itemtot = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Sub_Total"].Value); DBItem di = new DBItem(); int itemno = di.getItemNo(itemName); P_I_ref.setReference(po_no, itemno, itemqty, itemtot); } } } }
private void mtAdd_Click(object sender, EventArgs e) ////// editable { int error = 0; if (txttotqty.Text.Length == 0 && txtprice.Text.Length == 0) { error = 1; MessageBox.Show("Please fill out all the fields", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (numQty.Value == 0) { error = 1; MessageBox.Show("Please select Item Quantity to return", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cmbporder.SelectedIndex == 0) { error = 1; MessageBox.Show("Please select a Purchase Order Number", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cmbsupname.SelectedIndex == 0) { error = 1; MessageBox.Show("Please select a Supplier Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (error == 0) { int flag = 0; int PurchNo = Convert.ToInt32(cmbporder.SelectedItem); String date = txtdate.Text; int Users_ID = u_id; String supname = cmbsupname.SelectedItem.ToString(); DBSupplier sup = new DBSupplier(); int sup_no = sup.getSupNo(supname); DBPurchaseReturn dp = new DBPurchaseReturn(); int pr_no = dp.setPurchaseReturn(count_tot, count_qty, date, Users_ID, sup_no, PurchNo); DBPurchaseReturns_Item_reference PR_I_ref = new DBPurchaseReturns_Item_reference(); foreach (DataGridViewRow Datarow in dataGridView1.Rows) { if (Datarow.Cells[0].Value != null && Datarow.Cells[1].Value != null && Datarow.Cells[2].Value != null) { // String itemName = dataGridView1.CurrentRow.Cells["Item_Name"].Value.ToString(); int itemno = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Item_No"].Value); int itemqty = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Item_Qty"].Value); int itemtot = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Sub_Total"].Value); DBItem di = new DBItem(); //int itemno = di.getItemNo(itemName); flag = PR_I_ref.setReference(pr_no, itemno, itemqty, itemtot); di.updateQty(itemno, itemqty, txtdate.Text.ToString(), flag); } } } }
private void Purchase_Order_Load(object sender, EventArgs e) { txtdate.Text = System.DateTime.Today.ToString("M/d/yyyy"); DBSupplier ds = new DBSupplier(); DR = ds.getSupplier(); while (DR.Read()) { cmbsupname.Items.Add(DR[0]); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { txtname.Text = dataGridView1.CurrentRow.Cells["Item_Name"].Value.ToString(); txtdes.Text = dataGridView1.CurrentRow.Cells["Item_Description"].Value.ToString(); txtstatus.Text = dataGridView1.CurrentRow.Cells["Item_Status"].Value.ToString(); txtprice.Text = dataGridView1.CurrentRow.Cells["Item_Price"].Value.ToString(); txtqty.Text = dataGridView1.CurrentRow.Cells["Item_Qty"].Value.ToString(); int sup = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Supplier_ID"].Value); no = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Item_No"].Value); DBSupplier ds = new DBSupplier(); String name = ds.getName(sup); comboBox1.SelectedItem = name; }
private void metroButton2_Click(object sender, EventArgs e) { if (cmbsupname.SelectedIndex != 0) { String name = cmbsupname.SelectedItem.ToString(); DBSupplier sup = new DBSupplier(); int sup_id = sup.getSupNo(name); DBPurchases p = new DBPurchases(); DR = p.selectOrder(sup_id); while (DR.Read()) { cmbporder.Items.Add(DR[0].ToString()); } } else { MessageBox.Show("Please select a supplier name ", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void mtUpdate_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Do you want to update?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr.ToString() == "Yes") { if (String.IsNullOrEmpty(txtname.Text) || String.IsNullOrEmpty(txtadd.Text) || String.IsNullOrEmpty(txtstatus.Text) || txttele.Text.Length != 10) { MessageBox.Show("Check if all the fields are filled", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { String name = txtname.Text; String add = txtadd.Text; String status = txtstatus.Text; int tele = Convert.ToInt32(txttele.Text); DBSupplier di = new DBSupplier(); int no = di.getSupNo(name); int line = di.updateSupplier(name, add, status, tele, u_id, no); if (line == 1) { MessageBox.Show("Data entered successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception) { MessageBox.Show("Please enter your data and try again"); } } } this.Hide(); Suppliers s = new Suppliers(); s.setid(u_id); s.Show(); }
private void Items_Load(object sender, EventArgs e) { try { SqlDataAdapter da; DBItem i = new DBItem(); da = i.getItem(); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; DBSupplier s = new DBSupplier(); SqlDataReader DR; DR = s.getSupplier(); while (DR.Read()) { comboBox1.Items.Add(DR[0]); } } catch (Exception) { MessageBox.Show("Please fill out all the fields", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }