protected void Page_Load(object sender, EventArgs e) { string action = Request.QueryString["action"]; id = int.Parse(Request.QueryString["Wardenid"]); if (!IsPostBack) { DBFunctions db = new DBFunctions(); if (action == "update") { HostelWarden_tbl wrd = db.getWarden(id); wardenname.Text = wrd.Name; wardenphone.Text = wrd.Phone; email.Text = wrd.Email; DropDownHostel.DataSource = db.gethostellist(); DropDownHostel.DataTextField = "Name"; DropDownHostel.DataValueField = "ID"; DropDownHostel.DataBind(); } else { } } }
protected void Page_Load(object sender, EventArgs e) { string action = Request.QueryString["action"]; id = int.Parse(Request.QueryString["Roomid"]); if (!IsPostBack) { DBFunctions db = new DBFunctions(); if (action == "update") { HostelRoom_tbl room = db.getRoom(id); price.Text = room.Price.ToString(); capacity.Text = room.Capacity.ToString(); description.Text = room.RoomDescription; DropDownHostel.DataSource = db.gethostellist(); DropDownHostel.DataTextField = "Name"; DropDownHostel.DataValueField = "ID"; DropDownHostel.DataBind(); } else { } } }
protected void Page_Load(object sender, EventArgs e) { DBFunctions db = new DBFunctions(); int pageStart = 1; int pageEnd = 10; if (!IsPostBack) { if (Request.QueryString.ToString().Contains("page")) { page = Convert.ToInt32(Request.QueryString["page"].ToString()); pageEnd = pageSize * page; pageStart = (pageEnd - pageSize) + 1; } List <HostelRoom_tbl> ds = new List <HostelRoom_tbl>(); ds = db.getroomslist(page - 1, pageSize); literalStart.Text = pageStart.ToString(); literalEnd.Text = pageEnd.ToString(); int tmpPageEnd = 0; tmpPageEnd = pageEnd; pageEnd = db.getRoom_Count(); if (pageEnd > 10) { literalTotal.Text = pageEnd.ToString(); int pagett = 0; pagett = Convert.ToInt16(literalEnd.Text); if (pagett > pageEnd) { literalEnd.Text = pageEnd.ToString(); } } else { if (pageEnd == 0) { literalStart.Text = ""; } literalTotal.Text = pageEnd.ToString(); literalEnd.Text = pageEnd.ToString(); } string tmpUrl = string.Empty; tmpUrl = "AddWarden.aspx?" + Request.QueryString.ToString(); if (tmpUrl.Contains("?page")) { tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("?page")); } StringBuilder listingString = new StringBuilder(); if (ds != null) { loadRooms(ds); } if (pageEnd > 10) { StringBuilder paging = new StringBuilder(); int counterPage = 1; int totalPages = 1; totalPages = (pageEnd / 10) + 1; string urlMain = string.Empty; urlMain = Request.Url.ToString(); if (urlMain.Contains("?page")) { urlMain = urlMain.Remove(urlMain.IndexOf("?page")); } for (int i = 1; i <= totalPages; i++) { string newPageString = string.Empty; if (i == 1) { newPageString = "<li><a aria-label=\"First\" href=\"" + urlMain + "\" ><<</a></li>"; if (page == i) { newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>"; } else { newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>"; } } else if (i == totalPages) { if (page == i) { newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>"; } else { newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>"; } newPageString += "<li><a aria-label=\"Last\" href=\"" + urlMain + "?page=" + totalPages + "\" >>></a></li>"; } else { if (page == i) { newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>"; } else { newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>"; } } counterPage++; paging.Append(newPageString); } literalPaging.Text = paging.ToString(); } DropDownHostel.DataSource = db.gethostellist(); DropDownHostel.DataTextField = "Name"; DropDownHostel.DataValueField = "ID"; DropDownHostel.DataBind(); } }