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