private void button3_Click(object sender, EventArgs e)
{
//back buttons.....
Form3 f3 = new Form3();
this.Hide();
SqlDataAdapter a = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=5 ", con);
DataTable da = new DataTable();
a.Fill(da);
foreach (DataRow row in da.Rows)
{
f3.listBox1.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter b = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=6 ", con);
DataTable db = new DataTable();
b.Fill(db);
foreach (DataRow row in db.Rows)
{
f3.listBox6.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter c = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=7 ", con);
DataTable dc = new DataTable();
c.Fill(dc);
foreach (DataRow row in dc.Rows)
{
f3.listBox9.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter d = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=8 ", con);
DataTable dd = new DataTable();
d.Fill(dd);
foreach (DataRow row in dd.Rows)
{
f3.listBox12.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter f = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=5 ", con);
DataTable df = new DataTable();
f.Fill(df);
foreach (DataRow row in df.Rows)
{
f3.listBox2.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter g = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=6 ", con);
DataTable dg = new DataTable();
g.Fill(dg);
foreach (DataRow row in dg.Rows)
{
f3.listBox5.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter h = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=7 ", con);
DataTable dh = new DataTable();
h.Fill(dh);
foreach (DataRow row in dh.Rows)
{
f3.listBox8.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter i = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=8 ", con);
DataTable di = new DataTable();
i.Fill(di);
foreach (DataRow row in di.Rows)
{
f3.listBox11.Items.Add(row["HotelName"].ToString());
}
//rating
SqlDataAdapter j = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=5 ", con);
DataTable dj = new DataTable();
j.Fill(dj);
foreach (DataRow row in dj.Rows)
{
f3.listBox3.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter k = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=6 ", con);
DataTable dk = new DataTable();
k.Fill(dk);
foreach (DataRow row in dk.Rows)
{
f3.listBox4.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter l = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=7 ", con);
DataTable dl = new DataTable();
l.Fill(dl);
foreach (DataRow row in dl.Rows)
{
f3.listBox7.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter m = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=8 ", con);
DataTable dm = new DataTable();
m.Fill(dm);
foreach (DataRow row in dm.Rows)
{
f3.listBox10.Items.Add(row["HotelRating"].ToString());
}
f3.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
string place = textBox3.Text;
Place s = db.Places.SingleOrDefault(x => x.PlaceName == place);
if (s != null)
{
//textBox1.Text = s.Id.ToString();
if (place == "Chittagong" || place == "CHITTAGONG" || place == "chittagong")
{
Form2 f2 = new Form2();
this.Hide();
SqlDataAdapter a = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=1 ", con);
DataTable da = new DataTable();
a.Fill(da);
foreach (DataRow row in da.Rows)
{
f2.listBox1.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter b = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=2 ", con);
DataTable db = new DataTable();
b.Fill(db);
foreach (DataRow row in db.Rows)
{
f2.listBox6.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter c = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=3 ", con);
DataTable dc = new DataTable();
c.Fill(dc);
foreach (DataRow row in dc.Rows)
{
f2.listBox9.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter d = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=4 ", con);
DataTable dd = new DataTable();
d.Fill(dd);
foreach (DataRow row in dd.Rows)
{
f2.listBox12.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter f = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=1 ", con);
DataTable df = new DataTable();
f.Fill(df);
foreach (DataRow row in df.Rows)
{
f2.listBox2.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter g = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=2 ", con);
DataTable dg = new DataTable();
g.Fill(dg);
foreach (DataRow row in dg.Rows)
{
f2.listBox5.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter h = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=3 ", con);
DataTable dh = new DataTable();
h.Fill(dh);
foreach (DataRow row in dh.Rows)
{
f2.listBox8.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter i = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=4 ", con);
DataTable di = new DataTable();
i.Fill(di);
foreach (DataRow row in di.Rows)
{
f2.listBox11.Items.Add(row["HotelName"].ToString());
}
//rating
SqlDataAdapter j = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=1 ", con);
DataTable dj = new DataTable();
j.Fill(dj);
foreach (DataRow row in dj.Rows)
{
f2.listBox3.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter k = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=2 ", con);
DataTable dk = new DataTable();
k.Fill(dk);
foreach (DataRow row in dk.Rows)
{
f2.listBox4.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter l = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=3 ", con);
DataTable dl = new DataTable();
l.Fill(dl);
foreach (DataRow row in dl.Rows)
{
f2.listBox7.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter m = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=1 AND Hotel.Id=4 ", con);
DataTable dm = new DataTable();
m.Fill(dm);
foreach (DataRow row in dm.Rows)
{
f2.listBox10.Items.Add(row["HotelRating"].ToString());
}
f2.ShowDialog();
}
else if (place == "Bandorban" || place == "BANDORBAN" || place == "bandorban")
{
Form3 f3 = new Form3();
this.Hide();
SqlDataAdapter a = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=5 ", con);
DataTable da = new DataTable();
a.Fill(da);
foreach (DataRow row in da.Rows)
{
f3.listBox1.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter b = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=6 ", con);
DataTable db = new DataTable();
b.Fill(db);
foreach (DataRow row in db.Rows)
{
f3.listBox6.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter c = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=7 ", con);
DataTable dc = new DataTable();
c.Fill(dc);
foreach (DataRow row in dc.Rows)
{
f3.listBox9.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter d = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName,Hotel.HotelAddress from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=8 ", con);
DataTable dd = new DataTable();
d.Fill(dd);
foreach (DataRow row in dd.Rows)
{
f3.listBox12.Items.Add(row["HotelAddress"].ToString());
}
SqlDataAdapter f = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=5 ", con);
DataTable df = new DataTable();
f.Fill(df);
foreach (DataRow row in df.Rows)
{
f3.listBox2.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter g = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=6 ", con);
DataTable dg = new DataTable();
g.Fill(dg);
foreach (DataRow row in dg.Rows)
{
f3.listBox5.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter h = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=7 ", con);
DataTable dh = new DataTable();
h.Fill(dh);
foreach (DataRow row in dh.Rows)
{
f3.listBox8.Items.Add(row["HotelName"].ToString());
}
SqlDataAdapter i = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=8 ", con);
DataTable di = new DataTable();
i.Fill(di);
foreach (DataRow row in di.Rows)
{
f3.listBox11.Items.Add(row["HotelName"].ToString());
}
//rating
SqlDataAdapter j = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=5 ", con);
DataTable dj = new DataTable();
j.Fill(dj);
foreach (DataRow row in dj.Rows)
{
f3.listBox3.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter k = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=6 ", con);
DataTable dk = new DataTable();
k.Fill(dk);
foreach (DataRow row in dk.Rows)
{
f3.listBox4.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter l = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=7 ", con);
DataTable dl = new DataTable();
l.Fill(dl);
foreach (DataRow row in dl.Rows)
{
f3.listBox7.Items.Add(row["HotelRating"].ToString());
}
SqlDataAdapter m = new SqlDataAdapter("Select Place.Id,Hotel.PlaceId,Hotel.HotelRating,Hotel.HotelName from Place,Hotel Where Place.Id=Hotel.PlaceId AND Place.Id=2 AND Hotel.Id=8 ", con);
DataTable dm = new DataTable();
m.Fill(dm);
foreach (DataRow row in dm.Rows)
{
f3.listBox10.Items.Add(row["HotelRating"].ToString());
}
f3.ShowDialog();
}
}
else
{
MessageBox.Show("Data Not Found");
}
}