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 btnupdateroom_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
HostelRoom_tbl htl = new HostelRoom_tbl {ID=id, HostelID = int.Parse(DropDownHostel.SelectedValue), Price = int.Parse(price.Text), Capacity = int.Parse(capacity.Text), RoomDescription = description.Text };
db.updateRoom(htl);
Response.Redirect("RoomsList.aspx");
}
protected void btnupdateroom_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
HostelRoom_tbl htl = new HostelRoom_tbl {
ID = id, HostelID = int.Parse(DropDownHostel.SelectedValue), Price = int.Parse(price.Text), Capacity = int.Parse(capacity.Text), RoomDescription = description.Text
};
db.updateRoom(htl);
Response.Redirect("RoomsList.aspx");
}
protected void btnaddroom_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
//Program_tbl prgram = new Program_tbl { ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormCh.Text, ProgrameType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text };
HostelRoom_tbl room = new HostelRoom_tbl {
RoomNo = int.Parse(RoomNo.Text), HostelID = int.Parse(DropDownHostel.SelectedValue), Price = int.Parse(price.Text), Capacity = int.Parse(capacity.Text), RoomDescription = description.Text
};
db.addroom(room);
Response.Redirect("RoomsList.aspx");
}
public void updateRoom(HostelRoom_tbl hstl)
{
db = new CollegeERPDBEntities();
db.HostelRoom_tbl.Attach(hstl);
// var progrm = db.Program_tbl.Where(x => x.ID == id).FirstOrDefault();
db.Entry(hstl).State = EntityState.Modified;
db.SaveChanges();
}
public void addroom(HostelRoom_tbl hstl)
{
using (db = new CollegeERPDBEntities())
{
db.HostelRoom_tbl.Add(hstl);
db.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
if (Request.QueryString["action"] != null && Request.QueryString["Roomid"] != null)
{
action = Request.QueryString["action"];
id = int.Parse(Request.QueryString["Roomid"]);
}
if (System.Web.HttpContext.Current.User != null)
{
UserID = Membership.GetUser().ProviderUserKey.ToString();
bool LoggedStatus = false;
LoggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (LoggedStatus)
{
DBFunctions db = new DBFunctions();
if (action == "order")
{
HostelRoom_tbl room = db.getRoomById(id);
hostelname.Text = room.Hostel_tbl.Name;
price.Text = room.Price.ToString();
capacity.Text = room.Capacity.ToString();
description.Text = room.RoomDescription;
status.Visible = false;
btnorderroom.Visible = true;
}
else if (action == "reorder")
{
HostelRoom_tbl room = db.getRoomById(id);
hostelname.Text = room.Hostel_tbl.Name;
price.Text = room.Price.ToString();
capacity.Text = room.Capacity.ToString();
description.Text = room.RoomDescription;
btnReorder.Visible = true;
}
else if (action == "Leave")
{
HostelRoom_tbl room = db.getRoomById(id);
hostelname.Text = room.Hostel_tbl.Name;
price.Text = room.Price.ToString();
capacity.Text = room.Capacity.ToString();
description.Text = room.RoomDescription;
//btnReorder.Visible = true;
btnLeaveroom.Visible = true;
}
else if (action == "pending")
{
HostelRoom_tbl room = db.getRoomById(id);
hostelname.Text = room.Hostel_tbl.Name;
price.Text = room.Price.ToString();
capacity.Text = room.Capacity.ToString();
description.Text = room.RoomDescription;
status.Visible = true;
status.InnerText = "Your order is Pending";
btnorderroom.Visible = false;
}
else if (action == "Accepted")
{
HostelRoom_tbl room = db.getRoomById(id);
hostelname.Text = room.Hostel_tbl.Name;
price.Text = room.Price.ToString();
capacity.Text = room.Capacity.ToString();
description.Text = room.RoomDescription;
status.Visible = true;
status.InnerText = "Your order has been accepted";
btnorderroom.Visible = false;
}
else if (action == "reject")
{
HostelRoom_tbl room = db.getRoomById(id);
hostelname.Text = room.Hostel_tbl.Name;
price.Text = room.Price.ToString();
capacity.Text = room.Capacity.ToString();
description.Text = room.RoomDescription;
status.Visible = true;
status.InnerText = "Your order is rejected";
btnorderroom.Visible = false;
}
else
{
}
}
else
{
action = Request.QueryString["action"];
id = int.Parse(Request.QueryString["Roomid"]);
Response.Redirect("../Login.aspx?Redirecturl=Hostel/" + pagename + "?action=" + action + "&Roomid=" + id);
}
}
else
{
action = Request.QueryString["action"];
id = int.Parse(Request.QueryString["Roomid"]);
Response.Redirect("../Login.aspx?Redirecturl=Hostel/" + pagename + "?action=" + action + "&Roomid=" + id);
}
}
protected void btnaddroom_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
//Program_tbl prgram = new Program_tbl { ProgramName = ProgrammeNametxt.Text, SecondChoice = int.Parse(dropdownSecondChoise.SelectedValue), HasCampus = int.Parse(dropdownCampus.SelectedValue), ApplicationFee = txtApplicationFee.Text, FormNumber = txtFormCh.Text, ProgrameType = dropdownPrograms.SelectedValue, HasJambData = int.Parse(dropdownJamb.SelectedValue), HasBioDataSection = int.Parse(dropdownBioData.SelectedValue), HasPreviousRecord = int.Parse(dropdownPreviousRecord.SelectedValue), HasCBTSchedule = int.Parse(dropdownCbtSchedule.SelectedValue), HasOlevelResult = int.Parse(dropdownOlevel.SelectedValue), Enable = true, DeptID = int.Parse(DropDownDept.SelectedValue), CutoffPoints = Cuttofpointstxt.Text, DateCreated = DateTime.Now.Date, AcceptenceFee = txtAcceptenceFee.Text, FormCh = txtFormCh.Text };
HostelRoom_tbl room = new HostelRoom_tbl {RoomNo=int.Parse(RoomNo.Text), HostelID=int.Parse(DropDownHostel.SelectedValue),Price=int.Parse(price.Text),Capacity=int.Parse(capacity.Text),RoomDescription=description.Text};
db.addroom(room);
Response.Redirect("RoomsList.aspx");
}
