public void ChecksOrderidValidorInvalid(int Searchorderid) { int temp = 0; int count = 0; SqlConnection con = new SqlConnection(Program.CONSTR); con.Open(); string query = "select Orders.OrderId from Orders"; SqlCommand sc = new SqlCommand(query, con); SqlDataReader sd = sc.ExecuteReader(); if (sd.HasRows) { while (sd.Read()) { temp = sd.GetInt32(0); if (temp == Searchorderid) { OrderDelivered od = new OrderDelivered(); od.orderid = int.Parse(SearchByorderid_EnterOrderid.Text); OrderDetails OR = new OrderDetails(); this.Hide(); OR.Show(); count = 1; } } if (count==0) { MessageBox.Show("Order Id not Founded"); } } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 11) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; Orderid = int.Parse(row.Cells["orderIdDataGridViewTextBoxColumn"].Value.ToString()); OrderDetails OD = new OrderDetails(); this.Hide(); OD.Show(); } /* if (e.ColumnIndex == 12) { DialogResult Result = MessageBox.Show("Are you sure to delete order", "Delete order", MessageBoxButtons.YesNo); if (Result == DialogResult.Yes) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; Orderid = int.Parse(row.Cells["orderIdDataGridViewTextBoxColumn"].Value.ToString()); /*OrderDetails OD = new OrderDetails(); this.Hide(); OD.Show(); deleteorder(orderid); deletedetailsfromOrderDetails(orderid); } } } public void deletedetailsfromOrderDetails(int ORDERID) { SqlConnection con = new SqlConnection(Program.CONSTR); con.Open(); string query = "delete from OrderDetails where OrderDetails.OrderId=" + ORDERID; SqlCommand sc = new SqlCommand(query, con); sc.ExecuteNonQuery(); con.Close(); } public void deleteorder(int ORDERID) //delete order from database { SqlConnection con = new SqlConnection(Program.CONSTR); con.Open(); string query = "delete from Orders where Orders.OrderId=" + ORDERID; SqlCommand sc = new SqlCommand(query, con); sc.ExecuteNonQuery(); con.Close(); }*/ }
private void button2_Click(object sender, EventArgs e) { OrderDetails od = new OrderDetails(); this.Hide(); od.Show(); }
private void dataGridView1_CellContentClick_1(object sender, DataGridViewCellEventArgs e) { OrderDelivered o1 = new OrderDelivered(); if (e.ColumnIndex == 11) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; o1.orderid = int.Parse(row.Cells["orderIdDataGridViewTextBoxColumn"].Value.ToString()); OrderDetails OD = new OrderDetails(); this.Hide(); OD.Show(); } if (e.ColumnIndex == 12) { DialogResult Result = MessageBox.Show("Are you sure to delete order", "Delete order", MessageBoxButtons.YesNo); if (Result == DialogResult.Yes) { DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex]; o1.orderid = int.Parse(row.Cells["orderIdDataGridViewTextBoxColumn"].Value.ToString()); /*OrderDetails OD = new OrderDetails(); this.Hide(); OD.Show();*/ deleteorder(o1.orderid); deletedetailsfromOrderDetails(o1.orderid); } } }