private void btnroominsert_Click(object sender, EventArgs e)
{
RoomDetailController room = new RoomDetailController();
if (string.IsNullOrWhiteSpace(txtnumber.Text) || string.IsNullOrWhiteSpace(txtphoneno.Text))
{
MessageBox.Show("One or More fields are empty");
}
else
{
int i = room.InsertRecord(int.Parse(txtnumber.Text), comboroomtype.SelectedItem.ToString(), txtphoneno.Text, cmbreserved.SelectedItem.ToString());
if (i == -1)
{
// MessageBox.Show("one or more fields are empty");
}
else
{
btnroominsert_Click(sender, e);
MessageBox.Show("Record Added");
Random r = new Random();
int num = r.Next(100, 500);
txtnumber.Text = num.ToString();
comboroomtype.Text = "";
txtphoneno.Clear();
cmbreserved.Text = "";
}
}
}
private void button3_Click(object sender, EventArgs e)
{
cc = new RoomDetailController();
dt = new DataTable("SearchRecords");
dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
dt.Columns.Add("Phone", System.Type.GetType("System.String"));
dt.Columns.Add("Reserved", System.Type.GetType("System.String"));
dataGridView1.DataSource = dt;
btndelete.Visible = false;
DialogResult dr = MessageBox.Show("You want to delete the record ?", "Confirm", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
if (id != -1)
{
cc.DeleteRecord(id);
dt.Rows.Clear();
MessageBox.Show("Record Deleted");
btndelete.Visible = false;
}
}
searchType = 0;
bool flag = false;
RoomDetail cd = null;
flag = int.TryParse(txtnumber.Text, out id);
cd = cc.Searchcustomer(id);
if (cd == null)
{
flag = false;
}
else
{
id = cd.Room_Number;
searchType = 1;
flag = true;
}
if (flag)
{
dt.Rows.Clear();
dt.Rows.Add(new object[] {
cd.Room_Number, cd.Room_Type, cd.Phone, cd.Reserved
});
btndelete.Visible = true;
}
else
{
dt.Rows.Clear();
MessageBox.Show("Record Not Found");
id = -1;
btndelete.Visible = false;
}
}
private void btnsearch_Click(object sender, EventArgs e)
{
int id;
bool flag = int.TryParse(txtnumber.Text, out id);
if (!flag)
{
MessageBox.Show("Invalid ID");
return;
}
RoomDetailController std = new RoomDetailController();
RoomDetail i = std.Searchcustomer(id);
if (i != null)
{
a = true;
txtnumber.Text = i.Room_Number.ToString();
}
else
{
a = false;
MessageBox.Show("Record Not Found");
}
RoomDetailController sc = new RoomDetailController();
dt = new DataTable();
if (a == true)
{
dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
dt.Columns.Add("Phone", System.Type.GetType("System.String"));
dt.Columns.Add("Reserved", System.Type.GetType("System.String"));
List <RoomDetail> d = sc.GetAllitem();
foreach (var s in d)
{
if (id == s.Room_Number)
{
dt.Rows.Add(new object[] { s.Room_Number, s.Room_Type, s.Phone, s.Reserved });
}
}
dataGridView1.DataSource = dt;
}
}
private void View_Click(object sender, EventArgs e)
{
RoomDetailController sc = new RoomDetailController();
dt = new DataTable();
dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
dt.Columns.Add("Phone", System.Type.GetType("System.String"));
dt.Columns.Add("Reserved", System.Type.GetType("System.String"));
List <RoomDetail> sd = sc.GetAllitem();
foreach (var s in sd)
{
dt.Rows.Add(new object[] {
s.Room_Number, s.Room_Type, s.Phone, s.Reserved
});
}
dataGridView1.DataSource = dt;
}