public static FileData GetSysFileUpload(long id, string subsystem)
{
WebInitializer.Initialize();
using (var db = new DBUploadFilesDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
return(CacheQueries.ExecuteFunction <SYS_FileUpload, Triplet <long, string, string>, FileData>(
db, new Triplet <long, string, string>(id, User.GetSID(), subsystem),
(r, value) =>
r.id == value.First && r.PersonSID == value.Second && r.SubSystemName == value.Third,
r => new FileData
{
FileName = r.dataFileName,
Binary = r.data,
}));
}
}
public static string GetTableHeader(string projectCode, string tableName, string version, string publicKeyToken)
{
var cacheKey = tableName + ":" + LocalizationHelper.IsCultureKZ;
if (ProjectHeadersCache.ContainsKey(cacheKey))
{
return(ProjectHeadersCache[cacheKey]);
}
string header = null;
var type = BuildManager.GetType(
string.Format(
"{1}.Properties.{0}Resources, {1}, Version={2}, Culture=neutral, PublicKeyToken={3}",
tableName,
projectCode,
version ?? InitializerSection.GetSection().DefaultVersion,
publicKeyToken ?? InitializerSection.GetSection().DefaultPublicKeyToken),
false,
true);
var property = type?.GetProperty("Header", BindingFlags.Static | BindingFlags.Public);
if (property != null)
{
header = (string)property.GetValue(null, new object[0]);
}
if (string.IsNullOrEmpty(header))
{
using (var db = new DBDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
header = CacheQueries.GetNameCached <MON_RequestTable, string, string>(
db,
tableName,
(r, value) => r.TableCode == value,
r => r.TableName);
}
}
if (string.IsNullOrEmpty(header))
{
header = tableName;
}
return(ProjectHeadersCache[cacheKey] = header);
}
public static string GetProjectCode(string tableName)
{
if (ProjectCodesCache.ContainsKey(tableName))
{
return(ProjectCodesCache[tableName]);
}
string projectCode;
using (var db = new DBDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
projectCode = CacheQueries.ExecuteFunction <MON_RequestTable, string, string>(
db,
tableName,
(r, value) => r.TableCode == value,
r => r.PackageCode);
}
return(ProjectCodesCache[tableName] = projectCode);
}
