public List <UserData> GetAllUsersData() { List <UserData> listUsers = new List <UserData>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[1]; paramArray[0] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SpGetAllUsers); foreach (DataRow row in dt.Rows) { UserData user = new UserData(); user.UserId = Convert.ToInt32(row.ItemArray[0]); user.Username = Convert.ToString(row.ItemArray[1]); user.FirstName = Convert.ToString(row.ItemArray[2]); user.LastName = Convert.ToString(row.ItemArray[3]); user.EmailAddress = Convert.ToString(row.ItemArray[4]); user.Role = new RoleData(); if (!string.IsNullOrEmpty(row.ItemArray[5].ToString())) { user.Role.RoleId = Convert.ToInt32((row.ItemArray[5])); } if (!string.IsNullOrEmpty(row.ItemArray[6].ToString())) { user.Role.RoleName = Convert.ToString((row.ItemArray[6])); } listUsers.Add(user); } return(listUsers); }
public AssessmentData GetAssessmentForEvaluation(int assessmentId, int userid) { AssessmentData assessmentData = new AssessmentData(); List <QuestionPaperData> listQuestionPaper = new List <QuestionPaperData>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[3]; paramArray[0] = RepositoryUtility.AddSQLParameter("@AssessmentId", SqlDbType.VarChar, ParameterDirection.Input, assessmentId); paramArray[1] = RepositoryUtility.AddSQLParameter("@UserId", SqlDbType.VarChar, ParameterDirection.Input, userid); paramArray[2] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SPGetQuestionPaperForEvaluate); var stringReader = new System.IO.StringReader(Convert.ToString(dt.Rows[0].ItemArray[1])); var serializer = new XmlSerializer(typeof(List <QuestionPaperData>)); listQuestionPaper = serializer.Deserialize(stringReader) as List <QuestionPaperData>; assessmentData.QuestionPaper = listQuestionPaper; assessmentData.QuestionPaperId = Convert.ToInt32(dt.Rows[0].ItemArray[0]); return(assessmentData); }
public List <ModulewisePageAccessData> GetModulewisePermissionList() { List <ModulewisePageAccessData> listmodulewisePageAccessData = new List <ModulewisePageAccessData>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[1]; paramArray[0] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SpGetAllModulesWisePermissionData); foreach (DataRow row in dt.Rows) { PageData permissionData = new PageData(); permissionData.PageId = Convert.ToInt32(row.ItemArray[0]); permissionData.PageName = Convert.ToString(row.ItemArray[1]); ModuleData moduleData = new ModuleData(); moduleData.ModuleId = Convert.ToInt32(row.ItemArray[2]); moduleData.ModuleName = Convert.ToString(row.ItemArray[3]); bool isAlreadyModuleaddedd = false; foreach (var moduleWisePageAccess in listmodulewisePageAccessData) { if (moduleWisePageAccess.Module != null) { if (moduleWisePageAccess.Module.ModuleId == moduleData.ModuleId) { moduleWisePageAccess.pageList.Add(permissionData); isAlreadyModuleaddedd = true; } } } if (isAlreadyModuleaddedd == false) { ModulewisePageAccessData modulewisePageAccessData = new ModulewisePageAccessData(); modulewisePageAccessData.Module = moduleData; modulewisePageAccessData.pageList.Add(permissionData); listmodulewisePageAccessData.Add(modulewisePageAccessData); } } return(listmodulewisePageAccessData); }
public bool IsValidUser(UserData accountDetailsData) { try { bool isValidUser = false; IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[3]; paramArray[0] = RepositoryUtility.AddSQLParameter("@username", SqlDbType.VarChar, ParameterDirection.Input, accountDetailsData.Username); paramArray[1] = RepositoryUtility.AddSQLParameter("@password", SqlDbType.VarChar, ParameterDirection.Input, accountDetailsData.Password); paramArray[2] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); DataTable dtusers = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SPIsValidUser); string successMessage = Convert.ToString(paramArray[2].Value); if (successMessage.Equals("User successfully logged in")) { isValidUser = true; foreach (DataRow row in dtusers.Rows) { accountDetailsData.UserId = Convert.ToInt32(row.ItemArray[0]); accountDetailsData.Username = Convert.ToString(row.ItemArray[1]); accountDetailsData.Role = new RoleData(); accountDetailsData.Role.RoleId = Convert.ToInt32(row.ItemArray[2]); accountDetailsData.ProfilePicPath = Convert.ToString(row.ItemArray[3]); } } else { isValidUser = false; } return(isValidUser); } catch (Exception ex) { return(false); } }
public List <RoleData> GetAllRoles() { List <RoleData> listRoles = new List <RoleData>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[1]; paramArray[0] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SpGetAllRoles); foreach (DataRow row in dt.Rows) { RoleData roleData = new RoleData(); roleData.RoleName = Convert.ToString(row.ItemArray[1]); roleData.RoleId = Convert.ToInt32(row.ItemArray[0]); listRoles.Add(roleData); } return(listRoles); }
public List <QuestionpaperDetails> GetAllQuestionPaperDetails() { List <QuestionpaperDetails> listQuestionpaperDetails = new List <QuestionpaperDetails>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[1]; paramArray[0] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SpGetAllQuestionPapers); foreach (DataRow row in dt.Rows) { QuestionpaperDetails questionPaperDetailData = new QuestionpaperDetails(); questionPaperDetailData.Id = Convert.ToInt32(row.ItemArray[0]); questionPaperDetailData.QuestionPaperName = Convert.ToString(row.ItemArray[1]); listQuestionpaperDetails.Add(questionPaperDetailData); } return(listQuestionpaperDetails); }
public List <UserData> GetUsersForAssessmentForEvaluation(int assessement) { List <UserData> listUserData = new List <UserData>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[2]; paramArray[0] = RepositoryUtility.AddSQLParameter("@AssessmentId", SqlDbType.Int, ParameterDirection.Input, assessement); paramArray[1] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.SpGetUsersByAssessmentId); foreach (DataRow row in dt.Rows) { UserData userData = new UserData(); userData.UserId = Convert.ToInt32(row.ItemArray[0]); userData.Username = Convert.ToString(row.ItemArray[1]); listUserData.Add(userData); } return(listUserData); }
public List <ModulewisePageAccessData> GetModulewiseMenuAccessForRoleData(int roleId) { List <ModulewisePageAccessData> listModulewisePageAccessData = new List <ModulewisePageAccessData>(); IDatabaseHelper objSqlADOHelper = new SqlADOHelper(); SqlParameter[] paramArray = new SqlParameter[2]; paramArray[0] = RepositoryUtility.AddSQLParameter("@RoleId", SqlDbType.Int, ParameterDirection.Input, roleId, 500); paramArray[1] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500); var dt = objSqlADOHelper.GetData(paramArray, StoredProcedureNameConstants.Sp_GetAllAccessedMenuPages); foreach (DataRow row in dt.Rows) { ModulewisePageAccessData modulewisePageAccessData = new ModulewisePageAccessData(); modulewisePageAccessData.Module = new ModuleData(); modulewisePageAccessData.Module.ModuleId = Convert.ToInt32(row.ItemArray[0]); modulewisePageAccessData.Module.ModuleName = Convert.ToString(row.ItemArray[1]); if (listModulewisePageAccessData.Count == 0) { PageData pageData = new PageData(); pageData.PageId = Convert.ToInt32(row.ItemArray[2]); pageData.PageName = Convert.ToString(row.ItemArray[3]); pageData.PageUrl = Convert.ToString(row.ItemArray[4]); modulewisePageAccessData.pageList.Add(pageData); listModulewisePageAccessData.Add(modulewisePageAccessData); } else { bool IsModuleAlreadyAdded = false; int index = -1; foreach (var moduleWisePage in listModulewisePageAccessData) { index = index + 1; if (moduleWisePage.Module != null) { if (moduleWisePage.Module.ModuleId == modulewisePageAccessData.Module.ModuleId) { IsModuleAlreadyAdded = true; break; } } } if (IsModuleAlreadyAdded) { PageData pageData = new PageData(); pageData.PageId = Convert.ToInt32(row.ItemArray[2]); pageData.PageName = Convert.ToString(row.ItemArray[3]); pageData.PageUrl = Convert.ToString(row.ItemArray[4]); listModulewisePageAccessData[index].pageList.Add(pageData); } else { PageData pageData = new PageData(); pageData.PageId = Convert.ToInt32(row.ItemArray[2]); pageData.PageName = Convert.ToString(row.ItemArray[3]); pageData.PageUrl = Convert.ToString(row.ItemArray[4]); modulewisePageAccessData.pageList.Add(pageData); listModulewisePageAccessData.Add(modulewisePageAccessData); } } } return(listModulewisePageAccessData); }