public IDictionary <Guid, Guid?> GetTokensOwners()
{
lock (lockersDict)
{
using (var session = Hb8Factory.CreateSession())
{
using (var transaction = session.BeginTransaction())
{
var entities = (from n in session.Query <UM_LoginToken>()
where n.DateDeleted == null
select n).ToList();
var dict = new Dictionary <Guid, Guid?>(entities.Count);
foreach (var entity in entities)
{
if (!CheckExpiration(entity, session))
{
dict.Add(entity.ID, entity.UserID);
}
}
transaction.Commit();
return(dict);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Guid trnID;
if (Guid.TryParse(Request[trnIDKey], out trnID))
{
using (var session = Hb8Factory.CreateSession())
{
var trn = session.Query <CD_Translation>().First(n => n.ID == trnID);
TrnKey = trn.TrnKey;
ModuleName = trn.ModuleName;
LanguagePair = trn.LanguagePair;
}
}
else
{
TrnKey = Request[trnKeyKey];
ModuleName = Request[moduleNameKey];
LanguagePair = Request[languagePairKey];
}
}
tbKey.Text = TrnKey;
tbModuleName.Text = ModuleName;
tbLanguagePair.Text = LanguagePair;
}
protected void btSave_Click(object sender, EventArgs e)
{
if (TrnID == null)
{
return;
}
var session = Hb8Factory.InitSession();
var dbTrn = (from n in session.Query <CD_Translation>()
where n.ID == TrnID
select n).Single();
//dbTrn.DefaultText = tbDefaultText.Text;
dbTrn.TranslatedText = tbTranslatedText.Text;
dbTrn.DateChanged = DateTime.Now;
session.SubmitChanges(dbTrn);
var trnsList = Cache[cacheKey] as List <CD_Translation>;
if (trnsList != null)
{
var localTrn = trnsList.FirstOrDefault(n => n.ID == TrnID);
if (localTrn != null)
{
localTrn.TranslatedText = dbTrn.TranslatedText;
localTrn.DateChanged = dbTrn.DateChanged;
}
}
FillTranslationsGrid();
mpeEdit.Hide();
}
public bool ValidateToken(Guid token)
{
var locker = GetLocker(token);
lock (locker)
{
using (var session = Hb8Factory.CreateSession())
{
using (var transaction = session.BeginTransaction())
{
var entity = (from n in session.Query <UM_LoginToken>()
where n.DateDeleted == null &&
n.LoginToken == token
select n).FirstOrDefault();
var result = !CheckExpiration(entity, session);
if (result)
{
result = (entity != null);
}
transaction.Commit();
return(result);
}
}
}
}
public void ReleaseUserToken(Guid token)
{
var locker = GetLocker(token);
lock (locker)
{
using (var session = Hb8Factory.CreateSession())
{
using (var transaction = session.BeginTransaction())
{
var entity = (from n in session.Query <UM_LoginToken>()
where n.DateDeleted == null &&
n.LoginToken == token
select n).FirstOrDefault();
if (entity != null)
{
entity.DateDeleted = DateTime.Now;
entity.DeleteReason = 1;
session.Update(entity);
RemoveLocker(token);
}
transaction.Commit();
}
}
}
}
public static UserContract GetUser(Guid token, Guid userID)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var currentUser = GetCurrentUser(token);
if (currentUser == null)
{
return(null);
}
var session = Hb8Factory.InitSession();
var query = from n in session.Query <UM_User>()
where n.ID == userID
select n;
var user = query.FirstOrDefault();
if (user == null)
{
return(null);
}
if (!currentUser.IsSuperAdmin)
{
user.Password = null;
}
return(user.ToContract());
}
protected void Page_PreRender(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(TrnKey))
{
SetErrorMessage("Invalid TrnKey");
return;
}
if (String.IsNullOrWhiteSpace(ModuleName))
{
SetErrorMessage("Invalid ModuleName");
return;
}
if (String.IsNullOrWhiteSpace(LanguagePair))
{
SetErrorMessage("Invalid LanguagePair");
return;
}
using (var session = Hb8Factory.CreateSession())
{
var trn = (from n in session.Query <CD_Translation>()
where n.DateDeleted == null &&
n.TrnKey.ToLower() == TrnKey.ToLower() &&
n.LanguagePair.ToLower() == LanguagePair.ToLower() &&
n.ModuleName.ToLower() == ModuleName.ToLower()
select n).Single();
tbDefaultText.Text = trn.DefaultText;
tbTranslatedText.Text = trn.TranslatedText;
}
}
protected void lnkDeleteLang_Click(object sender, EventArgs e)
{
var control = sender as LinkButton;
if (control == null)
{
return;
}
Guid langID;
if (!Guid.TryParse(control.CommandArgument, out langID))
{
return;
}
using (var session = Hb8Factory.CreateSession())
{
var language = (from n in session.Query <CD_Language>()
where n.ID == langID
select n).FirstOrDefault();
if (language == null)
{
return;
}
language.DateDeleted = DateTime.Now;
session.SubmitChanges(language);
}
}
public Guid?GetTokenOwnerID(Guid token)
{
var locker = GetLocker(token);
lock (locker)
{
using (var session = Hb8Factory.CreateSession())
{
using (var transaction = session.BeginTransaction())
{
var entity = (from n in session.Query <UM_LoginToken>()
where n.DateDeleted == null &&
n.LoginToken == token
select n).FirstOrDefault();
var user = (Guid?)null;
if (!CheckExpiration(entity, session))
{
if (entity != null)
{
user = entity.UserID;
}
}
transaction.Commit();
return(user);
}
}
}
}
public static List <UserContract> GetAllUsers(Guid token, bool deleteds)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var currentUser = GetCurrentUser(token);
if (currentUser == null)
{
return(null);
}
var session = Hb8Factory.InitSession();
var query = from n in session.Query <UM_User>()
select n;
if (!deleteds)
{
query = from n in query
where n.DateDeleted == null
select n;
}
var items = query.ToList();
if (!currentUser.IsSuperAdmin)
{
items.ForEach(p => p.Password = null);
}
return(items.ToContracts());
}
public static void UpdateUser(UM_User user)
{
if (user == null)
{
return;
}
var session = Hb8Factory.InitSession();
var exUser = session.Query <UM_User>().FirstOrDefault(n => n.ID == user.ID);
if (exUser == null)
{
return;
}
exUser.ID = user.ID;
exUser.LoginName = user.LoginName;
exUser.Password = user.Password;
exUser.PasswordExpirationDate = user.PasswordExpirationDate;
exUser.FirstName = user.FirstName;
exUser.LastName = user.LastName;
exUser.IsActive = user.IsActive;
exUser.IsSuperAdmin = user.IsSuperAdmin;
exUser.Email = user.Email;
exUser.Address = user.Address;
exUser.DateChanged = user.DateChanged;
exUser.DateCreated = user.DateCreated;
exUser.DateDeleted = user.DateDeleted;
session.SubmitUpdate(exUser);
}
protected void FillTranslationsGrid()
{
var session = Hb8Factory.InitSession();
var query = from n in session.Query <CD_Translation>()
where n.DateDeleted == null
select n;
if (cbxModules.SelectedItem != null && cbxModules.SelectedIndex > 0)
{
var selectedModule = Convert.ToString(cbxModules.SelectedItem.Value);
query = from n in query
where n.ModuleName == selectedModule
select n;
}
if (cbxLanguagePairs.SelectedItem != null && cbxLanguagePairs.SelectedIndex > 0)
{
var selectedLangPair = Convert.ToString(cbxLanguagePairs.SelectedItem.Value);
query = from n in query
where n.LanguagePair == selectedLangPair
select n;
}
gvTrns.DataSource = query;
gvTrns.DataBind();
}
public static List <AreaContract> GetAreasByCode(int code, RecordTypesEnum recordType)
{
var session = Hb8Factory.InitSession();
var areasQuery = from n in session.Query <CD_Area>()
where n.AreaType.Code == code
select n;
switch (recordType)
{
case RecordTypesEnum.Active:
{
areasQuery = from n in areasQuery
where n.DateDeleted == null
select n;
}
break;
case RecordTypesEnum.Inactive:
{
areasQuery = from n in areasQuery
where n.DateDeleted != null
select n;
}
break;
}
var areas = areasQuery.ToList();
return(areas.ToContracts());
}
private static PermissionContract GetPermissionContract(UM_Resource resource, Guid groupID, Guid projectID)
{
var session = Hb8Factory.InitSession();
var permission = (from n in session.Query <UM_Permission>()
where n.DateDeleted == null &&
n.GroupID == groupID &&
n.ResourceID == resource.ID
orderby n.RuleValue descending
select n).FirstOrDefault();
if (permission != null)
{
return(permission.ToContract(projectID));
}
if (resource.Parent == null)
{
var newPemission = new UM_Permission
{
ID = Guid.NewGuid(),
GroupID = groupID,
ResourceID = resource.ID,
RuleValue = (int)RulePermissionsEnum.View,
DateCreated = DateTime.Now
};
session.SubmitInsert(newPemission);
return(newPemission.ToContract(projectID));
}
return(GetPermissionContract(resource.Parent, groupID, projectID));
}
public static List <ProjectContract> GetProjectByUserToken(Guid token)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var currentUser = GetCurrentUser(token);
if (currentUser == null)
{
return(null);
}
var session = Hb8Factory.InitSession();
var projects = (from gu in session.Query <UM_GroupUser>()
where gu.UserID == currentUser.ID &&
gu.DateDeleted == null
let @group = gu.Group
where @group != null && @group.DateDeleted == null
let project = @group.Project
where project != null && project.DateDeleted == null
select project).Distinct().ToList();
return(projects.ToContracts());
}
public static List <ProjectContract> GetProjects()
{
var session = Hb8Factory.InitSession();
var items = session.Query <UM_Project>().Where(n => n.DateDeleted == null).ToList();
return(items.ToContracts());
}
private static IList <CD_Language> LoadLanguages()
{
using (var session = Hb8Factory.CreateSession())
{
var languagesList = session.Query <CD_Language>().Where(n => n.DateDeleted == null).ToList();
return(languagesList);
}
}
public static Dictionary <Guid, Dictionary <String, String> > GetAllUsersGlobalAttribetes(Guid token, bool deleteds)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var session = Hb8Factory.InitSession();
var usersQuery = session.Query <UM_User>();
if (!deleteds)
{
usersQuery = from n in usersQuery
where n.DateDeleted == null
select n;
}
var globalAttrQuery = from user in usersQuery
join attr in session.Query <UM_AttributeValue>() on user.ID equals attr.ParentID
where attr.DateDeleted == null
let field = attr.AttributeField
where field != null &&
field.DateDeleted == null
let schema = field.AttributeSchema
where schema != null &&
schema.DateDeleted == null
where schema.ProjectID == null
select new
{
attr.ParentID,
field.Name,
attr.Value
};
var globaAttrLp = globalAttrQuery.ToLookup(n => n.ParentID);
var globalAttrDict = new Dictionary <Guid, Dictionary <String, String> >();
foreach (var globalAttrGrp in globaAttrLp)
{
var dict = new Dictionary <String, String>();
var attrLp = globalAttrGrp.ToLookup(n => n.Name);
foreach (var attrGrp in attrLp)
{
var valuesQuery = attrGrp.Select(n => n.Value).ToHashSet(StringComparer.OrdinalIgnoreCase);
var values = String.Join(";", valuesQuery);
dict.Add(attrGrp.Key, values);
}
globalAttrDict.Add(globalAttrGrp.Key, dict);
}
return(globalAttrDict);
}
public static AreaContract GetAreaByID(Guid ID)
{
var session = Hb8Factory.InitSession();
var area = (from a in session.Query <CD_Area>()
where a.ID == ID
select a).FirstOrDefault();
return(area.ToContract());
}
public static List <MobileIndexesContract> GetAllMobileIndexes()
{
var session = Hb8Factory.InitSession();
var mobileIndexes = (from n in session.Query <CD_MobileIndex>()
where n.DateDeleted == null
select n).ToList();
return(mobileIndexes.ToContracts());
}
public static List <AreaContract> GetChildAreas(Guid parentID)
{
var session = Hb8Factory.InitSession();
var childAreas = (from a in session.Query <CD_Area>()
where a.ParentID == parentID
select a).ToList();
return(childAreas.ToContracts());
}
public static bool HasMessages(Guid token, Guid?projectID)
{
var user = GetCurrentUser(token);
if (user == null)
{
throw new Exception("Unable to get user by token");
}
var userGroups = GetUserGroups(token, user.ID, projectID);
if (userGroups == null)
{
return(false);
}
var objectsSet = userGroups.Select(p => (Guid?)p.ID).ToHashSet();
objectsSet.Add(projectID);
objectsSet.Add(user.ID);
var session = Hb8Factory.InitSession();
var commonMessagesQuery = from n in session.Query <UM_Message>()
where n.DateDeleted == null &&
n.Type == (int)MessageTypeEnum.All &&
Enumerable.Contains(objectsSet, n.ObjectID)
select n;
var commonMessages = commonMessagesQuery.ToList();
var userMessagesQuery = from n in session.Query <UM_Message>()
where n.DateDeleted == null &&
n.Type == (int)MessageTypeEnum.Standard &&
Enumerable.Contains(objectsSet, n.ObjectID)
select n;
var userMessages = userMessagesQuery.ToList();
var messagesViewersQuery = from n in userMessagesQuery
from m in n.MessageViewers
where m.DateDeleted == null &&
m.UserID == user.ID
select m;
var messageViewersLp = messagesViewersQuery.ToLookup(n => n.MessageID);
var unreadMessages = (from n in userMessages
where !messageViewersLp[n.ID].Any()
select n).ToList();
var totalCount = commonMessages.Count + unreadMessages.Count;
return(totalCount > 0);
}
protected void btSave_Click(object sender, EventArgs e)
{
lblMessage.Text = String.Empty;
if (String.IsNullOrWhiteSpace(tbDisplayName.Text))
{
lblMessage.Text = "Please enter display name";
mpeAddEdit.Show();
return;
}
if (String.IsNullOrWhiteSpace(tbPair.Text))
{
lblMessage.Text = "Please enter pair";
mpeAddEdit.Show();
return;
}
using (var session = Hb8Factory.CreateSession())
{
CD_Language language;
if (LangID == null)
{
language = new CD_Language();
language.ID = Guid.NewGuid();
language.DateCreated = DateTime.Now;
}
else
{
language = (from n in session.Query <CD_Language>()
where n.ID == LangID
select n).FirstOrDefault();
if (language == null)
{
return;
}
}
language.DisplayName = tbDisplayName.Text;
language.EngName = tbEngName.Text;
language.NativeName = tbNativeName.Text;
language.Pair = tbPair.Text;
session.SubmitChanges(language);
mpeAddEdit.Hide();
}
FillLanguagesGrid();
}
protected void FillLanguagesGrid()
{
using (var session = Hb8Factory.CreateSession())
{
var languages = (from n in session.Query <CD_Language>()
where n.DateDeleted == null
select n).ToList();
gvLanguages.DataSource = languages;
gvLanguages.DataBind();
}
}
public static void SetTranslation(String moduleName, String languagePair, String trnKey, TranslationContract contract)
{
if (String.IsNullOrWhiteSpace(moduleName))
{
throw new ArgumentNullException("moduleName");
}
if (String.IsNullOrWhiteSpace(trnKey))
{
throw new ArgumentNullException("trnKey");
}
if (String.IsNullOrWhiteSpace(languagePair))
{
throw new ArgumentNullException("languagePair");
}
if (contract == null)
{
throw new ArgumentNullException("contract");
}
var session = Hb8Factory.InitSession();
var entity = (from n in session.Query <CD_Translation>()
where n.DateDeleted == null &&
n.TrnKey.ToLower() == trnKey.ToLower() &&
n.LanguagePair.ToLower() == languagePair.ToLower() &&
n.ModuleName.ToLower() == moduleName.ToLower()
select n).SingleOrDefault();
if (entity == null)
{
entity = new CD_Translation
{
ID = Guid.NewGuid(),
DateCreated = DateTime.Now
};
entity.TrnKey = trnKey;
entity.ModuleName = moduleName;
entity.LanguagePair = languagePair;
entity.DefaultText = contract.DefaultText;
entity.TranslatedText = contract.TranslatedText;
session.SubmitChanges(entity);
}
else
{
TranslationCache.SetTranslatedText(moduleName, languagePair, trnKey, contract.TranslatedText);
}
}
public static UM_User GetUser(String loginName)
{
loginName = (loginName ?? String.Empty);
var session = Hb8Factory.InitSession();
var user = (from n in session.Query <UM_User>()
where n.DateDeleted == null &&
n.LoginName.Trim().ToLower() == loginName.Trim().ToLower()
select n).FirstOrDefault();
return(user);
}
public static MobileIndexesContract GetMobileIndexByID(Guid?ID)
{
if (ID == null || ID == Guid.Empty)
{
return(null);
}
var session = Hb8Factory.InitSession();
var mobileIndex = (from n in session.Query <CD_MobileIndex>()
where n.ID == ID
select n).FirstOrDefault();
return(mobileIndex.ToContract());
}
public static List <GroupContract> GetProjectGroups(Guid token, Guid projectID)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var session = Hb8Factory.InitSession();
var items = (from n in session.Query <UM_Group>()
where n.ProjectID == projectID &&
n.DateDeleted == null
select n).ToList();
return(items.ToContracts());
}
public static List <UserContract> GetGroupUsers(Guid token, Guid groupID)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var session = Hb8Factory.InitSession();
var items = (from gu in session.Query <UM_GroupUser>()
where gu.GroupID == groupID && gu.DateDeleted == null
let user = gu.User
where user != null &&
user.ID == gu.UserID &&
user.DateDeleted == null
select user).ToList();
return(items.ToContracts());
}
protected void FillAttributesTree()
{
using (var session = Hb8Factory.CreateSession())
{
var attributesSchemas = (from n in session.Query<UM_AttributeSchema>()
where n.DateDeleted == null
select n).ToList();
var converter = new AttributeSchemaEntityModelConverter(session);
var model = new AttributeSchemasModel
{
List = attributesSchemas.Select(n => converter.Convert(n)).ToList()
};
attributesSchemasControl.Model = model;
attributesSchemasControl.DataBind();
}
}
