/// <summary>
/// Save Student quiz result in database
/// </summary>
/// <param name="result">quiz result</param>
/// <returns>true/false</returns>
public bool SaveQuizResult(int result, int TotalMarks)
{
try
{
QuizDetail quizDetail = new QuizDetail();
quizDetail.Id = Guid.NewGuid();
quizDetail.UserId = Guid.Parse(HttpContext.Current.User.Identity.GetUserId());
quizDetail.QuizId = Guid.NewGuid();
quizDetail.Result = result;
quizDetail.TotalMarks = TotalMarks;
quizDetail.Status = true;
quizDetail.DateCreated = DateTime.Now;
quizDetail.IsActive = true;
using (var db = new MyLearnDBEntitiess())
{
db.QuizDetails.Add(quizDetail);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Call when user use Editor Activity
/// </summary>
/// <param name="courseDetailId"></param>
/// <returns></returns>
public bool Update_Student_Course_Activity(Guid courseDetailId)
{
try
{
var UserId = Guid.Parse(HttpContext.Current.User.Identity.GetUserId());
using (var db = new MyLearnDBEntitiess())
{
var _result = db.CourseDetails.SingleOrDefault(b => b.CourseId == courseDetailId && b.UserId == UserId);
if (_result != null)
{
_result.StatusTotal = _result.StatusTotal + 1;
_result.LastAccessed = DateTime.Now;
_result.DateEdited = DateTime.Now;
db.SaveChanges();
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Create([Bind(Include = "Id,GroupName,CreatedBy,CourseID,CreatedDate,DateEdited,IsEnable,IsActive")] GroupMaster groupMaster)
{
if (groupMaster.GroupName != "")
{
string userId = User.Identity.GetUserId();
groupMaster.Id = Guid.NewGuid();
groupMaster.CreatedBy = Guid.Parse(userId);
groupMaster.CreatedDate = DateTime.Now;
groupMaster.CourseID = Guid.Parse("3E851245-056E-40BA-8767-5C662F0D0C86");
groupMaster.DateEdited = DateTime.Now;
groupMaster.IsActive = true;
groupMaster.IsEnable = true;
db.GroupMasters.Add(groupMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Error = "Ok";
return(View(groupMaster));
}
public void AddLog_Quiz(string _userId)
{
using (var db = new MyLearnDBEntitiess())
{
var _result = db.UserLogs.SingleOrDefault(b => b.UserID == _userId);
if (_result != null)
{
_result.Quiz = DateTime.Now;
db.SaveChanges();
}
}
}
/// <summary>
/// Add new Long data
/// </summary>
/// <param name="_userId"></param>
public void Add_Log(string _userId)
{
UserLog userlog = new UserLog();
userlog.Id = Guid.NewGuid();
userlog.UserID = _userId;
userlog.Login = DateTime.Now;
userlog.Quiz = null;
userlog.ActivityAccessed = null;
using (var db = new MyLearnDBEntitiess())
{
db.UserLogs.Add(userlog);
db.SaveChanges();
}
}
//public List<QuizDetail> GetQuizDetailsById(string user_id)
//{
// var dbcon = new SqlConnection(ConfigurationManager.ConnectionStrings["_MyLearnDBEntities"].ToString());
// var dbcommand = new SqlCommand();
// dbcommand.Connection = dbcon;
// dbcommand.CommandText = "select * from QuizDetail where UserId = @user_id";
// dbcon.Open();
// var model = new List<QuizDetail>();
// var reader = dbcommand.ExecuteReader();
// while (reader.Read())
// {
// var details = new QuizDetail();
// details.Result = int.Parse(reader["Result"].ToString());
// details.TotalMarks = int.Parse(reader["TotalMarks"].ToString());
// }
// dbcon.Close();
// return model;
//}
public void UpdateUser(string user, string email, int number, string user_id)
{
using (var db = new MyLearnDBEntitiess())
{
var Ids = Guid.Parse(user_id);
AspNetUser aspNetUser = new AspNetUser();
aspNetUser = db.AspNetUsers.SingleOrDefault(x => x.Id == user_id);
aspNetUser.UserName = user;
aspNetUser.Email = email;
aspNetUser.PhoneNumber = number.ToString();
db.SaveChanges();
}
return;
}
public bool SaveUserPreff(string Color)
{
try
{
using (var db = new MyLearnDBEntitiess())
{
var Id = Guid.Parse(HttpContext.Current.User.Identity.GetUserId());
var user = db.UserPreferenceMasters.SingleOrDefault(x => x.UserID == Id);
user.ThemeColor = Color;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Update user into database
/// </summary>
/// <param name="result">Update user data</param>
/// <returns>true/false</returns>
//public bool UpdateUser(string UserName,string Email, int PhoneNumber )
//{
// try
// {
// AspNetUser info = new AspNetUser();
// info.UserName = UserName;
// info.Email = Email;
// info.PhoneNumber = int.Parse(PhoneNumber.ToString());
// using (var db = new MyLearnDBEntities())
// {
// db.A.Add(UpdateUser);
// db.SaveChanges();
// }
// return true;
// }
// catch (Exception)
// {
// return false;
// }
//}
/// <summary>
/// call when student add course
/// </summary>
/// <param name="userId"></param>
/// <param name="CourseId"></param>
/// <returns></returns>
public bool Add_Student_Course()
{
try
{
var courseId = "3E851245-056E-40BA-8767-5C662F0D0C86";
var UserID = Guid.Parse(HttpContext.Current.User.Identity.GetUserId());
using (var db = new MyLearnDBEntitiess())
{
var existUser = db.CourseDetails.SingleOrDefault(x => x.UserId == UserID);
if (existUser.Id != null)
{
return(true);
}
}
CourseDetail detail = new CourseDetail();
detail.Id = Guid.NewGuid();
detail.UserId = UserID;
detail.DateAdded = DateTime.Now;
detail.CourseId = Guid.Parse(courseId);
detail.ProgressStatus = 0;
detail.StatusTotal = 0;
detail.LastAccessed = DateTime.Now;
detail.DateCreated = DateTime.Now;
detail.DateEdited = DateTime.Now;
detail.IsEnable = true;
detail.IsActive = true;
using (var db = new MyLearnDBEntitiess())
{
db.CourseDetails.Add(detail);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Join group for students
/// </summary>
/// <param name="GroupID"></param>
public void JoinStudentGroup(Guid GroupID)
{
using (var db = new MyLearnDBEntitiess())
{
var UserId = Guid.Parse(HttpContext.Current.User.Identity.GetUserId());
var x = db.GroupDetails.SingleOrDefault(v => v.UserId == UserId && v.GroupId == GroupID);
if (x == null)
{
GroupDetail group = new GroupDetail();
group.Id = Guid.NewGuid();
group.UserId = UserId;
group.GroupId = GroupID;
group.DateCreated = DateTime.Now;
group.DateEdited = DateTime.Now;
group.IsEnable = true;
group.IsActive = true;
db.GroupDetails.Add(group);
db.SaveChanges();
}
}
}
public void AddLog_Login(string _userId)
{
try
{
using (var db = new MyLearnDBEntitiess())
{
var _result = db.UserLogs.SingleOrDefault(b => b.UserID == _userId);
if (_result != null)
{
_result.Login = DateTime.Now;
db.SaveChanges();
}
else
{
Add_Log(_userId);
}
}
}
catch (Exception ex)
{
}
}
public bool Add_Announcement(Announcement Model)
{
try
{
Model.DateCreated = DateTime.Now;
Model.IsEnable = true;
Model.IsActive = true;
Model.Id = Guid.NewGuid();
using (var db = new MyLearnDBEntitiess())
{
db.Announcements.Add(Model);
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}