public static List<Location> List(int levelId = 0)
{
List<Location> list = new List<Location>();
using (SqlCommand cmd = new SqlCommand()
{
CommandType = CommandType.Text,
CommandText =
"select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " +
"where @levelId=0 or l.LevelId=@levelId order by v.Name, l.Name;",
})
{
cmd.Parameters.AddWithValue("@levelId", levelId);
cmd.ExecuteReaderExt((r) =>
{
Location loc = new Location();
loc._initFromRow(r);
string name2 = r.StringOrBlank("Name2").Trim();
loc.Name = string.Format("{0} : {1}",
name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2,
loc.Name
);
list.Add(loc);
return true;
});
}
return list;
}
public override async Task ProcessRequestAsync(HttpContext context)
{
HttpRequest request = context.Request;
HttpResponse response = context.Response;
int frameId = request.IntOrZero("frame");
int panelId = request.IntOrZero("panel");
int displayId = request.IntOrZero("display");
string culture = request.StringOrBlank("culture");
string json = "";
try
{
// set culture
Powerbi powerbi = new Powerbi(frameId);
Location location = new Location(displayId);
if (string.IsNullOrWhiteSpace(culture))
culture = location.Culture;
if (!string.IsNullOrWhiteSpace(culture))
{
System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo(culture);
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
}
JavaScriptSerializer jss = new JavaScriptSerializer();
json = jss.Serialize(new
{
accessToken = await powerbi.GetAccessTokenAsync(),
});
}
catch (Exception ex)
{
JavaScriptSerializer s = new JavaScriptSerializer();
json = s.Serialize(new
{
Error = ex.Message,
//Stack = ex.StackTrace,
Data = new
{
FrameId = frameId,
PanelId = panelId,
DisplayId = displayId,
Culture = culture,
Details = ex.GetType() == typeof(AzureTokenException) ? (ex as AzureTokenException).Details : null,
},
});
}
response.Clear();
response.Cache.SetCacheability(HttpCacheability.NoCache);
response.Cache.SetSlidingExpiration(true);
response.Cache.SetNoStore();
response.ContentType = "application/json";
response.Write(json);
response.Flush();
}
public static List<Location> List(int levelId = 0)
{
List<Location> list = new List<Location>();
string sql = string.Format(
"select l.*, v.Name Name2 from Location l inner join Level v on v.LevelId=l.LevelId " +
"WHERE {0}=0 or l.LevelId={0} order by v.Name, l.Name;",
levelId
);
using (DataSet ds = DataAccess.RunSql(sql))
{
list.Capacity = ds.Tables[0].Rows.Count;
// list level locations
foreach (DataRow r in ds.Tables[0].Rows)
{
Location loc = new Location();
loc._initFromRow(r);
string name2 = r.StringOrBlank("Name2").Trim();
loc.Name = string.Format("{0} : {1}",
name2 == "" ? string.Format("Level {0}", loc.LevelId) : name2,
loc.Name
);
list.Add(loc);
}
}
return list;
}
