-
Notifications
You must be signed in to change notification settings - Fork 0
/
Orderinpending.cs
176 lines (145 loc) · 5.45 KB
/
Orderinpending.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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
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 Orderinpending : Form
{
public Orderinpending()
{
InitializeComponent();
}
private void Orderinpending_Load(object sender, EventArgs e)
{
credentials();
// TODO: This line of code loads data into the 'websiteProjectFlamingoDataSet2.Orders' table. You can move, or remove it, as needed.
this.ordersTableAdapter1.Fill(this.websiteProjectFlamingoDataSet2.Orders);
// TODO: This line of code loads data into the 'websiteProjectFlamingoDataSet1.Orders' table. You can move, or remove it, as needed.
// this.ordersTableAdapter.Fill(this.websiteProjectFlamingoDataSet1.Orders);
GetItemsinpending();
}
public void GetItemsinpending(/*int ORDERID*/)
{
SqlConnection con = new SqlConnection(Program.CONSTR);
con.Open();
string query = "select * from Orders where HasBeenProcessed='false'";
SqlCommand sc = new SqlCommand(query, con);
DataTable data = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(sc);
adapter.Fill(data);
dataGridView1.DataSource = data;
con.Close();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
public void credentials()
{
Login l1 = new Login();
if (l1.role == "Regular")
{
dataGridView1.Columns[12].Visible = false;
staffToolStripMenuItem.Enabled = false;
}
}
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);
}
}
}
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 feedbackToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
Main m1 = new Main();
m1.Show();
}
private void orderInPendingToolStripMenuItem_Click(object sender, EventArgs e)
{
Orderinpending op = new Orderinpending();
this.Hide();
op.Show();
}
private void orderDeliveredToolStripMenuItem_Click(object sender, EventArgs e)
{
OrderDelivered Od = new OrderDelivered();
this.Hide();
Od.Show();
}
private void addEmployeeToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
AddEmployee a1 = new AddEmployee();
a1.Show();
}
private void deleteEmployeeToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
DeleteEmployee d1 = new DeleteEmployee();
d1.Show();
}
private void markAttendenceToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
Attendence a1 = new Attendence();
a1.Show();
}
private void viewAttendenceToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Hide();
ViewAttendence va = new ViewAttendence();
va.Show();
}
private void feedbackToolStripMenuItem1_Click(object sender, EventArgs e)
{
Feedback f = new Feedback();
this.Hide();
f.Show();
}
}
}