public List <Showrooms> getAllShowroom()
{
List <Showrooms> slist = new List <Showrooms>();
string fname, lname;
int showid, slot, pax;
DateTime date;
string queryStr = "SELECT s.*, c.fName, c.lName FROM Showroom s INNER JOIN Customer c ON s.cID = c.cID";
SqlConnection con = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(queryStr, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
showid = int.Parse(dr["showId"].ToString());
slot = int.Parse(dr["slot"].ToString());
pax = int.Parse(dr["pax"].ToString());
date = DateTime.Parse(dr["date"].ToString());
fname = dr["fName"].ToString();
lname = dr["lName"].ToString();
Showrooms s = new Showrooms(showid, slot, pax, date, fname, lname);
slist.Add(s);
}
con.Close();
dr.Close();
dr.Dispose();
return(slist);
}
public Showrooms getBooking(int s, DateTime d)
{
Showrooms sr = null;
int slot;
DateTime date;
string queryStr = "SELECT * FROM Showroom WHERE slot = @slot AND date = @date";
SqlConnection con = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(queryStr, con);
cmd.Parameters.AddWithValue("@slot", s);
cmd.Parameters.AddWithValue("@date", d);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows && dr.Read())
{
slot = int.Parse(dr["slot"].ToString());
date = DateTime.Parse(dr["date"].ToString());
sr = new Showrooms(slot, date);
}
else
{
sr = null;
}
con.Close();
dr.Close();
dr.Dispose();
return(sr);
}
public void SetList(IEnumerable <showroom> showrooms)
{
Showrooms = showrooms.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
});
var selectedShowroom = ShowroomId.ToString();
if (showrooms.Count() > 0 && selectedShowroom != Guid.Empty.ToString())
{
Showrooms.Where(x => x.Value == selectedShowroom).FirstOrDefault().Selected = true;
}
}
protected void btn_submit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
acc = (Account)Session["Id"];
int slot = 0;
switch (lbl_slot.Text)
{
case "9AM":
slot = 1;
break;
case "12PM":
slot = 2;
break;
case "3PM":
slot = 3;
break;
case "6PM":
slot = 4;
break;
}
DateTime d = DateTime.Parse(lbl_date.Text);
Showrooms sr = new Showrooms();
showr = sr.getBooking(slot, d);
lbl_msg.Visible = true;
if (showr != null)
{
lbl_msg.Text = "Slot is already taken";
}
else
{
sr = new Showrooms(acc.gsID, slot, int.Parse(tb_pax.Text), d);
sr.insertShowroom();
InputValidation.ClearInputs(this.Controls);
lbl_date.Text = "";
lbl_slot.Text = "";
lbl_msg.Text = "Booking Success!";
}
}
}
