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