/// <summary>
/// Repository példányosítása session-el
/// </summary>
/// <param name="session"></param>
public Repository(NHibernate.ISession session)
{
if (session == null)
{
throw new ArgumentNullException("session");
}
this.session = session;
}
/// <summary>
/// Main form that the Bumbershoot GUI runs from
/// </summary>
public QueueForm()
{
try
{
InitializeComponent();
var sessionFactory = SessionManager.CreateSessionFactory();
_session = sessionFactory.OpenSession();
}
catch (Exception error)
{
MessageBox.Show("BumberDash could not initilize:" + error.Message + Environment.NewLine + error.StackTrace);
throw;
}
}
/// <summary>
/// Closes the session provider and cleans everything up
/// </summary>
public void Close()
{
if (this.SessionInThread != null)
{
//flush anything to the datastore
this.SessionInThread.Flush();
//if the session is open, close it
if (this.SessionInThread.IsOpen)
this.SessionInThread.Close();
this.SessionInThread.Dispose();
this.SessionInThread = null;
}
}
private static void LoadHandlingEventData(ISession session)
{
const string handlingEventSql =
"insert into HandlingEvent (completionTime, registrationTime, type, location_id, voyage_id, cargo_id) " +
"values (?, ?, ?, ?, ?, ?)";
var handlingEventArgs = new[]
{
//XYZ (SESTO-FIHEL-DEHAM-CNHKG-JPTOK-AUMEL)
new object[] {Ts(0), Ts((0)), "RECEIVE", 1, null, 1},
new object[] {Ts((4)), Ts((5)), "LOAD", 1, 1, 1},
new object[] {Ts((14)), Ts((14)), "UNLOAD", 5, 1, 1},
new object[] {Ts((15)), Ts((15)), "LOAD", 5, 1, 1},
new object[] {Ts((30)), Ts((30)), "UNLOAD", 6, 1, 1},
new object[] {Ts((33)), Ts((33)), "LOAD", 6, 1, 1},
new object[] {Ts((34)), Ts((34)), "UNLOAD", 3, 1, 1},
new object[] {Ts((60)), Ts((60)), "LOAD", 3, 1, 1},
new object[] {Ts((70)), Ts((71)), "UNLOAD", 4, 1, 1},
new object[] {Ts((75)), Ts((75)), "LOAD", 4, 1, 1},
new object[] {Ts((88)), Ts((88)), "UNLOAD", 2, 1, 1},
new object[] {Ts((100)), Ts((102)), "CLAIM", 2, null, 1},
//ZYX (AUMEL - USCHI - DEHAM -)
new object[] {Ts((200)), Ts((201)), "RECEIVE", 2, null, 3},
new object[] {Ts((202)), Ts((202)), "LOAD", 2, 2, 3},
new object[] {Ts((208)), Ts((208)), "UNLOAD", 7, 2, 3},
new object[] {Ts((212)), Ts((212)), "LOAD", 7, 2, 3},
new object[] {Ts((230)), Ts((230)), "UNLOAD", 6, 2, 3},
new object[] {Ts((235)), Ts((235)), "LOAD", 6, 2, 3},
//ABC
new object[] {Ts((20)), Ts((21)), "CLAIM", 2, null, 2},
//CBA
new object[] {Ts((0)), Ts((1)), "RECEIVE", 2, null, 4},
new object[] {Ts((10)), Ts((11)), "LOAD", 2, 2, 4},
new object[] {Ts((20)), Ts((21)), "UNLOAD", 7, 2, 4},
//FGH
new object[] {Ts(100), Ts(160), "RECEIVE", 3, null, 5},
new object[] {Ts(150), Ts(110), "LOAD", 3, 3, 5},
//JKL
new object[] {Ts(200), Ts(220), "RECEIVE", 6, null, 6},
new object[] {Ts(300), Ts(330), "LOAD", 6, 3, 6},
new object[] {Ts(400), Ts(440), "UNLOAD", 5, 3, 6} // Unexpected event
};
ExecuteUpdate(session, handlingEventSql, handlingEventArgs);
}
public void SetData(NHibernate.ISession session, DataFilter viewFilter)
{
this.session = session;
this.viewFilter = viewFilter;
ClearData();
dataGridView.Rows.Clear();
foreach (var filter in session.Query<PersistentDataFilter>().OrderByDescending(o => o.Id).ToList())
{
dataGridView.Rows.Add(filter.Id,
filter.MaximumQValue,
filter.MinimumDistinctPeptides,
filter.MinimumSpectra,
filter.MinimumAdditionalPeptides,
filter.GeneLevelFiltering,
filter.DistinctMatchFormat,
filter.MinimumSpectraPerDistinctMatch,
filter.MinimumSpectraPerDistinctPeptide,
filter.MaximumProteinGroupsPerPeptide,
filter.TotalCounts.Clusters,
filter.TotalCounts.ProteinGroups,
filter.TotalCounts.Proteins,
filter.TotalCounts.GeneGroups,
filter.TotalCounts.Genes,
filter.TotalCounts.DistinctPeptides,
filter.TotalCounts.DistinctMatches,
filter.TotalCounts.FilteredSpectra,
filter.TotalCounts.ProteinFDR * 100,
filter.TotalCounts.PeptideFDR * 100,
filter.TotalCounts.SpectrumFDR * 100);
dataGridView.Rows[dataGridView.RowCount - 1].Tag = filter;
}
dataGridView.Rows[0].Tag = viewFilter;
dataGridView.Enabled = true;
dataGridView.Refresh();
}
/// <sugetAllFacebookAccountsOfUsermmary>
/// Get all Facebook Account of User by UserId(Guid).
/// </summary>
/// <param name="UserId">UserId of User(Guid)</param>
/// <returns>Retutn all FacebookAccount in form of ArrayList</returns>
//public ArrayList getAllFacebookAccountsOfUser(Guid UserId)
//{
// //Creates a database connection and opens up a session
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //After Session creation, start Transaction.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// //Proceed action, to Get all FacebookAccount by UserId(Guid).
// NHibernate.IQuery query = session.CreateQuery("from FacebookAccount where UserId = :userid");
// query.SetParameter("userid", UserId);
// ArrayList alstFBAccounts = new ArrayList();
// foreach (var item in query.Enumerable())
// {
// alstFBAccounts.Add(item);
// }
// return alstFBAccounts;
// }//End Transaction
// }//End session
//}
public List <Domain.Socioboard.Domain.FacebookAccount> getAllFacebookAccountsOfUser(Guid UserId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to Get all FacebookAccount by UserId(Guid).
NHibernate.IQuery query = session.CreateQuery("from FacebookAccount where UserId = :userid");
query.SetParameter("userid", UserId);
//ArrayList alstFBAccounts = new ArrayList();
List <Domain.Socioboard.Domain.FacebookAccount> alstFBAccounts = new List <Domain.Socioboard.Domain.FacebookAccount>();
foreach (var item in query.Enumerable())
{
alstFBAccounts.Add((Domain.Socioboard.Domain.FacebookAccount)item);
}
return(alstFBAccounts);
} //End Transaction
} //End session
}
/// <getFacebookInsightStatsAgeWiseById>
/// Get all FacebookinsightStats of user from Database by UserId(Guid) and FbUserId(string) and Age wise.
/// </summary>
/// <param name="Fbuserid">FbUserId FacebookInsightStats(String).</param>
/// <param name="userId">UserId FacebookInsightStats(Guid).</param>
/// <param name="days">Integer Days.</param>
/// <returns>Return all Facebookinsight Stats by Age wise in form of Array List.</returns>
public ArrayList getFacebookInsightStatsAgeWiseById(string Fbuserid, int days)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action to get all FacebookinsightStats of user from Database by UserId(Guid) and FbUserId(string) and Age wise.
NHibernate.IQuery query = session.CreateSQLQuery("Select * from FacebookInsightStats where FbUserId = :Fbuserid and AgeDiff is not null and CountDate<=DATE_SUB(NOW(),INTERVAL " + days + " DAY) Group BY Week(CountDate)");
query.SetParameter("Fbuserid", Fbuserid);
ArrayList alstFBInsightStats = new ArrayList();
foreach (var item in query.List())
{
alstFBInsightStats.Add(item);
}
return(alstFBInsightStats);
} //End Transaction
} //End session
}
/// <CheckUserId>
/// Get all Business Setting by UserId
/// </summary>
/// <param name="businessSetting">Set Values in a BusinessSetting Class Property and Pass the same Object of BusinessSetting Class.(Domain.BusinessSetting)</param>
/// <returns>List of BusinessSetting Data Objects.</returns>
public List <Domain.Myfashion.Domain.BusinessSetting> CheckUserId(Guid UserId, Guid GroupId, string GroupName)
{
List <Domain.Myfashion.Domain.BusinessSetting> lstBusinessSetting = new List <Domain.Myfashion.Domain.BusinessSetting>();
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to get BusinessSetting By UserId
lstBusinessSetting = session.CreateQuery("From BusinessSetting where UserId = :userid and groupId=:groupId and BusinessName=:GroupName")
.SetParameter("userid", UserId)
.SetParameter("groupId", GroupId)
.SetParameter("GroupName", GroupName)
.List <Domain.Myfashion.Domain.BusinessSetting>()
.ToList <Domain.Myfashion.Domain.BusinessSetting>();
} //End Transaction
} //End session
return(lstBusinessSetting);
}
public YoutubeChannel getYoutubeChannelDetailsById(string youtubeId)
{
YoutubeChannel result = new YoutubeChannel();
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
// proceed action, to get all Facebook Account of User by UserId(Guid) and FbUserId(string).
List <YoutubeChannel> objlstfb = session.CreateQuery("from YoutubeChannel where Googleplususerid = :youtubeId ")
.SetParameter("youtubeId", youtubeId)
.List <YoutubeChannel>().ToList <YoutubeChannel>();
if (objlstfb.Count > 0)
{
result = objlstfb[0];
}
return(result);
} //End Transaction
} //End session
}
public int GetDirrectMessageReceiveCountByProfileIdAndUserId(Guid UserId, string profileids, int Days)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
string[] arrsrt = profileids.Split(',');
DateTime date = DateTime.Now.AddDays(-Days);
List <Domain.Socioboard.Domain.TwitterDirectMessages> results = session.CreateQuery("from TwitterDirectMessages where UserId=:UserId and CreatedDate >= :Days and RecipientId=:RecipientId and Type =:Type")
.SetParameter("UserId", UserId)
.SetParameter("Days", date)
.SetParameter("RecipientId", arrsrt[0]).SetParameter("Type", "twt_directmessages_receive").List <Domain.Socioboard.Domain.TwitterDirectMessages>().ToList();
return(Int16.Parse(results.Count.ToString()));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}// End session
}
/// <getAllFacebookPagesOfUser>
/// Get all Facebook Account of User by UserId(Guid) and Type.
/// </summary>
/// <param name="UserId">UserId of User(Guid)</param>
/// <returns>Retutn all FacebookAccount in form of ArrayList</returns>
public ArrayList getAllFacebookPagesOfUser(Guid UserId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to Get all FacebookAccount by UserId(Guid) and Type.
NHibernate.IQuery query = session.CreateQuery("from FacebookAccount where UserId = :userid And Type=:page");
query.SetParameter("userid", UserId);
query.SetParameter("page", "page");
ArrayList alstFBAccounts = new ArrayList();
foreach (var item in query.Enumerable())
{
alstFBAccounts.Add(item);
}
return(alstFBAccounts);
} //End Transaction
} //End session
}
public int DeleteFacebookStatsByUserid(Guid userid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("delete from FacebookStats where UserId = :userid")
.SetParameter("userid", userid);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
public bool IsShareathonExist(Guid Userid, Guid Facebookaccountid, string Facebookpageid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
bool ret = session.Query <Shareathon>().Any(t => t.Userid == Userid && t.Facebookaccountid == Facebookaccountid && t.Facebookpageid.Contains(Facebookpageid));
//List<Shareathon> objlstfb = session.CreateQuery("from Shareathon where UserId = :UserId and FacebookAccountId =: FacebookAccountId and FacebookPageId =: Facebookpageid and IsHidden = false ")
// .SetParameter("UserId", Userid)
// .SetParameter("FacebookAccountId", Facebookaccountid)
// .SetParameter("Facebookpageid", Facebookpageid)
// .List<Shareathon>().ToList<Shareathon>();
//if (objlstfb.Count() > 0)
//{
// return true;
//}
//else
//{
// return false;
//}
return(ret);
}//End session
}
/// <UpdateStatus>
/// Update Status of Rss reader.
/// </summary>
/// <param name="Id">Id of rss reader.(Guid)</param>
public void UpdateStatus(Guid Id)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get rss reader by id.
int i = session.CreateQuery("update RssReader set Status= 1 where Id = :id")
.SetParameter("id", Id)
.ExecuteUpdate();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
} //End Transaction
} //End Session
}
/// <GetBlogId>
/// Get all blog Data from blog post id.
/// </summary>
/// <param name="objBlog_Posts">Set the blog post id in a blog posts Class Property and Pass the same Object of blog posts Class.(Domain.Blog_Posts)</param>
/// <returns>Its is returns Icollection of blog post property class objects.(ICollection<Blog_Posts>)</returns>
public ICollection <Blog_Posts> GetBlogId(Blog_Posts objBlog_Posts)
{
ICollection <Blog_Posts> iCol = null;
// ICollection<Blog_Comments> iColById = null;
try
{
//Creates a database connection and opens up a session.
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Proceed action, to get all blog data by blog id.
iCol = session.CreateCriteria(typeof(Blog_Posts)).List <Blog_Posts>()
.Where <Blog_Posts>(x => x.Id == objBlog_Posts.Id).ToList <Blog_Posts>();
// iColById = iCol.Where<Blog_Comments>(x => x.CommentPostId == objBlog_Posts.Id).ToList<Blog_Comments>();
}//End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(iCol);
}
public List <Domain.Myfashion.Domain.InboxMessages> getInboxMessageByGroup(Guid UserId, string profileids, string noOfDataToSkip, string noOfResultsFromTop)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
string[] arrsrt = profileids.Split(',');
List <Domain.Myfashion.Domain.InboxMessages> results = session.Query <Domain.Myfashion.Domain.InboxMessages>().Where(U => U.UserId.Equals(UserId) && arrsrt.Contains(U.ProfileId)).OrderByDescending(x => x.CreatedTime).Skip(Convert.ToInt32(noOfDataToSkip)).Take(Convert.ToInt32(noOfResultsFromTop)).ToList <Domain.Myfashion.Domain.InboxMessages>();
return(results);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(new List <Domain.Myfashion.Domain.InboxMessages>());
}
} //End using transaction
} //End using session
}
public bool IsPostExist(string Facebookaccountid, string Facebookpageid, string PostId)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
bool ret = session.Query <SharethonPost>().Any(t => t.Facebookaccountid == Facebookaccountid && t.Facebookpageid == Facebookpageid && t.PostId == PostId);
return(ret);
//List<SharethonPost> objlstfb = session.CreateQuery("from SharethonPost where Facebookpageid = :Facebookpageid and Facebookaccountid =: Facebookaccountid and PostId =: PostId ")
// .SetParameter("Facebookaccountid", Facebookaccountid)
// .SetParameter("Facebookpageid", Facebookpageid)
// .SetParameter("PostId", PostId)
// .List<SharethonPost>().ToList<SharethonPost>();
//if (objlstfb.Count() > 0)
//{
// return true;
//}
//else
//{
// return false;
//}
}//End session
}
public int DeleteUser(Guid id)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Delete from User where Id = :userid")
.SetParameter("userid", id)
.ExecuteUpdate();
transaction.Commit();
return(i);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}
}
/// <Add>
/// Add a new admin in DataBase.
/// </summary>
/// <param name="user">Set Values in a Admin Class Property and Pass the Object of Admin Class (Domain.Socioboard.Domain.Admin).</param>
public void Add(Domain.Socioboard.Domain.TwitterEngagement user)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start and open Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action to save data.
try
{
session.Save(user);
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.StackTrace);
}
} //End Using trasaction
} //End Using session
}
public ContatoEntitis Get(int id)
{
try
{
ContatoEntitis retorno = new ContatoEntitis();
using (NHibernate.ISessionFactory sessionFactory = SessionFactoryBuilder.BuildSessionFactory())
{
using (NHibernate.ISession session = sessionFactory.OpenSession())
{
retorno = session.Get <ContatoEntitis>(id);
session.Flush();
}
}
return(retorno);
}
catch (Exception exs)
{
throw;
}
}
} //End session
public int deletepageshraethonpostByFacebookId(string facebookaccountId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
List <Guid> lstids = session.Query <Domain.Socioboard.Domain.SharethonPost>().Where(t => t.Facebookaccountid == facebookaccountId).Select(t => t.Id).ToList();
//After Session creation, start Transaction.
if (lstids.Count > 0)
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int isUpdated = session.CreateQuery("Delete from SharethonPost where Id in (:ids)")
.SetParameterList("ids", lstids)
.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
}
}//End Transaction
else
{
return(0);
}
}
catch
{
return(0);
}
}
}
/// if obj.IsNew, returns any database generated PK, or else the already-assigned PK
private object SaveOrUpdateThroughORM(NHibernate.ISession session, IDataObject obj, bool isMainEntity = false)
{
object newPK = null;
var toSave = obj.ToORMEntity();
if (obj.IsNew)
{
var pk = session.Save(toSave);
if (isMainEntity)
{
newPK = pk;
}
}
else
{
session.Update(toSave);
}
return(newPK);
}
public List <Domain.Socioboard.Domain.WordpressFeeds> GetAllSiteFeedBySiteId(Guid UserId, string SiteId)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//Begin session trasaction and opens up.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
List <Domain.Socioboard.Domain.WordpressFeeds> query = session.CreateQuery("from WordpressFeeds where UserId = :userid and SiteId = : SiteId")
.SetParameter("userid", UserId)
.SetParameter("SiteId", SiteId)
.List <Domain.Socioboard.Domain.WordpressFeeds>().ToList <Domain.Socioboard.Domain.WordpressFeeds>();
return(query);
}
catch (Exception ex)
{
return(new List <Domain.Socioboard.Domain.WordpressFeeds>());
}
}
}
}
public List <Domain.Socioboard.Domain.WordpressSites> GetAllSitesFromWPUserId(Guid UserId, string WPUserId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
List <Domain.Socioboard.Domain.WordpressSites> lstmsg = session.CreateQuery("from WordpressSites where UserId = :userid and WPUserId = :WPUserId")
.SetParameter("userid", UserId)
.SetParameter("WPUserId", WPUserId).List <Domain.Socioboard.Domain.WordpressSites>().ToList <Domain.Socioboard.Domain.WordpressSites>();
return(lstmsg);
}
catch (Exception ex)
{
return(new List <Domain.Socioboard.Domain.WordpressSites>());
}
}
}
}
// Added by Antima[5/1/2015]
public int UpdateEmailIdbyGroupId(Guid UserId, Guid GroupId, string NewEmailId)
{
int i = 0;
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update Team set EmailId=:NewEmailId where UserId = :UserId and GroupId = :GroupId")
.SetParameter("UserId", UserId)
.SetParameter("GroupId", GroupId)
.SetParameter("NewEmailId", NewEmailId)
.ExecuteUpdate();
transaction.Commit();
}
catch { }
}
}
return(i);
}
public void Insert(FanPageStatus acc)
{
try
{
lock (lockerInsert)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(acc);
transaction.Commit();
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
}
/// <getGooglePlusAccountDetailsById>
/// Get the details of Google account By Id.
/// </summary>
/// <param name="gpuserid">Google Plus user id(string).</param>
/// <param name="userId">User id(Guid)</param>
/// <returns>Return the object of group where we get all values from object.(Domain.GooglePlusAccount)</returns>
public Domain.Socioboard.Domain.GooglePlusAccount getGooglePlusAccountDetailsById(string gpuserid, Guid userId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to get Details of account by user id and Google plus id.
NHibernate.IQuery query = session.CreateQuery("from GooglePlusAccount where GpUserId = :gpuserid and UserId=:userId");
query.SetParameter("gpuserid", gpuserid);
query.SetParameter("userId", userId);
ArrayList alstFBAccounts = new ArrayList();
foreach (var item in query.Enumerable())
{
alstFBAccounts.Add(item);
}
Domain.Socioboard.Domain.GooglePlusAccount result = (Domain.Socioboard.Domain.GooglePlusAccount)query.UniqueResult();
return(result);
} //End Transaction
} //End Session
}
public Domain.Socioboard.Domain.YoutubeAccount getYoutubeAccountDetailsById(string youtubeId, Guid userid)
{
Domain.Socioboard.Domain.YoutubeAccount result = new Domain.Socioboard.Domain.YoutubeAccount();
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
// proceed action, to get all Facebook Account of User by UserId(Guid) and FbUserId(string).
List <Domain.Socioboard.Domain.YoutubeAccount> objlstfb = session.CreateQuery("from YoutubeAccount where YtUserId = :Fbuserid and UserId=:userid")
.SetParameter("Fbuserid", youtubeId)
.SetParameter("userid", userid)
.List <Domain.Socioboard.Domain.YoutubeAccount>().ToList <Domain.Socioboard.Domain.YoutubeAccount>();
if (objlstfb.Count > 0)
{
result = objlstfb[0];
}
return(result);
} //End Transaction
} //End session
}
public SequenceCoverageForm(NHibernate.ISession session, DataModel.Protein protein, DataFilter viewFilter)
{
StartPosition = FormStartPosition.CenterParent;
ShowIcon = false;
WindowState = FormWindowState.Maximized;
Text = protein.Accession;
ResizeRedraw = true;
DoubleBuffered = true;
BackColor = SystemColors.Window;
control = new SequenceCoverageControl(session, protein, viewFilter)
{
Dock = DockStyle.Fill,
BackColor = this.BackColor
};
control.SequenceCoverageFilter += (s, e) => OnSequenceCoverageFilter(e);
Controls.Add(control);
}
public User GetUserInfo(string EmailId, string Password)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email and u.Password= :password");
query.SetParameter("email", EmailId);
query.SetParameter("password", Password);
User result = (User)query.UniqueResult();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
public static void Update(UserActivation user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
int i = session.CreateQuery("Update UserActivation set ActivationStatus =:ActivationStatus where UserId = :userid and ID=:id")
.SetParameter("id", user.Id)
.SetParameter("userid", user.UserId)
.SetParameter("ActivationStatus", user.ActivationStatus)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public List <string> getCompanyNames()
{
List <string> companyNames = new List <string>();
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to Get all FacebookAccount.
NHibernate.IQuery query = session.CreateQuery("from CompanyProfiles");
foreach (Domain.Myfashion.Domain.CompanyProfiles Profile in query.Enumerable())
{
companyNames.Add(Profile.Companyname);
}
} //End Transaction
} //End session
return(companyNames);
}
public List <Domain.Myfashion.Domain.NewsLetter> getAllNewsLetters()
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
List <Domain.Myfashion.Domain.NewsLetter> alst = session.CreateQuery("from NewsLetter where SendDate< now() and SendStatus=0")
.List <Domain.Myfashion.Domain.NewsLetter>()
.ToList <Domain.Myfashion.Domain.NewsLetter>();
return(alst);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
public bool checkdailymotionpostExists(string Url)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
bool exist = session.Query <Domain.Socioboard.Domain.dailymotionpost>()
.Any(x => x.Url.Contains(Url));
return(exist);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End session
}
/// <Add>
/// Add logging details of user
/// </Add>
/// <param name="loginLogs">Set Values in a LoginLogs Class Property and Pass the Object of LoginLogs Class (SocioBoard.Domain.LoginLogs).</param>
public void Add(LoginLogs loginLogs)
{
try
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to save details.
session.Save(loginLogs);
transaction.Commit();
} //End Transaction
} //End Session
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
}
private static void LoadCarrierMovementData(ISession session)
{
const string voyageSql = "insert into Voyage (id, voyage_number) values (?, ?)";
var voyageArgs = new[]
{
new object[] {1, "0101"},
new object[] {2, "0202"},
new object[] {3, "0303"}
};
ExecuteUpdate(session, voyageSql, voyageArgs);
const string carrierMovementSql =
"insert into CarrierMovement (id, voyage_id, departure_location_id, arrival_location_id, departure_time, arrival_time, cm_index) " +
"values (?,?,?,?,?,?,?)";
var carrierMovementArgs = new[]
{
// SESTO - FIHEL - DEHAM - CNHKG - JPTOK - AUMEL (voyage 0101)
new object[] {1, 1, 1, 5, Ts(1), Ts(2), 0},
new object[] {2, 1, 5, 6, Ts(1), Ts(2), 1},
new object[] {3, 1, 6, 3, Ts(1), Ts(2), 2},
new object[] {4, 1, 3, 4, Ts(1), Ts(2), 3},
new object[] {5, 1, 4, 2, Ts(1), Ts(2), 4},
// AUMEL - USCHI - DEHAM - SESTO - FIHEL (voyage 0202)
new object[] {7, 2, 2, 7, Ts(1), Ts(2), 0},
new object[] {8, 2, 7, 6, Ts(1), Ts(2), 1},
new object[] {9, 2, 6, 1, Ts(1), Ts(2), 2},
new object[] {6, 2, 1, 5, Ts(1), Ts(2), 3},
// CNHKG - AUMEL - FIHEL - DEHAM - SESTO - USCHI - JPTKO (voyage 0303)
new object[] {10, 3, 3, 2, Ts(1), Ts(2), 0},
new object[] {11, 3, 2, 5, Ts(1), Ts(2), 1},
new object[] {12, 3, 6, 1, Ts(1), Ts(2), 2},
new object[] {13, 3, 1, 7, Ts(1), Ts(2), 3},
new object[] {14, 3, 7, 4, Ts(1), Ts(2), 4}
};
ExecuteUpdate(session, carrierMovementSql, carrierMovementArgs);
}
public void TestInitialize ()
{
var sessionFactory = SessionFactoryFactory.CreateSessionFactory("testQueryReader.idpDB", false, false);
session = sessionFactory.OpenSession();
}
/// <summary>
/// Gets an open session if it exists, or creates a new one with the specified interceptor.
/// </summary>
/// <param name="interceptor">The interceptor to associate with the session</param>
/// <returns>NHibernate session</returns>
public NHibernate.ISession GetOpenSession(NHibernate.IInterceptor interceptor)
{
NHibernate.ISession session = this.SessionInThread;
if (session == null)
{
if (interceptor != null)
{
session = this.sessionFactory.OpenSession(interceptor);
}
else
{
session = this.sessionFactory.OpenSession();
}
this.SessionInThread = session;
}
return session;
}
private static void LoadLocationData(ISession session)
{
const string locationSql = "insert into Location (id, unlocode, name) " +
"values (?, ?, ?)";
var locationArgs = new[]
{
new object[] {1, "SESTO", "Stockholm"},
new object[] {2, "AUMEL", "Melbourne"},
new object[] {3, "CNHKG", "Hongkong"},
new object[] {4, "JPTOK", "Tokyo"},
new object[] {5, "FIHEL", "Helsinki"},
new object[] {6, "DEHAM", "Hamburg"},
new object[] {7, "USCHI", "Chicago"}
};
ExecuteUpdate(session, locationSql, locationArgs);
}
//TODO:atrosin Revise where and how is used the method
public static void LoadHibernateData(ISession session, HandlingEventFactory handlingEventFactory,
IHandlingEventRepository handlingEventRepository)
{
Console.WriteLine("*** Loading Hibernate data ***");
foreach (Location location in SampleLocations.GetAll())
{
session.Save(location);
}
foreach (Voyage voyage in SampleVoyages.GetAll())
{
session.Save(voyage);
}
/*session.Save(SampleVoyages.HONGKONG_TO_NEW_YORK);
session.Save(SampleVoyages.NEW_YORK_TO_DALLAS);
session.Save(SampleVoyages.DALLAS_TO_HELSINKI);
session.Save(SampleVoyages.HELSINKI_TO_HONGKONG);
session.Save(SampleVoyages.DALLAS_TO_HELSINKI_ALT);*/
var routeSpecification = new RouteSpecification(SampleLocations.HONGKONG,
SampleLocations.HELSINKI,
DateUtil.ToDate("2009-03-15"));
var trackingId = new TrackingId("ABC123");
var abc123 = new Cargo(trackingId, routeSpecification);
var itinerary = new Itinerary(
new List<Leg>
{
new Leg(SampleVoyages.HONGKONG_TO_NEW_YORK, SampleLocations.HONGKONG, SampleLocations.NEWYORK,
DateUtil.ToDate("2009-03-02"), DateUtil.ToDate("2009-03-05")),
new Leg(SampleVoyages.NEW_YORK_TO_DALLAS, SampleLocations.NEWYORK, SampleLocations.DALLAS,
DateUtil.ToDate("2009-03-06"), DateUtil.ToDate("2009-03-08")),
new Leg(SampleVoyages.DALLAS_TO_HELSINKI, SampleLocations.DALLAS, SampleLocations.HELSINKI,
DateUtil.ToDate("2009-03-09"), DateUtil.ToDate("2009-03-12"))
});
abc123.AssignToRoute(itinerary);
session.Save(abc123);
HandlingEvent event1 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-01"), trackingId, null, SampleLocations.HONGKONG.UnLocode,
HandlingType.RECEIVE
);
session.Save(event1);
HandlingEvent event2 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-02"), trackingId,
SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.HONGKONG.UnLocode,
HandlingType.LOAD
);
session.Save(event2);
HandlingEvent event3 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-05"), trackingId,
SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.NEWYORK.UnLocode,
HandlingType.UNLOAD
);
session.Save(event3);
HandlingHistory handlingHistory = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId);
abc123.DeriveDeliveryProgress(handlingHistory);
session.Update(abc123);
// Cargo JKL567
var routeSpecification1 = new RouteSpecification(SampleLocations.HANGZOU,
SampleLocations.STOCKHOLM,
DateUtil.ToDate("2009-03-18"));
var trackingId1 = new TrackingId("JKL567");
var jkl567 = new Cargo(trackingId1, routeSpecification1);
var itinerary1 = new Itinerary(new List<Leg>
{
new Leg(SampleVoyages.HONGKONG_TO_NEW_YORK,
SampleLocations.HANGZOU, SampleLocations.NEWYORK,
DateUtil.ToDate("2009-03-03"),
DateUtil.ToDate("2009-03-05")),
new Leg(SampleVoyages.NEW_YORK_TO_DALLAS,
SampleLocations.NEWYORK, SampleLocations.DALLAS,
DateUtil.ToDate("2009-03-06"),
DateUtil.ToDate("2009-03-08")),
new Leg(SampleVoyages.DALLAS_TO_HELSINKI,
SampleLocations.DALLAS, SampleLocations.STOCKHOLM,
DateUtil.ToDate("2009-03-09"),
DateUtil.ToDate("2009-03-11"))
});
jkl567.AssignToRoute(itinerary1);
session.Save(jkl567);
HandlingEvent event21 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-01"), trackingId1, null, SampleLocations.HANGZOU.UnLocode,
HandlingType.RECEIVE);
session.Save(event21);
HandlingEvent event22 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-03"), trackingId1,
SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.HANGZOU.UnLocode,
HandlingType.LOAD
);
session.Save(event22);
HandlingEvent event23 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-05"), trackingId1,
SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.NEWYORK.UnLocode,
HandlingType.UNLOAD
);
session.Save(event23);
HandlingEvent event24 = handlingEventFactory.CreateHandlingEvent(
new DateTime(), DateUtil.ToDate("2009-03-06"), trackingId1,
SampleVoyages.HONGKONG_TO_NEW_YORK.VoyageNumber, SampleLocations.NEWYORK.UnLocode,
HandlingType.LOAD
);
session.Save(event24);
HandlingHistory handlingHistory1 = handlingEventRepository.LookupHandlingHistoryOfCargo(trackingId1);
jkl567.DeriveDeliveryProgress(handlingHistory1);
session.Update(jkl567);
}
public UnitOfWorkImpl(NHibernate.ISession session)
{
session.FlushMode = NHibernate.FlushMode.Commit;
this.session = session;
}
private static void ExecuteUpdate(ISession session, string sql, object[][] dataTable)
{
for (int i = 0; i < dataTable.GetLength(0); i++)
{
IQuery query = session.CreateSQLQuery(sql);
for (int j = 0; j < dataTable[i].GetLength(0); j++)
{
object objValue = dataTable[i][j];
if (objValue == null)
{
//Workaround: cant set NULL value for int type
query.SetBinary(j, null);
}
else
{
query.SetParameter(j, objValue);
}
}
query.ExecuteUpdate();
}
}
////use basicFilter to process all source files and PSMs in session
public void SetData(NHibernate.ISession session, DataFilter basicFilter)
{
this.session = session;
basicDataFilter = basicFilter;
ResetForm();
}
public void Setup()
{
DatabaseSetUp();
session = sessionManager.GetSession();
provider = new PreferencesProvider(session);
}
public void ClearSession()
{
ClearData();
if (session != null && session.IsOpen)
{
dataGridView.Rows.Clear();
session.Close();
session.Dispose();
session = null;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="StationsService"/> class.
/// </summary>
public StationsService()
{
this.log = LogManager.GetLogger(this.GetType());
this.databaseSession = NHibernateHelper.OpenSession();
this.logic = new StationsLogic(this.databaseSession);
}
public EmbedderForm (NHibernate.ISession session)
{
this.session = session.SessionFactory.OpenSession();
InitializeComponent();
}
private static void LoadItineraryData(ISession session)
{
const string legSql =
"insert into Leg (id, cargo_id, voyage_id, load_location_id, unload_location_id, load_time, unload_time, leg_index) " +
"values (?,?,?,?,?,?,?,?)";
var legArgs = new[]
{
// Cargo 5: Hongkong - Melbourne - Stockholm - Helsinki
new object[] {1, 5, 1, 3, 2, Ts(1), Ts(2), 0},
new object[] {2, 5, 1, 2, 1, Ts(3), Ts(4), 1},
new object[] {3, 5, 1, 1, 5, Ts(4), Ts(5), 2},
// Cargo 6: Hamburg - Stockholm - Chicago - Tokyo
new object[] {4, 6, 2, 6, 1, Ts(1), Ts(2), 0},
new object[] {5, 6, 2, 1, 7, Ts(3), Ts(4), 1},
new object[] {6, 6, 2, 7, 4, Ts(5), Ts(6), 2}
};
ExecuteUpdate(session, legSql, legArgs);
}
public void Init()
{
session = DataService.GetSession();
repo = new Repository<LonglineCatch>(session);
}
public void SetData(NHibernate.ISession session, DataModel.Protein protein, DataFilter viewFilter)
{
if (session == null)
return;
this.session = session.SessionFactory.OpenSession();
this.viewFilter = viewFilter;
var workerThread = new BackgroundWorker()
{
WorkerReportsProgress = true,
WorkerSupportsCancellation = true
};
workerThread.DoWork += setData;
if (protein == Protein)
workerThread.RunWorkerCompleted += refreshFilter;
else
workerThread.RunWorkerCompleted += renderData;
workerThread.RunWorkerAsync(protein);
}
/// <summary>
/// Initializes a new instance of the <see cref="CurrentUserService"/> class.
/// </summary>
public CurrentUserService()
{
this.databaseSession = NHibernateHelper.OpenSession();
this.rightsHelper = new RightsHelper(new Repository<UserRolesInfo>(this.databaseSession), new Repository<RoleRightsInfo>(this.databaseSession));
}
private static void LoadCargoData(ISession session)
{
const string cargoSql =
"insert into Cargo (id, tracking_id, origin_id, spec_origin_id, spec_destination_id, spec_arrival_deadline, transport_status, current_voyage_id, last_known_location_id, is_misdirected, routing_status, calculated_at, unloaded_at_dest) " +
"values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
var cargoArgs = new[]
{
new object[]
{
1, "XYZ", 1, 1, 2, Ts(10), "IN_PORT", null, 1, false, "ROUTED", Ts(100),
false
},
new object[]
{
2, "ABC", 1, 1, 5, Ts(20), "IN_PORT", null, 1, false, "ROUTED", Ts(100),
false
},
new object[]
{
3, "ZYX", 2, 2, 1, Ts(30), "IN_PORT", null, 1, false, "NOT_ROUTED", Ts(100),
false
},
new object[]
{
4, "CBA", 5, 5, 1, Ts(40), "IN_PORT", null, 1, false, "MISROUTED", Ts(100),
false
},
new object[]
{
5, "FGH", 1, 3, 5, Ts(50), "IN_PORT", null, 1, false, "ROUTED", Ts(100),
false
}, // Cargo origin differs from spec origin
new object[]
{
6, "JKL", 6, 6, 4, Ts(60), "IN_PORT", null, 1, true, "ROUTED", Ts(100),
false
}
};
ExecuteUpdate(session, cargoSql, cargoArgs);
}
public void SetData (NHibernate.ISession session, DataFilter dataFilter)
{
if (session == null)
return;
if (StartingSetData != null)
StartingSetData(this, EventArgs.Empty);
this.session = session;
viewFilter = dataFilter;
this.dataFilter = new DataFilter(dataFilter) { Analysis = null };
ClearData();
Text = TabText = "Loading analysis view...";
var workerThread = new BackgroundWorker()
{
WorkerReportsProgress = true,
WorkerSupportsCancellation = true
};
workerThread.DoWork += new DoWorkEventHandler(setData);
workerThread.RunWorkerCompleted += new RunWorkerCompletedEventHandler(renderData);
workerThread.RunWorkerAsync();
}
public void Setup()
{
DatabaseSetUp();
session = sessionManager.GetSession();
provider = new CourseProvider(session);
}
// dependency injection
public AuthenticationManager(HttpSessionStateBase session,NHibernate.ISession nhibernateSession)
{
_session = session;
_nhibernateSession = nhibernateSession;
}
/// <summary>
/// Informs the layout manager how to access the database in current use
/// </summary>
/// <param name="newSession"></param>
public void SetSession(NHibernate.ISession newSession)
{
_session = newSession;
}
public void ClearSession ()
{
ClearData();
if (session != null && session.IsOpen)
{
session.Dispose();
session = null;
}
}
/// <summary>
/// Initializes a new instance of the <see cref="BoardController" /> class.
/// </summary>
/// <param name="session">The session.</param>
/// <param name="messageService">The message service.</param>
public BoardController(ISession session, IMessageService messageService)
{
_session = session;
_messageService = messageService;
}
/// <summary>
/// Initializes a new instance of the <see cref="CompetitionsService"/> class.
/// </summary>
public CompetitionsService()
{
this.databaseSession = NHibernateHelper.OpenSession();
this.logic = new CompetitionsLogic(this.databaseSession);
}
//private static Course BuildInvalidCourse()
//{
// //course name is assigned a string with more than 50 chars length
// return new Course() { CourseName = A60_CHAR_STRING };
//}
private void ResetSessionForProvider()
{
session = sessionManager.GetSession();
provider.Session = session;
}
