-
Notifications
You must be signed in to change notification settings - Fork 0
/
DeleteItem.cs
107 lines (90 loc) · 3.45 KB
/
DeleteItem.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace FlamingoWF
{
public partial class DeleteItem : Form
{
public DeleteItem()
{
InitializeComponent();
}
private void DeleteItem_Load(object sender, EventArgs e)
{
OrderDelivered od = new OrderDelivered();
int orderid= od.orderid;
GetItemsDetails(orderid);
}
public void GetItemsDetails(int ORDERID)
{
SqlConnection con = new SqlConnection(Program.CONSTR);
con.Open();
string query = "select OrderDetails.OrderDetailId ,Categories.CategoryName , FoodItems.ItemName ,FoodItems.UnitPrice as Price, OrderDetails.Quantity from Orders inner join OrderDetails on Orders.OrderId=OrderDetails.OrderId inner join FoodItems on FoodItems.ItemID=OrderDetails.ItemId inner join Categories on Categories.CategoryID = FoodItems.CategoryId where OrderDetails.OrderId =" + ORDERID;
SqlCommand sc = new SqlCommand(query, con);
DataTable data = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sc);
adapter.Fill(data);
dataGridView1.DataSource = data;
con.Close();
}
public void FetchingOrderDetailid(int ORDERID)
{
int count = 0;
SqlConnection con = new SqlConnection(Program.CONSTR);
con.Open();
string query = "select OrderDetails.OrderDetailId from OrderDetails where OrderDetails.OrderId =" + ORDERID;
SqlCommand sc = new SqlCommand(query, con);
SqlDataReader sd = sc.ExecuteReader();
if (sd.HasRows)
{
while (sd.Read())
{
string temp = sd.GetInt32(0).ToString() ;
try
{
if (temp == Deleteitem_EnterId.Text)
{
SqlConnection con1 = new SqlConnection(Program.CONSTR);
con1.Open();
string query1 = "DELETE from OrderDetails where OrderDetails.OrderDetailId=" + temp;
SqlCommand sc1 = new SqlCommand(query1, con1);
sc1.ExecuteNonQuery();
con1.Close();
MessageBox.Show("Delete Sucuessfully");
count = 1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
if (count == 0)
{
MessageBox.Show("Order detail id invalid");
}
sd.Close();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OrderDelivered od = new OrderDelivered();
int orderid = od.orderid;
FetchingOrderDetailid(orderid);
}
private void button2_Click(object sender, EventArgs e)
{
OrderDetails od = new OrderDetails();
this.Hide();
od.Show();
}
}
}