public static void SetUserActivityTime(string sid, DateTime time)
{
WebInitializer.Initialize();
using (var db = new DBDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
db.ADM_P_SetUserActivityTime(sid, time);
}
}
public static UsersInRoleResult[] GetUsersInRole(string role)
{
using (var db = new DBDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
using (var data = db.ADM_GetUsersInRole(role))
return(data.ToArray());
}
}
private static TResult GetPersonInfoInternal <TResult>(string sid)
{
if (string.IsNullOrEmpty(sid))
{
return(default(TResult));
}
try
{
if (InitializerSection.GetSection().IsConvertToSSDL)
{
if (!sid.StartsWith("S-") && !"anonymous".Equals(sid))
{
var base64 = Convert.FromBase64String(sid);
var sidValue = new SecurityIdentifier(base64, 0);
sid = sidValue.Value;
}
}
}
catch (FormatException)
{
}
var key = PersonInfoBySid + typeof(TResult).FullName + ">:" + sid;
TResult value;
if (HttpContext.Current != null && HttpContext.Current.Cache[key] != null)
{
value = (TResult)HttpContext.Current.Cache[key];
}
else
{
WebInitializer.Initialize();
using (var db = new DBDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
value = db.GetPersonInfoBySid <TResult>(sid).FirstOrDefault();
if (value != null && HttpContext.Current != null)
{
HttpContext.Current.Cache.Add(
key,
value,
null,
DateTime.Now.AddMinutes(2),
Cache.NoSlidingExpiration,
CacheItemPriority.Normal,
null);
}
}
}
return(value);
}
public static void AddViewReports(
string sid,
string loginName,
string name,
string docLocation,
string siteUrl,
string hostName,
bool export,
string plugin,
string titleRu,
string titleKz)
{
using (var db = new DBDataContext(SpecificInstances.DbFactory.CreateConnection()))
{
if (siteUrl.EndsWith("/") || siteUrl.EndsWith("\\"))
{
siteUrl = siteUrl.Substring(0, siteUrl.Length - 1);
}
if (docLocation.StartsWith(siteUrl))
{
docLocation = docLocation.Substring(siteUrl.Length);
}
if (docLocation.StartsWith("/") || docLocation.StartsWith("\\"))
{
docLocation = docLocation.Substring(1);
}
if (plugin.StartsWith("/") || plugin.StartsWith("\\"))
{
plugin = plugin.Substring(1);
}
db.MSD_P_AddViewReports(
sid,
loginName,
name,
DateTime.UtcNow,
docLocation,
siteUrl,
hostName,
new Guid("{B85A2C1A-E75F-47CD-84DA-CA3295CC7BFB}"),
export,
plugin,
titleRu,
titleKz);
}
}