private void ViewSOrder_Load(object sender, EventArgs e) { DBSales s = new DBSales(); SqlDataAdapter da; da = s.getSalesOrders(); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; }
private void mtadd_Click_1(object sender, EventArgs e) { int flag = 1, error = 0; String date = txtdate.Text; String status = txtstatus.Text; DBSales ds = new DBSales(); if (txtqty.Text.Length == 0 && txtprice.Text.Length == 0 && txtstatus.Text.Length == 0) { MessageBox.Show("Check if all the fields are filled", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); error = 1; } if (txtprice.Text.Any(Char.IsLetter)) { MessageBox.Show("Price cannot contain letters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); error = 1; } if (txtqty.Text.Any(Char.IsLetter)) { error = 1; MessageBox.Show("Quantity cannot contain letters", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cmbitemname.SelectedIndex == 0) { error = 1; MessageBox.Show("Please select an Item Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (error == 1) { MessageBox.Show("Check if all the fields are filled correctly", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int so_no = ds.setSalesOrder(date, status, count_tot, count_qty, u_id, no); DBSales_Item_reference S_I_ref = new DBSales_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["itemName"].Value.ToString(); int itemqty = Convert.ToInt32(dataGridView1.CurrentRow.Cells["itemQty"].Value); int itemtot = Convert.ToInt32(dataGridView1.CurrentRow.Cells["itemPrice"].Value); DBItem di = new DBItem(); int itemno = di.getItemNo(itemName); S_I_ref.setReference(so_no, itemno, itemqty, itemtot); di.updateQty(itemno, itemqty, txtdate.Text.ToString(), flag); } } } }
private void metroButton2_Click(object sender, EventArgs e) { DBCustomer c = new DBCustomer(); cusno = c.getCusNo(cmbcusnic.SelectedItem.ToString()); DBSales s = new DBSales(); DR = s.getSalesOrder(cusno); while (DR.Read()) { cmbsorder.Items.Add(Convert.ToInt32(DR[0])); } }
private void Delivery_Load(object sender, EventArgs e) { txtdate.Text = System.DateTime.Now.ToString("MM/dd/yyyy"); DBSales s = new DBSales(); SqlDataReader DR; DR = s.getSalesOrderID(); while (DR.Read()) { cmbsalesorder.Items.Add(DR[0]); } SqlDataAdapter da; DBDelivery i = new DBDelivery(); da = i.getDelivery(); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; }