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