public List <UserModel> GetAllUsers()
{
var db = new TableBasedSp(RunSpName);
var dt = db.GetFirstTableOfData("uspGetUsers", ConnectionString);
var users = new DataTableToList().Convert <UserModel>(dt);
return(users);
}
public DataTable GetMenu(int userId)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "UserId", userId.ToString() }
};
return(db.GetFirstTableOfData("uspGetUserMenu", ConnectionString, parameters));
}
public List <UserModel> GetProgramUsers(UserStatusEnum userStatusEnum = UserStatusEnum.All)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "Enable", ((int)userStatusEnum).ToString() }
};
var dt = db.GetFirstTableOfData("uspGetProgramUsers", ConnectionString, parameters);
var users = new DataTableToList().Convert <UserModel>(dt);
return(users);
}
public List<ProgramsModel> GetPrograms()
{
var db = new TableBasedSp(RunSpName);
try
{
var dt = db.GetFirstTableOfData("uspGetPrograms", ConnectionString);
var programs = new DataTableToList().Convert<ProgramsModel>(dt);
return programs;
}
catch (Exception ex)
{
throw ex;
}
}
public List <ProgramRoleModel> GetProgramRoles(int programId)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() }
};
try
{
var dt = db.GetFirstTableOfData("uspGetProgramRoles", ConnectionString, parameters);
var roles = new DataTableToList().Convert <ProgramRoleModel>(dt);
return(roles);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetFullElementWithSetting(ElementTypeEnum elementType, int userId)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "ElementTypeId", ((int)elementType).ToStringVar() },
{ "UserId", userId.ToString() }
};
try
{
return(db.GetFirstTableOfData("uspVisibleElementDataForUser", ConnectionString, parameters));
}
catch (Exception ex)
{
throw ex;
}
}
public UserModel Login(string userId, string password)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "UserId", userId },
{ "Password", password }
};
var dt = db.GetFirstTableOfData("uspLoginInProgram", ConnectionString, parameters);
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
var user = new DataTableToList().Convert <UserModel>(dt);
return(user[0]);
}
public List <ElementAccessModel> GetElementAccess(ElementTypeEnum elementType, int userId)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "ElementTypeId", ((int)elementType).ToStringVar() },
{ "UserId", userId.ToString() }
};
try
{
var dt = db.GetFirstTableOfData("uspVisibleElementDataForUser", ConnectionString, parameters);
var elements = new DataTableToList().Convert <ElementAccessModel>(dt);
return(elements);
}
catch (Exception ex)
{
throw ex;
}
}
public ElementAccessModel GetElementAccess(int elementId, int userId)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "ElementId", elementId.ToString() },
{ "UserId", userId.ToString() }
};
try
{
var dt = db.GetFirstTableOfData("[uspGetUserAccessForElement]", ConnectionString, parameters);
var elements = new DataTableToList().Convert <ElementAccessModel>(dt);
return(elements[0]);
}
catch (Exception ex)
{
throw ex;
}
}
