public bool MapAnAssessmentToUser(int userId, int assessmentId)
{
bool isCreationSucess = true;
try
{
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter[] paramArray = new SqlParameter[3];
paramArray[0] = RepositoryUtility.AddSQLParameter("@userid", SqlDbType.Int, ParameterDirection.Input, userId);
paramArray[1] = RepositoryUtility.AddSQLParameter("@assessmentid", SqlDbType.Int, ParameterDirection.Input, assessmentId);
paramArray[2] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.MapAnAssessmentToUser);
string successMessage = Convert.ToString(paramArray[2].Value);
if (successMessage.Equals("Success"))
{
isCreationSucess = true;
}
else
{
isCreationSucess = false;
}
}
catch (Exception ex)
{
isCreationSucess = false;
}
return(isCreationSucess);
}
public bool CreateRole(RoleData roleData)
{
bool isCreationSucess = true;
try
{
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter[] paramArray = new SqlParameter[4];
paramArray[0] = RepositoryUtility.AddSQLParameter("@rolename", SqlDbType.VarChar, ParameterDirection.Input, roleData.RoleName);
paramArray[1] = RepositoryUtility.AddSQLParameter("@roledescription", SqlDbType.VarChar, ParameterDirection.Input, roleData.RoleId);
paramArray[2] = RepositoryUtility.AddSQLParameter("@CreatedBy", SqlDbType.VarChar, ParameterDirection.Input, roleData.CreatedBy);
paramArray[3] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.SPCreateRole);
string successMessage = Convert.ToString(paramArray[3].Value);
if (successMessage.Equals("Success"))
{
isCreationSucess = true;
}
else
{
isCreationSucess = false;
}
}
catch (Exception ex)
{
isCreationSucess = false;
}
return(isCreationSucess);
}
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 bool QuestionPaperUpload(Stream questionPaperStream, string description, string questionPaperName)
{
bool isInsertionSuccess = false;
try
{
DataTable dtQuestionPaper = RepositoryUtility.ConvertCSVStreamToDatable(questionPaperStream);
string xml = Convert.ToString(CreateQuestionPaperXMLFromDataTable(dtQuestionPaper));
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter[] paramArray = new SqlParameter[4];
paramArray[0] = RepositoryUtility.AddSQLParameter("@QuestionPaperName", SqlDbType.VarChar, ParameterDirection.Input, questionPaperName);
paramArray[1] = RepositoryUtility.AddSQLParameter("@description", SqlDbType.VarChar, ParameterDirection.Input, description);
paramArray[2] = RepositoryUtility.AddSQLParameter("@questionpaperxml", SqlDbType.Xml, ParameterDirection.Input, xml);
paramArray[3] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.SPQuestionPaperUpload);
string successMessage = Convert.ToString(paramArray[3].Value);
if (successMessage.Equals("Success"))
{
isInsertionSuccess = true;
}
else
{
isInsertionSuccess = false;
}
}
catch (Exception ex)
{
isInsertionSuccess = false;
}
return(isInsertionSuccess);
}
public bool SaveAssessmentResultAndAnsweredSheet(AssessmentResultData assessmentResultData)
{
bool isSaveSucess = true;
StringBuilder strBuilder = new StringBuilder();
XmlSerializer serializer = new XmlSerializer(typeof(List <QuestionPaperData>));
using (StringWriter textWriter = new StringWriter())
{
serializer.Serialize(textWriter, assessmentResultData.AnsweredSheet);
strBuilder.Append(textWriter.ToString());
}
string answeredSheetINXML = Convert.ToString(strBuilder);
try
{
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter[] paramArray = new SqlParameter[9];
paramArray[0] = RepositoryUtility.AddSQLParameter("@AssessmentId", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.AssessmentId);
paramArray[1] = RepositoryUtility.AddSQLParameter("@userid ", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.UserId);
paramArray[2] = RepositoryUtility.AddSQLParameter("@TotalQuestionsCount", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.TotalQuestionsCount);
paramArray[3] = RepositoryUtility.AddSQLParameter("@RightAnsweredCount", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.RightAnsweredCount);
paramArray[4] = RepositoryUtility.AddSQLParameter("@CanInsertAssessmentResult", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.CanInsertAssessmentResult?1:0);
paramArray[5] = RepositoryUtility.AddSQLParameter("@questionPaperId", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.QuestionPaperId);
paramArray[6] = RepositoryUtility.AddSQLParameter("@answeredSheet", SqlDbType.Xml, ParameterDirection.Input, answeredSheetINXML);
paramArray[7] = RepositoryUtility.AddSQLParameter("@IsWriteLaterFlag", SqlDbType.Int, ParameterDirection.Input, assessmentResultData.IsWriteAssessmentLater?1:0);
paramArray[8] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.SPSaveResultAndAnsweredSheet);
string successMessage = Convert.ToString(paramArray[8].Value);
if (successMessage.Equals("Success"))
{
isSaveSucess = true;
}
else
{
isSaveSucess = false;
}
}
catch (Exception ex)
{
isSaveSucess = false;
}
return(isSaveSucess);
}
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 bool UpdateUser(UserData userData)
{
bool isUpdationSucess = true;
try
{
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter[] paramArray = new SqlParameter[9];
paramArray[0] = RepositoryUtility.AddSQLParameter("@userid", SqlDbType.Int, ParameterDirection.Input, userData.UserId);
paramArray[1] = RepositoryUtility.AddSQLParameter("@username", SqlDbType.VarChar, ParameterDirection.Input, userData.Username);
paramArray[2] = RepositoryUtility.AddSQLParameter("@EmailAddress", SqlDbType.VarChar, ParameterDirection.Input, userData.EmailAddress);
paramArray[3] = RepositoryUtility.AddSQLParameter("@FirstName", SqlDbType.VarChar, ParameterDirection.Input, userData.FirstName);
paramArray[4] = RepositoryUtility.AddSQLParameter("@LastName", SqlDbType.VarChar, ParameterDirection.Input, userData.LastName);
paramArray[5] = RepositoryUtility.AddSQLParameter("@ModifiedBy", SqlDbType.VarChar, ParameterDirection.Input, userData.ModifiedBy);
paramArray[6] = RepositoryUtility.AddSQLParameter("@roleid", SqlDbType.Int, ParameterDirection.Input, (object)userData.Role.RoleId ?? DBNull.Value);
paramArray[7] = RepositoryUtility.AddSQLParameter("@ProfilePicPath", SqlDbType.VarChar, ParameterDirection.Input, userData.ProfilePicPath);
paramArray[8] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.SPUpdateUser);
string successMessage = Convert.ToString(paramArray[8].Value);
if (successMessage.Equals("Success"))
{
isUpdationSucess = true;
}
else
{
isUpdationSucess = false;
}
}
catch (Exception ex)
{
isUpdationSucess = false;
}
return(isUpdationSucess);
}
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 bool CreateAssessment(AssessmentData assessmentData)
{
bool isCreationSucess = true;
try
{
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter[] paramArray = new SqlParameter[7];
paramArray[0] = RepositoryUtility.AddSQLParameter("@AssessmentName", SqlDbType.VarChar, ParameterDirection.Input, assessmentData.AssessmentName);
paramArray[1] = RepositoryUtility.AddSQLParameter("@AssessmentDescription", SqlDbType.VarChar, ParameterDirection.Input, assessmentData.AssessmentDescription);
paramArray[2] = RepositoryUtility.AddSQLParameter("@QuestionPaperId", SqlDbType.VarChar, ParameterDirection.Input, assessmentData.QuestionPaperData.Id);
paramArray[3] = RepositoryUtility.AddSQLParameter("@StartTime", SqlDbType.DateTime, ParameterDirection.Input, assessmentData.StartTime);
paramArray[4] = RepositoryUtility.AddSQLParameter("@EndTime", SqlDbType.DateTime, ParameterDirection.Input, assessmentData.EndTime);
paramArray[5] = RepositoryUtility.AddSQLParameter("@CreatedBy", SqlDbType.VarChar, ParameterDirection.Input, assessmentData.CreatedBy);
paramArray[6] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.SPCreateAssessment);
string successMessage = Convert.ToString(paramArray[6].Value);
if (successMessage.Equals("Success"))
{
isCreationSucess = true;
}
else
{
isCreationSucess = false;
}
}
catch (Exception ex)
{
isCreationSucess = false;
}
return(isCreationSucess);
}
public bool MapModuleWisePageAccessWithRole(List <ModulewisePageAccessData> listModulewisePermissionData)
{
bool isCreationSucess = false;
try
{
DataTable removePermissionTypeTable = new DataTable("ModuleRolePermisisonType");
//we create column names as per the type in DB
removePermissionTypeTable.Columns.Add("ModuleId", typeof(Int32));
removePermissionTypeTable.Columns.Add("RoleId", typeof(Int32));
removePermissionTypeTable.Columns.Add("PermissionId", typeof(Int32));
DataTable AddPermissionTypeTable = new DataTable("ModuleRolePermisisonType");
//we create column names as per the type in DB
AddPermissionTypeTable.Columns.Add("ModuleId", typeof(Int32));
AddPermissionTypeTable.Columns.Add("RoleId", typeof(Int32));
AddPermissionTypeTable.Columns.Add("PermissionId", typeof(Int32));
int roleid = -1;
foreach (var modulewisePermissionData in listModulewisePermissionData)
{
if (modulewisePermissionData.Role != null)
{
if (modulewisePermissionData.Role.RoleId != 0)
{
roleid = modulewisePermissionData.Role.RoleId;
}
}
foreach (var page in modulewisePermissionData.pageList)
{
if (page.IsPageSelected)
{
DataRow modulewisePageAccessRow = AddPermissionTypeTable.NewRow();
modulewisePageAccessRow[0] = modulewisePermissionData.Module.ModuleId;
modulewisePageAccessRow[1] = roleid;
modulewisePageAccessRow[2] = page.PageId;
AddPermissionTypeTable.Rows.Add(modulewisePageAccessRow);
}
else
{
DataRow modulewisePageAccessRow = removePermissionTypeTable.NewRow();
modulewisePageAccessRow[0] = modulewisePermissionData.Module.ModuleId;
modulewisePageAccessRow[1] = roleid;
modulewisePageAccessRow[2] = page.PageId;
removePermissionTypeTable.Rows.Add(modulewisePageAccessRow);
}
}
}
SqlParameter parameter = new SqlParameter();
//The parameter for the SP must be of SqlDbType.Structured
parameter.ParameterName = "@RemoveModuleRolePagetype";
parameter.SqlDbType = System.Data.SqlDbType.Structured;
parameter.Value = removePermissionTypeTable;
IDatabaseHelper objSqlADOHelper = new SqlADOHelper();
SqlParameter parameter1 = new SqlParameter();
//The parameter for the SP must be of SqlDbType.Structured
parameter1.ParameterName = "@MapModuleRolepagetype";
parameter1.SqlDbType = System.Data.SqlDbType.Structured;
parameter1.Value = AddPermissionTypeTable;
SqlParameter[] paramArray = new SqlParameter[3];
paramArray[0] = parameter;
paramArray[1] = parameter1;
paramArray[2] = RepositoryUtility.AddSQLParameter("@responsemessage", SqlDbType.VarChar, ParameterDirection.Output, null, 500);
objSqlADOHelper.GetOutputParamValue(paramArray, StoredProcedureNameConstants.SPMapModuleWisePageWithRole);
string successMessage = Convert.ToString(paramArray[2].Value);
if (successMessage.Equals("Success"))
{
isCreationSucess = true;
}
else
{
isCreationSucess = false;
}
}
catch (Exception ex)
{
isCreationSucess = false;
}
return(isCreationSucess);
}
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);
}
