protected void Page_Load(object sender, EventArgs e) { string action = Request.QueryString["action"]; id = int.Parse(Request.QueryString["Requestid"]); DBFunctions db = new DBFunctions(); if (action == "accept") { StudentRoom_Mapping room = db.getRoomRequestById(id); hostelname.Text = room.HostelRoom_tbl.Hostel_tbl.Name; price.Text = room.HostelRoom_tbl.Price.ToString(); capacity.Text = room.HostelRoom_tbl.Capacity.ToString(); dept.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().Department_tbl.Department; acadamicYear.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().AcadamicYear; studentname.Text = room.Candidate_tbl.Name; btnacceptorderroom.Visible = true; } //else if(action=="accepted") //{ // StudentRoom_Mapping room = db.getRoomRequestById(id); // hostelname.Text = room.HostelRoom_tbl.Hostel_tbl.Name; // price.Text = room.HostelRoom_tbl.Price.ToString(); // capacity.Text = room.HostelRoom_tbl.Capacity.ToString(); // dept.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().Department_tbl.Department; // acadamicYear.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().AcadamicYear; // studentname.Text = room.Candidate_tbl.Name; //} else if (action == "reject") { StudentRoom_Mapping room = db.getRoomRequestById(id); hostelname.Text = room.HostelRoom_tbl.Hostel_tbl.Name; price.Text = room.HostelRoom_tbl.Price.ToString(); capacity.Text = room.HostelRoom_tbl.Capacity.ToString(); dept.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().Department_tbl.Department; acadamicYear.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().AcadamicYear; studentname.Text = room.Candidate_tbl.Name; //btnacceptorderroom.Visible = false; btnrejectroom.Visible = true; } else if (action == "acceptleaveroom") { StudentRoom_Mapping room = db.getRoomRequestById(id); hostelname.Text = room.HostelRoom_tbl.Hostel_tbl.Name; price.Text = room.HostelRoom_tbl.Price.ToString(); capacity.Text = room.HostelRoom_tbl.Capacity.ToString(); dept.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().Department_tbl.Department; acadamicYear.Text = room.Candidate_tbl.StudentInfo_tbl.FirstOrDefault().AcadamicYear; studentname.Text = room.Candidate_tbl.Name; //btnacceptorderroom.Visible = false; Acceptbtns.Visible = true; } else { } }
protected void btnLeaveroom_Click(object sender, EventArgs e) { DBFunctions db = new DBFunctions(); StudentRoom_Mapping room = new StudentRoom_Mapping { RomID = id, StudentID = int.Parse(Session["userid"].ToString()), Status = 0 }; db.leaveroom(room); Response.Redirect("ViewRoom.aspx"); }
protected void btnorderroom_Click(object sender, EventArgs e) { DBFunctions db = new DBFunctions(); DatabaseFunctions d = new DatabaseFunctions(); int StudentID = d.GetCandidateID(UserID); if (StudentID != -1) { StudentRoom_Mapping room = new StudentRoom_Mapping { RomID = id, StudentID = StudentID, Status = 0 }; db.placeorder(room); Response.Redirect("ViewRoom.aspx"); } }
public void leaveroom(StudentRoom_Mapping room) { db = new CollegeERPDBEntities(); var stdroom = db.StudentRoom_Mapping.Where(x => x.RomID == room.RomID && x.StudentID == room.StudentID).FirstOrDefault(); stdroom.Status = 2; db.SaveChanges(); var candidate = db.Candidate_tbl.Where(x => x.ID == room.StudentID).FirstOrDefault(); var hstlroom = db.HostelRoom_tbl.Where(x => x.ID == room.RomID).FirstOrDefault(); AdminMails_tbl amail = new AdminMails_tbl { SenderID = room.StudentID, Message = candidate.Name + " has Requested for Leaving Room No." + hstlroom.RoomNo + " in " + hstlroom.Hostel_tbl.Name + " Hostel <br><br> <a href='../Hostel/RoomLeaveRequests.aspx' class='btn btn-primary'>View Room Requests</a> ", Date = DateTime.Now.Date, Subject = "Leave Room Request", Status = 0 }; addadminmail(amail); }
public void placeorder(StudentRoom_Mapping hstl) { using (db = new CollegeERPDBEntities()) { db.StudentRoom_Mapping.Add(hstl); db.SaveChanges(); var candidate = db.Candidate_tbl.Where(x => x.ID == hstl.StudentID).FirstOrDefault(); var hstlroom = db.HostelRoom_tbl.Where(x => x.ID == hstl.RomID).FirstOrDefault(); AdminMails_tbl amail = new AdminMails_tbl { SenderID = hstl.StudentID, Message = candidate.Name + " has Requested for Room No." + hstlroom.RoomNo + " in " + hstlroom.Hostel_tbl.Name + " Hostel <br><br> <a href='../Hostel/RoomRequests.aspx' class='btn btn-primary'>View Room Requests</a>", Date = DateTime.Now.Date, Subject = "Room Request", Status = 0 }; addadminmail(amail); } }