-
Notifications
You must be signed in to change notification settings - Fork 0
/
RmConfrm.cs
136 lines (121 loc) · 4.1 KB
/
RmConfrm.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
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 RmConfrm : Form
{
public RmConfrm()
{
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 RmConfrm_Load(object sender, EventArgs e)
{
strsql = "SELECT * FROM RoomCondition";
con = new SqlConnection(strCon);
con.Open();
da = new SqlDataAdapter(strsql, con);
da.Fill(ds, "RoomCondition");
TxtromID.DataBindings.Add(new Binding("Text", ds, "RoomCondition.RoomNumber"));
Txtrmcon.DataBindings.Add(new Binding("Text", ds, "RoomCondition.Condition"));
con.Close();
}
private void btnNew_Click(object sender, EventArgs e)
{
Txtrmcon.Text = "";
TxtromID.Text = "";
}
private void btnFirst_Click(object sender, EventArgs e)
{
this.BindingContext[ds, "RoomCondition"].Position = 0;
}
private void btnprev_Click(object sender, EventArgs e)
{
if (this.BindingContext[ds, "RoomCondition"].Position != 0)
{
this.BindingContext[ds, "RoomCondition"].Position -= 1;
}
else
{
MessageBox.Show("First Record!!!");
}
}
private void btnnext_Click(object sender, EventArgs e)
{
if (this.BindingContext[ds, "RoomCondition"].Position == this.BindingContext[ds, "RoomCondition"].Count)
{
MessageBox.Show("Last Record!!!");
}
else
{
this.BindingContext[ds, "RoomCondition"].Position += 1;
}
}
private void btnLast_Click(object sender, EventArgs e)
{
this.BindingContext[ds, "RoomCondition"].Position = this.BindingContext[ds, "RoomCondition"].Count;
}
private void button1_Click(object sender, EventArgs e)
{
newRow = ds.Tables["RoomCondition"].NewRow();
int ID;
ID = Convert.ToInt32(TxtromID.Text);
SqlCommand cmd;
string qry;
qry = "INSERT INTO RoomCondition(RoomNumber,Condition)VALUES('" + ID + "','" + Txtrmcon.Text + "')";
con.Open();
cmd = new SqlCommand(qry, con);
cmd.ExecuteNonQuery();
da.Fill(ds, "RoomCondition");
con.Close();
MessageBox.Show("Successfully Done!");
}
private void btndel_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
string qry;
con.Open();
int ID;
ID = Convert.ToInt32(TxtromID.Text);
qry = "DELETE FROM RoomCondition WHERE RoomNumber=" + ID;
cmd.CommandText = qry;
cmd.Connection = con;
cmd.ExecuteNonQuery();
ds.Clear();
da.Fill(ds, "RoomCondition");
con.Close();
MessageBox.Show("Successfully Done!");
}
private void BtnEdit_Click(object sender, EventArgs e)
{
int ID;
ID = Convert.ToInt32(TxtromID.Text);
SqlCommand cmd = new SqlCommand();
string qry;
qry = "UPDATE RoomCondition SET Condition='" + Txtrmcon.Text + "'WHERE RoomNumber='" + ID + "'";
con.Open();
cmd.CommandText = qry;
cmd.Connection = con;
cmd.ExecuteNonQuery();
da.Fill(ds, "RoomCondition");
con.Close();
MessageBox.Show("SuccessfullyDone");
}
private void BtnClose_Click(object sender, EventArgs e)
{
Close();
}
}
}