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