protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Guid trnID;
if (Guid.TryParse(Request[trnIDKey], out trnID))
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var trn = db.CD_Translations.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;
}
public static List <ProjectContract> GetProjectByUserToken(Guid token)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
var currentUser = GetCurrentUser(token);
if (currentUser == null)
{
return(null);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var projects = (from gu in db.UM_GroupUsers
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 void UpdateUser(UM_User user)
{
if (user == null)
{
return;
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var exUser = db.UM_Users.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;
db.SubmitChanges();
}
}
protected void FillTranslationsGrid()
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var query = from n in db.CD_Translations
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();
}
}
protected void btSave_Click(object sender, EventArgs e)
{
if (TrnID == null)
{
return;
}
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var dbTrn = (from n in db.CD_Translations
where n.ID == TrnID
select n).Single();
//dbTrn.DefaultText = tbDefaultText.Text;
dbTrn.TranslatedText = tbTranslatedText.Text;
dbTrn.DateChanged = DateTime.Now;
db.SubmitChanges();
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 void ReleaseUserToken(Guid token)
{
var locker = GetLocker(token);
lock (locker)
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
//db.EnableChangesLog = false;
var loginToken = (from n in db.UM_LoginTokens
where n.DateDeleted == null &&
n.LoginToken == token
select n).FirstOrDefault();
if (loginToken != null)
{
loginToken.DateDeleted = DateTime.Now;
loginToken.DeleteReason = 1;
db.SubmitChanges();
RemoveLocker(token);
}
}
}
}
public bool ValidateToken(Guid token)
{
var locker = GetLocker(token);
lock (locker)
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
//db.EnableChangesLog = false;
var loginToken = (from n in db.UM_LoginTokens
where n.DateDeleted == null &&
n.LoginToken == token
select n).FirstOrDefault();
var result = !CheckExpiration(loginToken);
if (result)
{
result = (loginToken != null);
}
db.SubmitChanges();
return(result);
}
}
}
public IDictionary <Guid, Guid?> GetTokensOwners()
{
lock (lockersDict)
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
//db.EnableChangesLog = false;
var loginTokens = (from n in db.UM_LoginTokens
where n.DateDeleted == null
select n).ToList();
var dict = new Dictionary <Guid, Guid?>(loginTokens.Count);
foreach (var loginToken in loginTokens)
{
if (!CheckExpiration(loginToken))
{
dict.Add(loginToken.ID, loginToken.UserID);
}
}
db.SubmitChanges();
return(dict);
}
}
}
private static PermissionContract GetPermissionContract(UM_Resource resource, Guid groupID, Guid projectID)
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var permission = (from n in db.UM_Permissions
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();
newPemission.ID = Guid.NewGuid();
newPemission.GroupID = groupID;
newPemission.ResourceID = resource.ID;
newPemission.RuleValue = (int)RulePermissionsEnum.View;
newPemission.DateCreated = DateTime.Now;
db.UM_Permissions.InsertOnSubmit(newPemission);
db.SubmitChanges();
return(newPemission.ToContract(projectID));
}
return(GetPermissionContract(resource.Parent, groupID, projectID));
}
}
public static UM_User GetUser(Guid userID)
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
return(db.UM_Users.FirstOrDefault(n => n.ID == userID));
}
}
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 db = DcFactory.Create <CommonDataDataContext>())
{
var language = (from n in db.CD_Languages
where n.ID == langID
select n).FirstOrDefault();
if (language == null)
{
return;
}
language.DateDeleted = DateTime.Now;
db.SubmitChanges();
}
}
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 db = DcFactory.Create <CommonDataDataContext>())
{
var trn = (from n in db.CD_Translations
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;
}
}
public Guid?GetTokenOwnerID(Guid token)
{
var locker = GetLocker(token);
lock (locker)
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
//db.EnableChangesLog = false;
var loginToken = (from n in db.UM_LoginTokens
where n.DateDeleted == null &&
n.LoginToken == token
select n).FirstOrDefault();
var user = (Guid?)null;
if (!CheckExpiration(loginToken))
{
if (loginToken != null)
{
user = loginToken.UserID;
}
}
db.SubmitChanges();
return(user);
}
}
}
public static List <AreaContract> GetAreasByCode(int code, RecordTypesEnum recordType)
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var areasQuery = from t in db.CD_Areas
let areaType = t.AreaType
where areaType.Code == code
select t;
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 IList <CD_Language> LoadLanguages()
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var languagesList = db.CD_Languages.Where(n => n.DateDeleted == null).ToList();
return(languagesList);
}
}
public static List <ProjectContract> GetProjects()
{
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var items = db.UM_Projects.Where(n => n.DateDeleted == null).ToList();
return(items.ToContracts());
}
}
public static Dictionary <String, String> GetUserAttributesDictionary(Guid token, Guid userID, Guid projectID)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var globalItems = (from userAttr in db.UM_UserAttributes
where userAttr.DateDeleted == null &&
userAttr.UserID == userID
let node = userAttr.AttributesSchemaNode
where node != null &&
node.DateDeleted == null
let schema = node.AttributesSchema
where schema != null &&
schema.DateDeleted == null
where schema.ProjectID == null
select new { node.Name, userAttr.Value }).ToList();
var projectItems = (from userAttr in db.UM_UserAttributes
where userAttr.DateDeleted == null &&
userAttr.UserID == userID
let node = userAttr.AttributesSchemaNode
where node != null &&
node.DateDeleted == null
let schema = node.AttributesSchema
where schema != null &&
schema.DateDeleted == null
let project = schema.Project
where project != null &&
project.DateDeleted == null &&
project.ID == projectID
select new { node.Name, userAttr.Value }).ToList();
var allItems = globalItems.Union(projectItems);
var comparer = StringComparer.OrdinalIgnoreCase;
var allItemsLp = allItems.ToLookup(n => n.Name, comparer);
var dict = new Dictionary <String, String>(comparer);
foreach (var itemsGrp in allItemsLp)
{
var valuesQuery = (from n in itemsGrp
where !String.IsNullOrWhiteSpace(n.Value)
select n.Value);
var @set = valuesQuery.ToHashSet(comparer);
var values = String.Join(",", @set);
dict[itemsGrp.Key] = values;
}
return(dict);
}
}
public static Dictionary <Guid, Dictionary <String, String> > GetAllUsersGlobalAttribetes(Guid token, bool deleteds)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var usersQuery = from n in db.UM_Users
select n;
if (!deleteds)
{
usersQuery = from n in usersQuery
where n.DateDeleted == null
select n;
}
var globalAttrQuery = from user in usersQuery
from attr in user.UserAttributes
where attr.DateDeleted == null
let node = attr.AttributesSchemaNode
where node != null &&
node.DateDeleted == null
let schema = node.AttributesSchema
where schema != null &&
schema.DateDeleted == null
where schema.ProjectID == null
select new
{
UserID = attr.UserID,
Name = node.Name,
Value = attr.Value
};
var globaAttrLp = globalAttrQuery.ToLookup(n => n.UserID);
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);
}
}
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 db = DcFactory.Create <CommonDataDataContext>())
{
CD_Language language;
if (LangID == null)
{
language = new CD_Language();
language.ID = Guid.NewGuid();
language.DateCreated = DateTime.Now;
db.CD_Languages.InsertOnSubmit(language);
}
else
{
language = (from n in db.CD_Languages
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;
db.SubmitChanges();
mpeAddEdit.Hide();
}
FillLanguagesGrid();
}
public static List <MobileIndexesContract> GetAllMobileIndexes()
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var mobileIndexes = (from i in db.CD_MobileIndexes
where i.DateDeleted == null
select i).ToList();
return(mobileIndexes.ToContracts());
}
}
public static AreaContract GetAreaByID(Guid Id)
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var area = (from a in db.CD_Areas
where a.ID == Id
select a).FirstOrDefault();
return(area.ToContract());
}
}
public static List <AreaContract> GetChildAreas(Guid ParentID)
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var childAreas = (from a in db.CD_Areas
where a.ParentID == ParentID
select a).ToList();
return(childAreas.ToContracts());
}
}
protected void FillLanguagesGrid()
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var languages = (from n in db.CD_Languages
where n.DateDeleted == null
select n).ToList();
gvLanguages.DataSource = languages;
gvLanguages.DataBind();
}
}
public static UM_User GetUser(String loginName)
{
loginName = (loginName ?? String.Empty);
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var user = (from n in db.UM_Users
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);
}
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var mobileIndex = (from i in db.CD_MobileIndexes
where i.ID == ID && i.DateDeleted == null
select i).FirstOrDefault();
return(mobileIndex.ToContract());
}
}
public static List <GroupContract> GetProjectGroups(Guid token, Guid projectID)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var items = (from n in db.UM_Groups
where n.ProjectID == projectID &&
n.DateDeleted == null
select n).ToList();
return(items.ToContracts());
}
}
public static bool HasMessages(Guid token, Guid?moduleId)
{
var user = GetCurrentUser(token);
if (user == null)
{
throw new Exception("Unable to get user by token");
}
var userGroups = GetUserGroups(token, user.ID, moduleId.Value);
if (userGroups == null)
{
return(false);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var objectsList = userGroups.Select(p => p.ID).ToSortedSet();
objectsList.Add(moduleId.Value);
objectsList.Add(user.ID);
var objectsArrays = objectsList.ToArray();
var allTypeMessagesQuery = from n in db.UM_Messages
where n.DateDeleted == null &&
n.Type == (int)MessageTypeEnum.All &&
objectsArrays.Contains(n.ObjectID)
select n;
var stdMessagesQuery = from n in db.UM_Messages
let count = n.MessageViewers.Count(t => t.UserID != user.ID)
where n.DateDeleted == null &&
objectsArrays.Contains(n.ObjectID) &&
(n.Type == (int)MessageTypeEnum.Standard && count == 0)
select n;
var messagesQuery = stdMessagesQuery.Union(allTypeMessagesQuery);
var messagesCount = messagesQuery.Count();
return(messagesCount > 0);
}
}
protected void btSave_Click(object sender, EventArgs e)
{
using (var db = DcFactory.Create <CommonDataDataContext>())
{
var dbTrn = (from n in db.CD_Translations
where n.DateDeleted == null &&
n.TrnKey.ToLower() == TrnKey.ToLower() &&
n.LanguagePair.ToLower() == LanguagePair.ToLower() &&
n.ModuleName.ToLower() == ModuleName.ToLower()
select n).Single();
dbTrn.DefaultText = tbDefaultText.Text;
dbTrn.TranslatedText = tbTranslatedText.Text;
db.SubmitChanges();
SetSuccessMessage("Save successfully");
}
}
public static List <PermissionContract> GetAllResourcesPermissions(Guid token, Guid?projectID)
{
var tokenUser = GetCurrentUser(token);
if (tokenUser == null)
{
return(null);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var query = from user in db.UM_Users
where user.ID == tokenUser.ID
from userGroup in user.GroupUsers
where userGroup.DateDeleted == null
let @group = userGroup.Group
where @group.DateDeleted == null
from perm in @group.Permissions
let res = perm.Resource
where perm.DateDeleted == null &&
res.DateDeleted == null
select new
{
//GroupID = @group.ID,
//GroupName = @group.Name,
ProjectID = res.ProjectID,
Permission = perm
};
if (projectID != null)
{
query = from item in query
where item.ProjectID == projectID || item.ProjectID == null
select item;
}
var entities = query.ToList();
var contracts = entities.Select(n => n.Permission.ToContract(n.ProjectID)).ToList();
return(contracts);
}
}
public static List <UserContract> GetGroupUsers(Guid token, Guid groupID)
{
if (!AccessController.ValidateToken(token))
{
return(null);
}
using (var db = DcFactory.Create <UserManagementDataContext>())
{
var items = (from gu in db.UM_GroupUsers
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());
}
}
