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