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);
}
}
}
