public List <EntityLayers.Room> RoomDelete() { 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 _roomdelObj = new EntityLayers.Room() { _roomID = int.Parse(dr[0].ToString()) }; _listObj1.Add(_roomdelObj); } } return(_listObj1); } catch (Exception) { throw; } finally { _conobj.Close(); } }
protected void ddlRoomID_SelectedIndexChanged(object sender, EventArgs e) { UtilityOperation _utilObj = new UtilityOperation(); List <EntityLayers.Room> _listObj1 = new List <EntityLayers.Room>(); _listObj1 = _utilObj.RetreiveModifyRoom(ddlRoomID.SelectedValue); EntityLayers.Room _roomObj = new EntityLayers.Room(); txtRoomDesc.Text = _listObj1[0]._roomDesc; txtRoomCharges.Text = _listObj1[0]._roomCharges.ToString(); txtRoomServices.Text = _listObj1[0]._roomServices; }
protected void btnModify_Click(object sender, EventArgs e) { AdminOperation _addRoomObj = new AdminOperation(); EntityLayers.Room _entityRoomObj = new EntityLayers.Room() { _roomDesc = txtRoomDesc.Text, _roomID = int.Parse(ddlRoomID.SelectedValue), _roomCharges = decimal.Parse(txtRoomCharges.Text), _roomServices = txtRoomServices.Text }; _addRoomObj.ModifyRoomLinqToSql(_entityRoomObj); Response.Write("<script>alert(' Successfully Modified Room') </script> "); Response.Redirect("AdminHome.aspx"); }