public IList <MLMenu> GetMenuItems(bool isAdmin)
{
using (OnlineTestDBEntities dbContext = new OnlineTestDBEntities())
{
return(dbContext.tblMenus.AsQueryable().Where(x => x.StatusID == 1 && x.IsAdminMenu == isAdmin).Select(x => new MLMenu {
MenuID = x.MenuID,
NameOption = x.NameOption,
Controller = x.Controller,
Action = x.Action,
ImageClass = x.ImageClass,
IsAdminMenu = x.IsAdminMenu,
StatusID = x.StatusID,
IsParent = x.IsParent,
ParentID = x.ParentID
}).ToList());;
}
}
public MLResultQuestions LoadQuestionsList()
{
using (OnlineTestDBEntities dbContext = new OnlineTestDBEntities())
{
MLResultQuestions objMLResult = new MLResultQuestions();
objMLResult.ListQuestionAnswers = dbContext.tblQuestions.Where(x => x.StatusID == 1).Select(x => new MLQuestion
{
QID = x.QID,
Question = x.Question,
QuestionDesc = x.QuestionDesc,
QuestionLevelID = x.QuestionLevelID,
IsMultipleAns = x.IsMultipleAns,
IsStudyType = x.IsStudyType,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate,
}).ToList();
return(objMLResult);
}
}
public MLUser Login(MLUser objMLUser)
{
MLUser objMLUserInfo = new MLUser();
using (OnlineTestDBEntities dbContext = new OnlineTestDBEntities())
{
var userInfo = dbContext.tblUsers.Where(x => x.EmailID == objMLUser.EmailID && x.Password == x.Password && x.StatusID == 1).Select(x => x).FirstOrDefault();
if (userInfo != null)
{
objMLUserInfo.UserID = userInfo.UID;
objMLUserInfo.FName = userInfo.FName;
objMLUserInfo.LName = userInfo.LName;
objMLUserInfo.FullName = objMLUserInfo.GetFullName(objMLUser.FName, objMLUser.LName);
objMLUserInfo.DOB = userInfo.DOB;
objMLUserInfo.UserTypeID = userInfo.UserTypeID ?? 2;
}
}
return(objMLUserInfo);
}
public IList <MLDropdown> GetDropdownList(MLDropdownBindOption objDDLBind)
{
using (OnlineTestDBEntities dbContext = new OnlineTestDBEntities())
{
var objDropdown = dbContext.usp_GetDropdownList(objDDLBind.TableName, objDDLBind.ColID, objDDLBind.ColText, objDDLBind.Option).ToList();
if (objDropdown != null)
{
return(objDropdown.Select(x => new MLDropdown
{
ID = x.ID,
Text = x.Text,
ParentID = x.ParentID
}).ToList());
}
else
{
return(new List <MLDropdown>());
}
}
}
public void UpdateUserLastLogin(OnlineTestDBEntities dbContext, tblUser objTblUser)
{
objTblUser.LastLogin = DateTime.Now;
dbContext.SaveChanges();
}
