protected void createroombtn_Click(object sender, EventArgs e)
{
Room r = new Room();
r.Roomnum = rnotbx.Text;
r.Roomtype = rttbx.Text;
r.Roomclass = rctbx.Text;
r.Numofbed = Convert.ToInt32(nobtbx.Text);
r.Bedtype = tobtbx.Text;
r.Roomstatus = rstbx.Text;
r.Roomrate = rrtbx.Text;
if (SWENDbmanager.InsertRoom(r) == 1)
{
lblSuccessful.Text = "Room Creation Completed..";
}
else
{
lblSuccessful.Text = "Room Creation Failed..";
}
}
public static int InsertRoom(Room r)
{
int rowsinserted = 0;
SqlConnection conn = null;
try
{
conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["SWENConnectionString"].ConnectionString;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "INSERT INTO Room(roomnum,roomtype,roomclass,numofbed,bedtype,roomrate,roomstatus)" +
" VALUES (@roomnum,@roomtype,@roomclass,@numofbed,@bedtype,@roomrate,@roomstatus)";
comm.Parameters.AddWithValue("@roomnum", r.Roomnum);
comm.Parameters.AddWithValue("@roomtype", r.Roomtype);
comm.Parameters.AddWithValue("@roomclass", r.Roomclass);
comm.Parameters.AddWithValue("@numofbed", r.Numofbed);
comm.Parameters.AddWithValue("@bedtype", r.Bedtype);
comm.Parameters.AddWithValue("@roomrate", r.Roomrate);
comm.Parameters.AddWithValue("@roomstatus",r.Roomstatus);
rowsinserted = comm.ExecuteNonQuery();
conn.Close();
}
catch (SqlException e)
{
throw e;
}
return rowsinserted;
}
public static int UpdateRoomStatus(Room r)
{
int rowsupdated = 0;
SqlConnection conn = null;
try
{
conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["SWENConnectionString"].ConnectionString;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "UPDATE Room SET roomstatus=@roomstatus WHERE roomnum=@roomnum";
comm.Parameters.AddWithValue("@roomnum",r.Roomnum);
comm.Parameters.AddWithValue("@roomstatus",r.Roomstatus);
rowsupdated = comm.ExecuteNonQuery();
conn.Close();
}
catch (SqlException e)
{
throw e;
}
return rowsupdated;
}
public static Room GetRoomByNum(string roomnum)
{
Room r = new Room();
SqlConnection conn = null;
try
{
conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["SWENConnectionString"].ConnectionString;
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "SELECT * FROM Room WHERE roomnum=@roomnum";
comm.Parameters.AddWithValue("@roomnum", roomnum);
SqlDataReader dr = comm.ExecuteReader();
if (dr.Read())
{
r.Roomnum = (string)dr["roomnum"];
r.Roomtype = (string)dr["roomtype"];
r.Roomclass = (string)dr["roomclass"];
r.Numofbed = (int)dr["numofbed"];
r.Bedtype = (string)dr["bedtype"];
r.Roomrate = (string)dr["roomrate"];
r.Roomstatus = (string)dr["roomstatus"];
r.Roomid = (int)dr["roomid"];
}
dr.Close();
}
catch (SqlException e)
{
throw e;
}
return r;
}