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