public DataSet deleteHotel(HotelEN h, int i) // It will delete the index passed in the view
{
string s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
SqlConnection c = new SqlConnection(s);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(virtdb, "hotel");
DataTable t = new DataTable();
t = virtdb.Tables["hotel"];
t.Rows[i].Delete();
SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
da.Update(virtdb, "hotel");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR: Delete hotel");
}
finally
{
c.Close();
}
return(virtdb);
}
public DataSet updateHotel(HotelEN h, int i)
{
string s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
SqlConnection c = new SqlConnection(s);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(virtdb, "hotel");
DataTable t = new DataTable();
t = virtdb.Tables["hotel"];
t.Rows[i]["Id"] = h.Id;
t.Rows[i]["Id"] = h.Id;
t.Rows[i]["Name"] = h.Name;
t.Rows[i]["City"] = h.City;
t.Rows[i]["Days"] = h.Days;
t.Rows[i]["Phone"] = h.Phone;
t.Rows[i]["Adress"] = h.Address;
t.Rows[i]["Email"] = h.Email;
t.Rows[i]["Stars"] = h.Stars;
t.Rows[i]["Bedrooms"] = h.Bedrooms;
t.Rows[i]["Date"] = h.Date;
SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
da.Update(virtdb, "hotel");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR: Delete hotel");
}
finally
{
c.Close();
}
return(virtdb);
}
public void addHotel(HotelEN h)
{
string s = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ToString();
SqlConnection c = new SqlConnection(s);
DataSet virtdb = new DataSet();
try
{
SqlDataAdapter da = new SqlDataAdapter();
da.Fill(virtdb, "hotel");
DataTable t = new DataTable();
t = virtdb.Tables["hotel"];
DataRow newRow = t.NewRow();
newRow[0] = h.Id;
newRow[1] = h.Name;
newRow[2] = h.City;
newRow[3] = h.Days;
newRow[4] = h.Phone;
newRow[5] = h.Address;
newRow[6] = h.Email;
newRow[7] = h.Stars;
newRow[8] = h.Bedrooms;
newRow[9] = h.Date;
t.Rows.Add(newRow);
SqlCommandBuilder cbuilder = new SqlCommandBuilder(da);
da.Update(virtdb, "hotel");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR: Add hotel");
}
finally
{
c.Close();
}
}
public DataSet showHotels(HotelEN h)
{
string s;
s = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
DataSet virtdb = new DataSet();
SqlConnection c = new SqlConnection(s);
try
{
SqlDataAdapter da = new SqlDataAdapter("select * from Hotel", c);
da.Fill(virtdb, "hotel");
}
catch (Exception ex)
{
ex.ToString();
Console.WriteLine("ERROR: show hotel");
}
finally
{
c.Close();
}
return(virtdb);
}
