public static List <Dictionary <string, object> > QueryFieldsByEntityId(Guid entityId)
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Field_queryfieldsbyentityid]",
new List <SqlParameter> {
new SqlParameter("@entityId", entityId)
});
return(records);
}
public static Dictionary <string, object> QueryEntityById(Guid entityId)
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Entity_queryentitybyentityid]",
new List <SqlParameter> {
new SqlParameter("@entityId", entityId)
});
if (records != null && records.Count == 1)
{
return(records[0]);
}
return(null);
}
public static Dictionary <string, object> QueryAppUserById(Guid appUserId)
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Appuser_querybyid]",
new List <SqlParameter> {
new SqlParameter("@appUserId", appUserId)
});
if (records != null && records.Count == 1)
{
return(records[0]);
}
return(null);
}
public static Dictionary <string, object> QueryFieldById(Guid fieldId)
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Field_queryfieldbyfieldid]",
new List <SqlParameter> {
new SqlParameter("@fieldId", fieldId)
});
if (records != null && records.Count == 1)
{
return(records[0]);
}
return(null);
}
public static Dictionary <string, object> QueryFieldTypeByName(string fieldTypeName)
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Fieldtype_querybyname]",
new List <SqlParameter> {
new SqlParameter("@fieldTypeName", fieldTypeName)
});
if (records != null && records.Count == 1)
{
return(records[0]);
}
return(null);
}
public static List <Dictionary <string, object> > QuerySideMenuItems()
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Sidemenuitem_queryall]", null);
return(records);
}
public static List <Dictionary <string, object> > QueryEntities()
{
var records = SharedService.ExecuteGetSqlStoredProcedure("[eduq].[Entity_queryall]", null);
return(records);
}