public static UserDAO FindUserFromDBByName(String name)
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
UserDAO userDAO = session.QueryOver <UserDAO>()
.Where(user => user.UserId == name)
.SingleOrDefault <UserDAO>();
return(userDAO);
}
}
private UserDAO GetUserFromDB()
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
UserDAO userDAO = session
.CreateCriteria(typeof(UserDAO))
.Add(Restrictions.Eq("UserId", this.UserId))
.UniqueResult <UserDAO>();
return(userDAO);
}
}
public static TaskMainDAO GetTaskFromDB(string taskID, Sources source, Int32 tokenId)
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
TaskMainDAO taskMainDAO = session
.CreateCriteria(typeof(TaskMainDAO))
.Add(Restrictions.Eq("TaskID", taskID))
.Add(Restrictions.Eq("Source", source))
.Add(Restrictions.Eq("TokenID", tokenId))
.UniqueResult <TaskMainDAO>();
return(taskMainDAO);
}
}
private Boolean UpdateAccountVersion(Int32 acID, Int32 newVersion)
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
ISQLQuery query = session.CreateSQLQuery(String.Format(@"UPDATE SERVICE_ACCOUNT SET ACCOUNT_VERSION = '{0}' WHERE SERVICE_ID = {1}", newVersion, acID));
Int32 number = query.ExecuteUpdate();
session.Flush();
if (number > 0)
{
return(true);
}
}
return(false);
}
public Boolean UpdateTokenNameForExcel(Int32 tokeID, String newTokenName)
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
ISQLQuery query = session.CreateSQLQuery(String.Format(@"UPDATE TOKENS_IN_ACCOUNT SET TOKEN_NAME = '{0}' WHERE TOKEN_ID = {1}", newTokenName, tokeID));
Int32 number = query.ExecuteUpdate();
session.Flush();
if (number > 0)
{
return(true);
}
}
return(false);
}
public Boolean DeleteAccount(Int32 UserID, ServiceAccountDTO accountToDelete, Boolean DeleteForAllUsers)
{
Boolean succeed = false;
ISessionFactory sessionFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
ServiceAccountDAO targetAccountToDelete = accountToDelete.ServiceAccountDTOToDomain().ServiceAccountDomainToDAO();
using (ISession session = sessionFactory.OpenSession())
{
using (ITransaction transaction = session.BeginTransaction())
{
UserLinkDAO userLink = session.QueryOver <UserLinkDAO>().Where(x => x.Account.ServiceAccountId == accountToDelete.ServiceAccountId).And(x => x.UserId == UserID).SingleOrDefault();
if (userLink != null)
{
try
{
IList <UserLinkDAO> Links = session.QueryOver <UserLinkDAO>().Where(x => x.Account.ServiceAccountId == accountToDelete.ServiceAccountId).List();
if (DeleteForAllUsers)
{
foreach (var item in Links)
{
session.Delete(item);
}
session.Delete(targetAccountToDelete);
}
else
{
if (Links.Count == 1)
{
session.Delete(targetAccountToDelete);
}
session.Delete(userLink);
}
transaction.Commit();
succeed = transaction.WasCommitted;
}
catch (Exception)
{
transaction.Rollback();
return(succeed);
}
}
}
}
return(succeed);
}
/// <summary>
/// Test save. Checking are the task can be save. Without actual save in data base.
/// </summary>
/// <param name="taskMainDaoCollection">Tasks collection</param>
public static void SaveOrUpdateCollectionInDBWhithRollback(IEnumerable <TaskMainDAO> taskMainDaoCollection)
{
if (taskMainDaoCollection.Count() > 0)
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
foreach (TaskMainDAO taskMainDAO in taskMainDaoCollection)
{
session.SaveOrUpdate(taskMainDAO);
}
transaction.Rollback();
}
}
}
}
public Boolean SaveOrUdateAccount(ServiceAccountDTO account)
{
Boolean succeed = false;
ISessionFactory sessionFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
ServiceAccountDAO target = account.ServiceAccountDTOToDomain().ServiceAccountDomainToDAO();
using (ISession session = sessionFactory.OpenSession())
{
target.AccountVersion += 1;
using (ITransaction transaction = session.BeginTransaction())
{
session.SaveOrUpdate(target);
transaction.Commit();
succeed = transaction.WasCommitted;
}
}
return(succeed);
}
public static void SaveOrUpdateCollectionInDB(IEnumerable <TaskMainDAO> taskMainDaoCollection)
{
if (taskMainDaoCollection.Count() > 0)
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (var session = applicationFactory.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
foreach (TaskMainDAO taskMainDAO in taskMainDaoCollection)
{
TaskMainDAO.PutIDsInCurrentAndMatchedAndParentTaskFromDB(taskMainDAO);
session.SaveOrUpdate(taskMainDAO);
}
transaction.Commit();
}
}
}
}
public void GenerateIndexes()
{
ISessionFactory applicationFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (ISession session = applicationFactory.OpenSession())
using (IFullTextSession fullTextSession = Search.CreateFullTextSession(session))
{
using (ITransaction transaction = fullTextSession.BeginTransaction())
{
fullTextSession.PurgeAll(typeof(TaskMainDAO));
transaction.Commit();
}
using (ITransaction transaction = fullTextSession.BeginTransaction())
{
foreach (object entity in fullTextSession.CreateCriteria(typeof(TaskMainDAO)).List())
{
fullTextSession.Index(entity);
}
transaction.Commit();
}
}
}
public Boolean DeleteMapping(TemplateDTO template)
{
Boolean succeed = false;
ISessionFactory sessionFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
TemplateDAO target = template.TemplateDTOToTemplateDomain().TemplateToTemplateDAO();
using (ISession session = sessionFactory.OpenSession())
{
ServiceAccountDAO account = session.Query <ServiceAccountDAO>().Where(acount => acount.MappingTemplates.Contains(target)).SingleOrDefault();
using (ITransaction transaction = session.BeginTransaction())
{
session.Delete(target);
transaction.Commit();
succeed = transaction.WasCommitted;
if (succeed)
{
UpdateAccountVersion(account.ServiceAccountId, account.AccountVersion + 1);
}
}
}
return(succeed);
}
private List <ServiceAccountDTO> AllUserAccountsByUserID(Int32 userId, Boolean owner)
{
List <ServiceAccountDTO> allUserAccountsDTO;
ISessionFactory sessionFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (ISession session = sessionFactory.OpenSession())
{
var allUserLinks = session.QueryOver <UserLinkDAO>().Where(x => x.UserId == userId).And(link => link.Owner == owner).List();
if (allUserLinks != null)
{
List <ServiceAccountDAO> allUserAccountsDAO = allUserLinks.Select <UserLinkDAO, ServiceAccountDAO>(x => x.Account).ToList();
List <ServiceAccount> alAcc = SettingsConverter.ServiceAccountDAOCollectionToDomain(allUserAccountsDAO);
allUserAccountsDTO = SettingsConverter.ServiceAccountDomainCollectionToDTO(alAcc);
}
else
{
allUserAccountsDTO = null;
}
return(allUserAccountsDTO);
}
}
public ServiceAccountDTO GetUserAccountsByUserIDAndAccountId(Int32 userId, Int32 seviceAccountId)
{
ServiceAccountDTO UserAccountsDTO;
ISessionFactory sessionFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
using (ISession session = sessionFactory.OpenSession())
{
UserLinkDAO userLink = session.QueryOver <UserLinkDAO>().Where(x => x.UserId == userId).And(x => x.Account.ServiceAccountId == seviceAccountId).SingleOrDefault();
if (userLink != null)
{
ServiceAccount account = userLink.Account.ServiceAccountDAOToDomain(IsDetailsNeed: true);
UserAccountsDTO = account.ServiceAccountDomainToDTO();
}
else
{
UserAccountsDTO = null;
}
return(UserAccountsDTO);
}
}
public Boolean ShareTheSettingAccount(Int32 currentUserID, ServiceAccountDTO accountToShare, String shareUserName, Boolean owner)
{
Boolean succeed = false;
ISessionFactory sessionFactory = NhibernateSessionFactory.GetSessionFactory(NhibernateSessionFactory.SessionFactoryConfiguration.Application);
UserDAO shareUser;
UserLinkDAO newUserLink = new UserLinkDAO();
ServiceAccountDAO targetShareAccount = accountToShare.ServiceAccountDTOToDomain().ServiceAccountDomainToDAO();
newUserLink.Account = targetShareAccount;
newUserLink.Owner = owner;
newUserLink.UserOwnerID = currentUserID;
using (ISession session = sessionFactory.OpenSession())
{
shareUser = session.QueryOver <UserDAO>().Where(user => user.UserId == shareUserName).SingleOrDefault();
if (shareUser != null)
{
newUserLink.UserId = shareUser.ID;
UserLinkDAO checkLink = session.QueryOver <UserLinkDAO>().Where(link => link.Account.ServiceAccountId == targetShareAccount.ServiceAccountId).And(link => link.UserId == shareUser.ID).SingleOrDefault();
if (checkLink == null)
{
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(newUserLink);
transaction.Commit();
succeed = transaction.WasCommitted;
}
}
else
{
return(succeed);
}
}
}
return(succeed);
}
