// To Participate in Course
public bool ParticipateInCourse(string Token, long CourseID)
{
bool isParticipated = false;
try
{
long UserID = Utility.GetUserIDByToken(Token);
if (UserID > 0 && CourseID > 0)
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
CourseParticipant dbUserParticipated = new CourseParticipant();
dbUserParticipated.UserID = UserID;
dbUserParticipated.CourseID = CourseID;
dbUserParticipated.CreatedDate = DateTime.Now;
dbUserParticipated.UpdatedDate = DateTime.Now;
dbContext.CourseParticipants.Add(dbUserParticipated);
dbContext.SaveChanges();
isParticipated = true;
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(isParticipated);
}
//Check if user is participated or not
public bool isUserParticipated(string Token, long CourseID)
{
bool isParticipated = false;
try
{
long UserID = Utility.GetUserIDByToken(Token);
if (UserID > 0 && CourseID > 0)
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
CourseParticipant dbUserParticipated = dbContext.CourseParticipants.Where(x => x.CourseID == CourseID && x.UserID == UserID).FirstOrDefault();
if (dbUserParticipated != null && dbUserParticipated.CourseParticipantID > 0)
{
isParticipated = true;
}
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(isParticipated);
}
// To Get All Published Courses
public List <CourseModel> GetAllCourses()
{
List <CourseModel> CourseList = new List <CourseModel>();
try
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
List <Cours> dbList = dbContext.Courses.ToList();
Parallel.ForEach(dbList, x =>
{
CourseModel obj = new CourseModel();
obj.CourseID = x.CourseID;
obj.CourseName = x.CourseName;
obj.CourseDescription = x.CourseDescription;
CourseList.Add(obj);
});
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(CourseList);
}
// Update Course Detail
public bool UpdateCourse(CourseModel _CourseModel)
{
bool isUpdated = false;
try
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
Cours dbCourse = dbContext.Courses.Where(x => x.CourseID == _CourseModel.CourseID).FirstOrDefault();
if (dbCourse != null && dbCourse.CourseID > 0)
{
dbCourse.CourseName = _CourseModel.CourseName;
dbCourse.CourseDescription = _CourseModel.CourseDescription;
dbCourse.UpdatedDate = DateTime.Now;
dbContext.SaveChanges();
isUpdated = true;
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(isUpdated);
}
public static long GetUserIDByToken(string Token)
{
long UserID = 0;
try
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
UserToken dbUserToken = dbContext.UserTokens.Where(x => x.Token == Token).FirstOrDefault();
if (dbUserToken != null && dbUserToken.UserID > 0)
{
UserID = Utility.ToLong(dbUserToken.UserID);
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(UserID);
}
public UserModel LoginUser(UserModel model)
{
UserModel user = new UserModel();
try
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
User dbUser = dbContext.Users.Where(x => x.UserName == model.UserName && x.Password == model.Password).FirstOrDefault();
if (dbUser != null && dbUser.UserID > 0)
{
user.UserName = dbUser.UserName;
user.UserRole = dbUser.UserRole.Role;
// Generate Token and save in db with Expiry value
double TokenExpiry = Utility.ToDouble(ConfigurationManager.AppSettings["TokenExpiry"].ToString());
if (TokenExpiry == 0)
{
TokenExpiry = 1;
}
UserToken dbToken = new UserToken();
dbToken.UserID = dbUser.UserID;
dbToken.Token = Guid.NewGuid().ToString();
dbToken.TokenCreatedDate = DateTime.Now;
dbToken.TokenExpiryDate = DateTime.Now.AddHours(TokenExpiry);
dbToken.CreatedDate = DateTime.Now;
dbToken.UpdatedDate = DateTime.Now;
dbContext.UserTokens.Add(dbToken);
dbContext.SaveChanges();
user.Token = dbToken.Token;
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(user);
}
public bool LogoutUser(string Token)
{
bool isLoggedOut = false;
try
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
UserToken dbUserToken = dbContext.UserTokens.Where(x => x.Token == Token).FirstOrDefault();
if (dbUserToken != null && dbUserToken.UserTokenID > 0)
{
dbContext.UserTokens.Remove(dbUserToken);
dbContext.SaveChanges();
isLoggedOut = true;
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(isLoggedOut);
}
// Get Course Details By ID
public UserParticipatedCourse GetUserParticipatedCourseByID(string Token, long CourseID)
{
UserParticipatedCourse _Course = new UserParticipatedCourse();
try
{
long UserID = Utility.GetUserIDByToken(Token);
if (UserID > 0 && CourseID > 0)
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
Cours dbCourse = dbContext.Courses.Where(x => x.CourseID == CourseID).FirstOrDefault();
if (dbCourse != null && dbCourse.CourseID > 0)
{
_Course.Course = new CourseModel();
_Course.Course.CourseID = dbCourse.CourseID;
_Course.Course.CourseName = dbCourse.CourseName;
_Course.Course.CourseDescription = dbCourse.CourseDescription;
}
CourseParticipant dbCourseParticipant = dbContext.CourseParticipants.Where(x => x.CourseID == CourseID && x.UserID == UserID).FirstOrDefault();
if (dbCourseParticipant != null && dbCourseParticipant.CourseParticipantID > 0)
{
_Course.Participated = true;
}
else
{
_Course.Participated = false;
}
}
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(_Course);
}
// Add New Course
public bool AddCourse(CourseModel _CourseModel)
{
bool isAdded = false;
try
{
using (ResultatPartnerASEntities dbContext = new ResultatPartnerASEntities())
{
Cours dbCourse = new Cours();
dbCourse.CourseName = _CourseModel.CourseName;
dbCourse.CourseDescription = _CourseModel.CourseDescription;
dbCourse.CreatedDate = DateTime.Now;
dbCourse.UpdatedDate = DateTime.Now;
dbContext.Courses.Add(dbCourse);
dbContext.SaveChanges();
isAdded = true;
}
}
catch (Exception ex)
{
LogManager.writelog(ex.Message);
}
return(isAdded);
}
