public string Update(int userId, string userName, string userEmail, string userPassword, int userType)
{
using (CeLSDEntities dbContext = new CeLSDEntities())
{
try
{
dbContext.Database.Connection.Open();
User user = dbContext.Users.Single <User>(o => o.UserId == userId);
user.UserName = userName;
user.UserEmail = userEmail;
user.UserName = userName;
user.UserPassword = md5.GetMd5Sum(userPassword);
user.UserType = userType;
dbContext.SaveChanges();
return("Success");
}
catch (Exception exp)
{
throw new Exception(exp.Message, exp);
}
finally
{
dbContext.Database.Connection.Close();
}
}
}
public string UnEnroll(int userId, int courseId)
{
using (CeLSDEntities dbContext = new CeLSDEntities())
{
try
{
CoursesUser coursesUser = dbContext.CoursesUsers.Single <CoursesUser>(c => c.UserId == userId && c.CourseId == courseId);
dbContext.CoursesUsers.Remove(coursesUser);
dbContext.SaveChanges();
return("Success");
}
catch (Exception e)
{
throw new Exception(e.InnerException.ToString());
}
}
}
public string UpdatePassword(int userId, string userPassword)
{
using (CeLSDEntities dbContext = new CeLSDEntities())
{
try
{
dbContext.Database.Connection.Open();
User user = dbContext.Users.Single <User>(o => o.UserId == userId);
user.UserPassword = md5.GetMd5Sum(userPassword);
dbContext.SaveChanges();
return("");
}
catch (Exception exp)
{
throw new Exception(exp.Message, exp);
}
}
}
public string Enroll(int userId, int courseId)
{
using (CeLSDEntities dbContext = new CeLSDEntities())
{
try
{
CoursesUser coursesUser = new CoursesUser()
{
UserId = userId,
CourseId = courseId
};
dbContext.CoursesUsers.Add(coursesUser);
dbContext.SaveChanges();
return("Success");
}
catch (Exception e)
{
throw new Exception(e.InnerException.ToString());
}
}
}
public string Insert(string topicName, string topicDocxname, int courseId)
{
using (CeLSDEntities dbContext = new CeLSDEntities())
{
try
{
Topic topic = new Topic()
{
TopicsName = topicName,
TopicsFile = topicDocxname,
CourseId = courseId
};
dbContext.Topics.Add(topic);
dbContext.SaveChanges();
return("Success");
}
catch (Exception exp)
{
throw new Exception(exp.Message, exp);
}
}
}
public string Delete(int courseId)
{
using (CeLSDEntities dbcontext = new CeLSDEntities())
{
try
{
dbcontext.Database.Connection.Open();
Cours course = dbcontext.Courses.Single <Cours>(c => c.CourseId == courseId);
dbcontext.Courses.Remove(course);
dbcontext.SaveChanges();
return("Success");
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
finally
{
dbcontext.Database.Connection.Close();
}
}
}
public string Insert(string courseName, int profesorId)
{
using (CeLSDEntities dbcontext = new CeLSDEntities())
{
try
{
Cours course = new Cours();
course.CourseName = courseName;
var n = dbcontext.Courses.Add(course);
dbcontext.SaveChanges();
var x = dbcontext.Courses.ToList().Last <Cours>();
InsertProfessor(x.CourseId, profesorId);
return("Success");
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
}
public string Insert(string userName, string userEmail, string userPassword, int userType)
{
using (CeLSDEntities dbContext = new CeLSDEntities())
{
try
{
User user = new User()
{
UserName = userName,
UserEmail = userEmail,
UserPassword = md5.GetMd5Sum(userPassword),
UserType = userType
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
return("Success");
}
catch (Exception exp)
{
throw new Exception(exp.Message, exp);
}
}
}
public string InsertProfessor(int courseId, int profesorId)
{
using (CeLSDEntities dbcontext = new CeLSDEntities())
{
try
{
CoursesUser coursesUser = new CoursesUser
{
CourseId = courseId,
UserId = profesorId
};
var n = dbcontext.CoursesUsers.Add(coursesUser);
dbcontext.SaveChanges();
return("Success");
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
}
public string Delete(int userId)
{
using (CeLSDEntities entity = new CeLSDEntities())
{
try
{
entity.Database.Connection.Open();
User person = entity.Users.Single <User>(o => o.UserId == userId);
entity.Users.Remove(person);
entity.SaveChanges();
return("Success");
}
catch (Exception exp)
{
throw new Exception(exp.Message, exp);
}
finally
{
entity.Database.Connection.Close();
}
}
}
