/// <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); }