private void btninsert2_Click(object sender, EventArgs e)
{
ReservationDetailController re = new ReservationDetailController();
if (string.IsNullOrWhiteSpace(txtreserveid.Text) || string.IsNullOrWhiteSpace(txtcustid.Text) || string.IsNullOrWhiteSpace(txtroomno.Text) || string.IsNullOrWhiteSpace(txtdatein.Text) || string.IsNullOrWhiteSpace(txtdateout.Text))
{
MessageBox.Show("One or More fields are empty");
}
else
{
int i = re.InsertRecord(int.Parse(txtreserveid.Text), int.Parse(txtcustid.Text), comboroomtype.SelectedItem.ToString(), int.Parse(txtroomno.Text), txtdatein.Text, txtdateout.Text);
if (i == -1)
{
// MessageBox.Show("one or more fields are empty");
}
else
{
btninsert2_Click(sender, e);
MessageBox.Show("Record Added");
Random r = new Random();
int num = r.Next(100, 500);
int n = r.Next(100, 500);
int no = r.Next(100, 500);
txtreserveid.Text = num.ToString();
txtcustid.Text = n.ToString();
txtroomno.Text = no.ToString();
comboroomtype.Text = "";
txtdatein.Clear();
txtdateout.Clear();
}
}
}
private void btndelete3_Click(object sender, EventArgs e)
{
cc = new ReservationDetailController();
dt = new DataTable("SearchRecords");
dt.Columns.Add("Reserve_ID", System.Type.GetType("System.String"));
dt.Columns.Add("Customer_ID", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
dt.Columns.Add("Date_in", System.Type.GetType("System.String"));
dt.Columns.Add("Date_out", System.Type.GetType("System.String"));
dataGridView1.DataSource = dt;
btndelete3.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");
btndelete3.Visible = false;
}
}
searchType = 0;
bool flag = false;
ReservationDetail cd = null;
flag = int.TryParse(txtreserveid.Text, out id);
cd = cc.Searchcustomer(id);
if (cd == null)
{
flag = false;
}
else
{
id = cd.Customer_ID;
searchType = 1;
flag = true;
}
if (flag)
{
dt.Rows.Clear();
dt.Rows.Add(new object[] {
cd.Reserve_ID, cd.Customer_ID, cd.Room_Type, cd.Room_Number, cd.Date_In, cd.Date_Out
});
btndelete3.Visible = true;
}
else
{
dt.Rows.Clear();
MessageBox.Show("Record Not Found");
id = -1;
btndelete3.Visible = false;
}
}
private void btnsearch_Click(object sender, EventArgs e)
{
int id;
bool flag = int.TryParse(txtreserveid.Text, out id);
if (!flag)
{
MessageBox.Show("Invalid ID");
return;
}
ReservationDetailController std = new ReservationDetailController();
ReservationDetail i = std.Searchcustomer(id);
if (i != null)
{
a = true;
txtreserveid.Text = i.Reserve_ID.ToString();
}
else
{
a = false;
MessageBox.Show("Record Not Found");
}
ReservationDetailController sc = new ReservationDetailController();
dt = new DataTable();
if (a == true)
{
dt.Columns.Add("Reserve_ID", System.Type.GetType("System.String"));
dt.Columns.Add("Customer_ID", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
dt.Columns.Add("Date_in", System.Type.GetType("System.String"));
dt.Columns.Add("Date_out", System.Type.GetType("System.String"));
List <ReservationDetail> d = sc.GetAllitem();
foreach (var s in d)
{
if (id == s.Reserve_ID)
{
dt.Rows.Add(new object[] { s.Reserve_ID, s.Customer_ID, s.Room_Type, s.Room_Number, s.Date_In, s.Date_Out });
}
}
dataGridView1.DataSource = dt;
}
}
private void btnview_Click(object sender, EventArgs e)
{
ReservationDetailController sc = new ReservationDetailController();
dt = new DataTable();
dt.Columns.Add("Reserve_ID", System.Type.GetType("System.String"));
dt.Columns.Add("Customer_ID", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
dt.Columns.Add("Date_In", System.Type.GetType("System.String"));
dt.Columns.Add("Date_Out", System.Type.GetType("System.String"));
List <ReservationDetail> sd = sc.GetAllitem();
foreach (var s in sd)
{
dt.Rows.Add(new object[] {
s.Reserve_ID, s.Customer_ID, s.Room_Type, s.Room_Number, s.Date_In, s.Date_Out
});
}
dataGridView1.DataSource = dt;
}