public bool AddAdvertisement(string AdvertisementHeader, string AdvertisementBody, string AdvertisementYear, int CourseID, string Author) { var advertisement = new Advertisement(); advertisement.AdvertisementID = 1; advertisement.AdvertisementHeader = AdvertisementHeader; advertisement.AdvertisementBody = AdvertisementBody; advertisement.AdvertisementYear = int.Parse(AdvertisementYear); advertisement.CourseID = CourseID; advertisement.Author = Author; advertisement.AdvertisementDateTime = DateTime.Now; using (CourseContext _db = new CourseContext()) { // add to course var course = (from c in _db.Courses where c.CourseID.Equals(CourseID) select c).First(); course.Advertisements.Add(advertisement); // Add Courses to DB. _db.Advertisements.Add(advertisement); _db.SaveChanges(); } // Success. return true; }
protected void CreateUser_Click(object sender, EventArgs e) { var manager = new UserManager(); var user = new ApplicationUser() { UserName = UserName.Text }; IdentityResult result = manager.Create(user, Password.Text); if (result.Succeeded) { result = manager.AddToRole(user.Id, "Student"); var std = new Student(); std.FirstName = FirstName.Text; std.LastName = lastName.Text; std.UserId = user.Id; std.BirthDate = DateTime.Now; CourseContext cc = new CourseContext(); cc.Students.Add(std); cc.SaveChanges(); IdentityHelper.SignIn(manager, user, isPersistent: false); IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response); } else { ErrorMessage.Text = result.Errors.FirstOrDefault(); } }
public void GetPosts() { Project project = projects.ElementAt(1); CourseContext cc = new CourseContext(); var posts = from p in cc.Posts where p. }
public IQueryable<Team> GetTeams() { string user = HttpContext.Current.User.Identity.GetUserId(); CourseContext cc = new CourseContext(); var student = (from s in cc.Students where s.UserId.Equals(user) select s).First(); return student.Teams.AsQueryable(); }
public IQueryable<Project> getProjects() { CourseContext cc = new CourseContext(); var query = from p in cc.Projects select p; return query; }
public IQueryable<Advertisement> GetAdvertisements() { CourseContext cc = new CourseContext(); int academicYear = 1; if (string.IsNullOrWhiteSpace(Request.QueryString["aYear"])) { academicYear = 1; } else { academicYear = int.Parse(Request.QueryString["aYear"]); } if (academicYear == 1) { var query = from c in cc.Advertisements where c.AdvertisementYear == 1 select c; return query; } else if (academicYear == 2) { var query = from c in cc.Advertisements where c.AdvertisementYear == 2 select c; return query; } else if (academicYear == 3) { var query = from c in cc.Advertisements where c.AdvertisementYear == 3 select c; return query; } else if (academicYear == 4) { var query = from c in cc.Advertisements where c.AdvertisementYear == 4 select c; return query; } else { var query = from c in cc.Advertisements where c.AdvertisementYear == 5 select c; return query; } return null; }
protected void Page_Load(object sender, EventArgs e) { int TeamId = int.Parse(Request.QueryString["TeamId"]); CourseContext cc = new CourseContext(); var projectsquery = from p in cc.Projects where p.TeamId.Equals(TeamId) select p; ProjectsNum = projectsquery.ToList().Count; projects = projectsquery.ToList(); }
public IQueryable<Homework> GetHomeworks() { int teamId = int.Parse(Request.QueryString["teamId"]); CourseContext cc = new CourseContext(); var homeworks = from p in cc.Projects join h in cc.Homeworks on p.HomId equals h.HomId select h; return homeworks; }
protected void Page_Load(object sender, EventArgs e) { int HomId = int.Parse(Request.QueryString["HomId"]); CourseContext cc= new CourseContext(); var homework = (from c in cc.Homeworks where c.HomId.Equals(HomId) select c).First(); HomworkNameLabel.Text = homework.HomeworkName ; HomworkDescLabel.Text = homework.HomeworkDesc; DueDateLabel.Text = "Due Date:"+ homework.DueDate.ToShortDateString(); }
public bool AddPost(string PostText, string AuthorId) { var post = new Post(); post.AuthorId = AuthorId; post.PostDate = DateTime.Now; post.PostText = PostText; using (CourseContext _db = new CourseContext()) { // Add Courses to DB. _db.Posts.Add(post); _db.SaveChanges(); } return true; }
public bool AddHomework(string HomeworkName , string HomeworkDecs, DateTime DueDate ,int CourseId ) { var homework = new Homework(); homework.CourseId = CourseId; homework.Date = DateTime.Now; homework.DueDate = DueDate; homework.HomeworkDesc = HomeworkDecs; homework.HomeworkName = HomeworkName; using (CourseContext _db = new CourseContext()) { // Add Courses to DB. _db.Homeworks.Add(homework); _db.SaveChanges(); } // Success. return true; }
public bool AddCourse(string CourseName, string CourseDesc, string CourseTeacher, string CourseYear, string CourseDep) { var myCourse = new Course(); myCourse.CourseName = CourseName; myCourse.CourseDescription = CourseDesc; // alu myCourse.CourseYear = int.Parse(CourseYear); myCourse.CourseDepartement = CourseDep; using (CourseContext _db = new CourseContext()) { // Add Courses to DB. _db.Courses.Add(myCourse); _db.SaveChanges(); } // Success. return true; }
protected void AddQuestionButton_Click(object sender, EventArgs e) { int CourseId = int.Parse(Request.QueryString["CourseId"]); string userId = HttpContext.Current.User.Identity.GetUserId(); CourseContext cc = new CourseContext(); var student = from c in cc.Students where c.UserId == userId select c; using (CourseContext _db = new CourseContext()) { var question = new Question(); question.AuthorId = userId; question.CourseId= CourseId; question.QuesBody = AddQuestionBody.Text; question.QuesHeader = AddQuestionHeader.Text; _db.Questions.Add(question); _db.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { string userId = User.Identity.GetUserId(); using (CourseContext cc = new CourseContext()) { var std = (from s in cc.Students where s.UserId == userId select s).First(); FirstName.Text = std.FirstName; LastName.Text = std.LastName; BirthDate.Text = std.BirthDate.ToShortDateString(); Email.Text = std.Email; Departement.Text = std.Departement; ACMPoints.Text = std.ACMPoints.ToString(); Bio.Text = std.Bio; } }
public bool AddComment(string CommText, int PostId, string AuthorId) { var comment = new Comment(); comment.AuthorId = AuthorId; comment.CommDate = DateTime.Now; comment.CommText = CommText; comment.PostId = PostId; using (CourseContext _db = new CourseContext()) { var post = (from p in _db.Posts where p.PostId.Equals(PostId) select p).First(); post.Comments.Add(comment); // Add Courses to DB. _db.Comments.Add(comment); _db.SaveChanges(); } // Success. return true; }
protected void RemoveCourseButton_Click(object sender, EventArgs e) { using (var _db = new Project2.Models.CourseContext()) { int courseId = Convert.ToInt16(DropDownRemoveCourse.SelectedValue); var myItem = (from c in _db.Courses where c.CourseID == courseId select c).FirstOrDefault(); if (myItem != null) { _db.Courses.Remove(myItem); _db.SaveChanges(); // Reload the page. string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count()); Response.Redirect(pageUrl + "?CourseAction=remove"); } else { LabelRemoveStatus.Text = "Unable to locate Course."; } } }
public bool AddCourse(string CourseName, string CourseDesc, string CourseTeacherFN,string CourseTeacherLN, string CourseYear, string CourseDep) { var myCourse = new Course(); myCourse.CourseName = CourseName; myCourse.CourseDescription = CourseDesc; myCourse.CourseYear = int.Parse(CourseYear); myCourse.CourseDepartement = CourseDep; using (CourseContext _db = new CourseContext()) { var teacher = (from t in _db.Teachers where t.FirstName.Equals(CourseTeacherFN)&& t.LastName.Equals(CourseTeacherLN) select t).First(); myCourse.Teachers.Add(teacher); teacher.Courses.Add(myCourse); // Add Courses to DB. _db.Courses.Add(myCourse); _db.SaveChanges(); } // Success. return true; }
protected void FollowButton_OnClick(object sender, EventArgs e) { CourseContext cc = new CourseContext(); string userId = Context.User.Identity.GetUserId(); var query = from s in cc.Students where s.UserId == userId select s; var query2 = from c in cc.Courses where c.CourseName == courseName.Text select c; foreach (var std in query) { foreach (var cou in query2) { std.Courses.Add(cou); } } cc.SaveChanges(); }
public IQueryable GetCourses() { var _db = new Project2.Models.CourseContext(); IQueryable query = _db.Courses; return query; }