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