-
Notifications
You must be signed in to change notification settings - Fork 0
/
Rmlistfrm.cs
158 lines (148 loc) · 5.22 KB
/
Rmlistfrm.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
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace Reception
{
public partial class Rmlistfrm : Form
{
public Rmlistfrm()
{
InitializeComponent();
}
DataSet ds = new DataSet();
string strsql;
string strCon = "Data Source=.;Initial Catalog=ProjectREC;Integrated Security=True";
SqlDataAdapter da;
SqlConnection con;
DataRow newRow;
private void Rmlistfrm_Load(object sender, EventArgs e)
{
txtroomnumber.ReadOnly = true;
strsql = "SELECT * FROM Rooms";
con = new SqlConnection(strCon);
con.Open();
da = new SqlDataAdapter(strsql, con);
da.Fill(ds, "Rooms");
txtroomnumber.DataBindings.Add(new Binding("Text", ds, "Rooms.RoomNumber"));
txtsitnum.DataBindings.Add(new Binding("Text", ds, "Rooms.SituationNumber"));
txttype.DataBindings.Add(new Binding("Text", ds, "Rooms.RoomType"));
txtprice.DataBindings.Add(new Binding("Text", ds, "Rooms.RoomPrice"));
con.Close();
}
private void btnInsert_Click(object sender, EventArgs e)
{
try
{
newRow = ds.Tables["Rooms"].NewRow();
int ID;
SqlCommand cmd;
ID = Convert.ToInt32(txtroomnumber.Text);
string qry;
qry = "INSERT INTO Rooms(RoomNumber,RoomType,SituationNumber,RoomPrice)VALUES('" + ID + "','" + txttype.Text + "','"
+ txtsitnum.Text + "','" + txtprice.Text + "')";
con.Open();
cmd = new SqlCommand(qry, con);
cmd.ExecuteNonQuery();
da.Fill(ds, "Rooms");
con.Close();
MessageBox.Show("Successfully Done");
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void nextbtn_Click(object sender, EventArgs e)
{
this.BindingContext[ds, "Rooms"].Position += 1;
//Baraye inke be akharin record residim eror nemidahad
if (this.BindingContext[ds, "Rooms"].Position == this.BindingContext[ds, "Rooms"].Count)
{
MessageBox.Show("Last Record!!!");
}
}
private void LastBTN_Click(object sender, EventArgs e)
{
this.BindingContext[ds, "Rooms"].Position = this.BindingContext[ds, "Rooms"].Count;
MessageBox.Show("Last Record!!!");
}
private void prevbtn_Click(object sender, EventArgs e)
{
this.BindingContext[ds, "Rooms"].Position -= 1;
if (this.BindingContext[ds, "Rooms"].Position == 0)
{
MessageBox.Show("First Record!!!");
}
}
private void FirstBtn_Click(object sender, EventArgs e)
{
this.BindingContext[ds, "Rooms"].Position = 0;
}
private void editBTN_Click(object sender, EventArgs e)
{
try
{
int ID;
SqlCommand cmd;
ID = Convert.ToInt32(txtroomnumber.Text);
string qry;
qry = "UPDATE Rooms SET RoomType='" + txttype.Text + "',SituationNumber='" + txtsitnum.Text + "',Price='" + txtprice.Text + "'WHERE RoomNumber='" + ID + "'";
con.Open();
cmd = new SqlCommand(qry, con);
cmd.ExecuteNonQuery();
da.Fill(ds, "Rooms");
con.Close();
MessageBox.Show("Successfully Done");
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void deletebtn_Click(object sender, EventArgs e)
{
try
{
SqlCommand cmd = new SqlCommand();
string QryDel;
con.Open();
int UserID;
UserID = Convert.ToInt32(txtroomnumber.Text);
QryDel = "DELETE FROM Rooms WHERE RoomNumber=" + UserID;
cmd.CommandText = QryDel;
cmd.Connection = con;
cmd.ExecuteNonQuery();
ds.Clear();
da.Fill(ds, "Rooms");
con.Close();
MessageBox.Show("Successfully Done");
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void newbtn_Click(object sender, EventArgs e)
{
int ID;
ID = Convert.ToInt32(this.BindingContext[ds, "Rooms"].Count);
ID += 1;
txtroomnumber.Text = ID.ToString();
txtprice.Text = "";
txtsitnum.Text = "";
txttype.Text = "";
txtroomnumber.ReadOnly = false;
}
private void rmcondition_Click(object sender, EventArgs e)
{
Form objrmcondition = new RmConfrm();
objrmcondition.Show();
}
}
}