public IQueryable<WebApplication1.HalonModels.Firefighter> GetFirefighters() { HalonContext _db = new HalonContext(); IQueryable<WebApplication1.HalonModels.Firefighter> firefighters = _db.Firefighters; IQueryable<WebApplication1.HalonModels.Firefighter> ffquery = _db.Firefighters; string firefighter_UName = Page.User.Identity.Name; ffquery = ffquery.Where(f => f.Firefighter_Account_Username.Equals(firefighter_UName)); firefighters = firefighters.Where(f => f.Dept_ID == ffquery.FirstOrDefault().Dept_ID); return firefighters; }
public IQueryable<WebApplication1.HalonModels.Department> GetDepartments() { HalonContext _db = new HalonContext(); IQueryable<WebApplication1.HalonModels.Firefighter> ffquery = _db.Firefighters; string firefighter_UName = Page.User.Identity.Name; ffquery = ffquery.Where(f => f.Firefighter_Account_Username.Equals(firefighter_UName)); int dept_id = Convert.ToInt32(ffquery.First().Dept_ID); IQueryable<WebApplication1.HalonModels.Department> depts = _db.Departments.Where(p => p.Dept_ID == dept_id); return depts; }
private bool EditCounty(string countyId, string name, string stateID) { var _db = new WebApplication1.HalonModels.HalonContext(); int county_ID = Convert.ToInt32(countyId); var myCounty = (from c in _db.Counties where c.County_ID == county_ID select c).FirstOrDefault(); myCounty.County_Name = name; myCounty.State_ID = Convert.ToInt32(stateID); // Add product to DB. _db.SaveChanges(); // Success. return true; }
private bool AddCounty(string name, string stateID) { var _db = new WebApplication1.HalonModels.HalonContext(); HalonModels.County myCounty = new HalonModels.County(); myCounty.County_Name = name; myCounty.State_ID = Convert.ToInt32(stateID); // Add product to DB. _db.Counties.Add(myCounty); _db.SaveChanges(); // Success. return true; }
public IQueryable<WebApplication1.HalonModels.Firefighter> GetFirefighterInfo([QueryString("Firefighter_ID")]int? firefighterId) { var _db = new WebApplication1.HalonModels.HalonContext(); IQueryable<WebApplication1.HalonModels.Firefighter> query = _db.Firefighters; if (firefighterId.HasValue && firefighterId > 0) { query = query.Where(f => f.Firefighter_ID == firefighterId); } else { query = null; } return query; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int county = Convert.ToInt16(Request.QueryString["CountyId"]); if (!(county == 0)) { countyAddTitle.InnerHtml = "<h1>Edit County</h1>"; AddCountyButton.Text = "Edit County"; var db = new HalonContext(); var myCounty = (from c in db.Counties where c.County_ID == county select c).FirstOrDefault(); StateDD.SelectedValue = myCounty.State_ID.ToString(); AddCounty_Name.Text = myCounty.County_Name; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int enrollmentId = Convert.ToInt16(Request.QueryString["EnrollmentId"]); AddEnrollmentButton.Text = "Add Enrollment"; if (!(enrollmentId == 0)) { enrollmentAddTitle.InnerHtml = "<h1>Edit Enrollment</h1>"; AddEnrollmentButton.Text = "Edit Enrollment"; var db = new HalonContext(); var myEnrollment = (from c in db.Enrollments where c.Enrollment_ID == enrollmentId select c).FirstOrDefault(); AddFirefighterID.Text = myEnrollment.Firefighter_ID.ToString(); AddClassID.Text = myEnrollment.Class_ID.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int classId = Convert.ToInt16(Request.QueryString["ClassId"]); if (!(classId == 0)) { classAddTitle.InnerHtml = "<h1>Edit Class</h1>"; var db = new HalonContext(); var myClass = (from c in db.Classes where c.Class_ID == classId select c).FirstOrDefault(); DropDownAddCourse.SelectedValue = myClass.Course_ID.ToString(); AddClassDate.Text = myClass.Class_Date; AddClassNote.Text = myClass.Class_ID.ToString(); AddClassCancel.Checked = myClass.Class_Cancelled; AddClassNote.Text = myClass.Class_Note; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int courseID = Convert.ToInt16(Request.QueryString["CourseID"]); if (!(courseID == 0)) { AddCourseHeader.Text = "Update Course:"; AddCourseButton.Text = "Update Course"; var db = new HalonContext(); var myCourse = (from c in db.Courses where c.Course_ID == courseID select c).FirstOrDefault(); AddCourseName.Text = myCourse.Course_Name.ToString(); if (myCourse.Course_Discontinued) AddCourseDiscontinued.SelectedIndex = 1; else AddCourseDiscontinued.SelectedIndex = 0; AddCourseCreditHours.Text = myCourse.Course_Credit_Hours.ToString(); } } }
protected void AddClassButton_Click(object sender, EventArgs e) { int classId = Convert.ToInt16(Request.QueryString["ClassId"]); EditClass edit = new EditClass(); bool editSuccess; var db = new WebApplication1.HalonModels.HalonContext(); IQueryable<WebApplication1.HalonModels.Firefighter> ffquery = db.Firefighters; string firefighter_UName = Page.User.Identity.Name; ffquery = ffquery.Where(f => f.Firefighter_Account_Username.Equals(firefighter_UName)); string firefighter_ID = ffquery.First().Firefighter_ID.ToString(); if (classId == 0) { editSuccess = edit.EditClasses(AddClassCancel.Checked, firefighter_ID, DropDownAddCourse.SelectedValue.ToString(), AddClassNote.Text, AddClassDate.Text); } else { editSuccess = edit.EditClasses(classId.ToString(), AddClassCancel.Checked, firefighter_ID, DropDownAddCourse.SelectedValue.ToString(), AddClassNote.Text, AddClassDate.Text); } if (editSuccess) { // Reload the page. Response.Redirect("/Instructor/Class/Class_Display.aspx"); } }
public void GetTeachers() { var _db = new WebApplication1.HalonModels.HalonContext(); IQueryable<WebApplication1.HalonModels.Firefighter> ffquery = _db.Firefighters; string firefighter_UName = Page.User.Identity.Name; ffquery = ffquery.Where(f => f.Firefighter_Account_Username.Equals(firefighter_UName)); IQueryable<WebApplication1.HalonModels.Firefighter> ffighters = _db.Firefighters; ffighters = ffighters.Where(f => f.Firefighter_Account_Username != null); List<HalonModels.Firefighter> returnList = new List<HalonModels.Firefighter>(); foreach (HalonModels.Firefighter f in ffighters) { if (Roles.GetRolesForUser(f.Firefighter_Account_Username)[0] != "User") { returnList.Add(f); } } IQueryable<HalonModels.Firefighter> query = _db.Firefighters; query = returnList.AsQueryable<HalonModels.Firefighter>(); List<HalonModels.Firefighter> list = query.ToList(); DropDownAddTeacher.DataSource = list; DropDownAddTeacher.DataValueField = "Firefighter_ID"; DropDownAddTeacher.DataBind(); for (int i = 0; i < list.Count; i++) { DropDownAddTeacher.Items[i].Text = list[i].Firefighter_Fname + " " + list[i].Firefighter_Lname; } }
public IQueryable<HalonModels.State> GetStates() { var db = new WebApplication1.HalonModels.HalonContext(); IQueryable<HalonModels.State> query = db.States; return query; }
public IQueryable<HalonModels.Class> GetClasses() { var db = new WebApplication1.HalonModels.HalonContext(); IQueryable<HalonModels.Class> query = db.Classes; return query; }