/// <summary>
/// Method for Retreiving values for Drop Down List for displaying Room ID
/// </summary>
/// <returns> Returns List of RoomID</returns>
public List <EntityLayers.Room> ModifyRoom()
{
SqlConnection _conobj = new SqlConnection(constr);
try
{
SqlCommand _cmd = new SqlCommand("select RoomID from Room", _conobj);
_conobj.Open();
SqlDataReader dr = _cmd.ExecuteReader();
List <EntityLayers.Room> _listObj1 = new List <EntityLayers.Room>();
if (dr.HasRows)
{
while (dr.Read())
{
EntityLayers.Room _roomObj = new EntityLayers.Room()
{
_roomID = int.Parse(dr[0].ToString())
};
_listObj1.Add(_roomObj);
}
}
return(_listObj1);
}
catch (SqlException)
{
throw;
}
finally
{
_conobj.Close();
}
}
/// <summary>
/// Method to add Rooms using LINQ TO SQL CONCEPT
/// </summary>
/// <param name="_roomObj">It accepts Room object and returns void</param>
public void AddRoomLinqToSql(EntityLayers.Room _roomObj)
{
try
{
DataAccessLayer.RoomDataContext _roomDataContext = new DataAccessLayer.RoomDataContext();
_roomDataContext.sp_AddRoom(_roomObj._roomDesc, _roomObj._roomCharges, _roomObj._roomServices, _roomObj._roomTypeID);
}
catch (Exception)
{
throw;
}
}
protected void btnAddRoom_Click(object sender, EventArgs e)
{
AdminOperation _addRoomObj = new AdminOperation();
EntityLayers.Room _entityRoomObj = new EntityLayers.Room()
{
_roomDesc = txtRoomDesc.Text,
_roomTypeID = int.Parse(ddlRoomType.SelectedValue),
_roomCharges = decimal.Parse(txtRoomCharges.Text),
_roomServices = txtRoomService.Text
};
_addRoomObj.AddRoomLinqToSql(_entityRoomObj);
Response.Write("<script>alert(' Successfully Added Room') </script> ");
Response.Redirect("AdminHome.aspx");
}
/// <summary>
/// Method for Retreiving Values for Modifying Room
/// </summary>
/// <param name="a">Accepts RoomID as Parameter</param>
/// <returns>Returns RoomDescription, RoomCharges, RoomServices </returns>
public List <EntityLayers.Room> RetreiveModifyRoom(string a)
{
SqlConnection _conobj = new SqlConnection(constr);
int id = int.Parse(a);
try
{
SqlCommand _cmd = new SqlCommand("select RoomDescription,RoomCharges, RoomServices from Room where RoomID = " + id, _conobj);
_conobj.Open();
SqlDataReader dr = _cmd.ExecuteReader();
List <EntityLayers.Room> _listObj1 = new List <EntityLayers.Room>();
if (dr.HasRows)
{
while (dr.Read())
{
EntityLayers.Room _roomObj = new EntityLayers.Room()
{
_roomDesc = dr.GetString(0),
_roomCharges = dr.GetDecimal(1),
_roomServices = dr.GetString(2)
};
_listObj1.Add(_roomObj);
}
}
return(_listObj1);
}
catch (SqlException)
{
throw;
}
finally
{
_conobj.Close();
}
}
/// <summary>
/// Method to Modify Rooms using LINQ TO SQL CONCEPT
/// </summary>
/// <param name="_roomObj">It accepts Room object and returns void</param>
public void ModifyRoomLinqToSql(EntityLayers.Room _roomObj)
{
DataAccessLayer.RoomDataContext _roomDataContext = new DataAccessLayer.RoomDataContext();
_roomDataContext.sp_ModifyRoom(_roomObj._roomID, _roomObj._roomDesc, _roomObj._roomCharges, _roomObj._roomServices);
}
