private LayoutProperty saveNewLayout(string layoutName, bool saveColumns, bool isDatabase, IDictionary <string, FormProperty> formProperties)
{
var tempLayout = new LayoutProperty
{
Name = layoutName,
PaneLocations = getPaneLocationXML(),
HasCustomColumnSettings = saveColumns,
};
tempLayout.FormProperties = formProperties;
if (isDatabase)
{
lock (_session)
{
_session.Save(tempLayout);
_session.Flush();
}
}
else
{
_userLayoutList.Add(tempLayout);
SaveUserLayoutList();
}
return(tempLayout);
}
public async Task <ResponseApi> Init()
{
AdminInfo admin = base.Test ? null : GetAdminInfo();
using NHibernate.ISession session = HttpContext.RequestServices.GetService <Utility.Nhibernate.Infrastructure.AppSessionFactory>().OpenSession();
NHibernate.ITransaction transaction = session.BeginTransaction();
foreach (var item in session.Query <AdminRoleInfo>().Select(it => it.Id))
{
//session.Query<MenuInfo>().Where(it => it.Menu.Role.Id != item && it.Id != it.Menu.Menu.Id &&
// it.Href != null).InsertInto(it => new UserMenuInfo()
// {
// Admin = admin,
// Menu = new MenuInfo() { Id = it.Id },
// Role = new AdminRoleInfo() { Id = item }
// });
foreach (var menu in session.Query <MenuInfo>().Where(it => it.Href != null).Select(it => it.Id))
{
if (session.Query <UserMenuInfo>().Where(it => it.Menu.Id == menu && it.Role.Id == item).ToFutureValue(it => it.Count()).Value == 0)
{
session.Save(new UserMenuInfo()
{
Admin = admin,
Menu = new MenuInfo()
{
Id = menu
},
Role = new AdminRoleInfo()
{
Id = item
}
});
}
}
}
foreach (var item in session.Query <UserLevelInfo>().Select(it => it.Id))
{
foreach (var menu in session.Query <MenuInfo>().Where(it => it.Href != null).Select(it => it.Id))
{
if (session.Query <UserMenuInfo>().Where(it => it.Menu.Id == menu && it.Level.Id == item).ToFutureValue(it => it.Count()).Value == 0)
{
session.Save(new UserMenuInfo()
{
Admin = admin,
Menu = new MenuInfo()
{
Id = menu
},
Level = new UserLevelInfo()
{
Id = item
}
});
}
}
}
transaction.Commit();
return(await Task.FromResult(ResponseApi.Create(GetLanguage(), Code.OperatorSuccess)));
}
public void Post([FromBody] Foo foo)
{
using (var transaction = _session.BeginTransaction())
{
_session.Save(foo);
transaction.Commit();
}
}
private void BatchSaveInTransaction(IList <AppAuditLog> logs)
{
logger.LogInformation($"Batch save {logs.Count} audit logs to db ...");
session.SetBatchSize(logs.Count);
using (var tx = session.BeginTransaction()) {
try {
session.SetBatchSize(logs.Count);
foreach (var log in logs)
{
session.Save(log);
}
session.Flush();
session.Clear();
tx.Commit();
}
catch (Exception ex) {
tx?.Rollback();
logger.LogError(ex, "Can not save audit logs with transactions.");
foreach (var log in logs)
{
logger.LogError(log.ToJson());
}
}
}
}
public void RunWorker(BackgroundWorker worker, DoWorkEventArgs args)
{
var getProgress = args.Argument as Func <ProgressState>
?? new Func <ProgressState>(() => ProgressState.Empty);
CurrentProgress = getProgress() ?? ProgressState.Empty;
ImportStarted(this, EventArgs.Empty);
var type = Type.GetType(DataContextObject.SelectedDataType.Target.ClrType);
var sessionFactory = DataContextObject.ShellContext.SessionFactoryHolder.GetSessionFactory();
CurrentProgress = new ProgressState(0, DataContextObject.TargetsToImport.Count);
using (NHibernate.ISession session = sessionFactory.OpenSession())
{
var current = 0;
var total = DataContextObject.TargetsToImport.Count;
int batchSize = Settings.Default.BatchSize;
using (var tx = session.BeginTransaction())
{
while (current < total && !args.Cancel && !Cancelled)
{
if (worker.CancellationPending)
{
args.Cancel = true;
}
else
{
var target = DataContextObject.TargetsToImport[current];
(target as ContentPartRecord).ContentItemRecord = DataContextObject.CurrentContentItem;
try
{
session.Save(DataContextObject.TargetsToImport[current]);
}
catch (Exception ex)
{
GuardError(current, ex);
}
finally
{
if (current % batchSize == 0)
{ //20, same as the ADO batch size
session.Flush();
session.Clear();
}
current++;
var progress = new ProgressState(current, total);
worker.ReportProgress((int)Math.Floor(progress.Ratio * 100d), progress);
if (current % 1000 == 0)
{
Application.Current.DoEvents();
}
}
}
}
session.Flush();
session.Clear();
tx.Commit();
}
session.Close();
}
}
public static Recapito Recapito_Create(
String Indirizzo,
String Localita,
String Provincia
)
{
try
{
Recapito aRecapito =
new Recapito();
NHibernate.ISession aNHibernateSession = NHibernateHelper.GetOrCreateCurrentSession();
aRecapito.Indirizzo = Indirizzo;
aRecapito.Localita = Localita;
aRecapito.Provincia = Provincia;
aNHibernateSession.Save(aRecapito);
aNHibernateSession.Flush();
return(aRecapito);
}
catch (Exception)
{
return(null);
}
}
public static SegnalazionePreliminareDanno SegnalazionePreliminareDanno_Create(
Recapito Recapito,
OggettoSegnalazionePreliminareDanno Oggetto
)
{
try
{
SegnalazionePreliminareDanno aSegnalazionePreliminareDanno =
new SegnalazionePreliminareDanno();
NHibernate.ISession aNHibernateSession = NHibernateHelper.GetOrCreateCurrentSession();
aSegnalazionePreliminareDanno.Recapito = Recapito;
aSegnalazionePreliminareDanno.Oggetto = Oggetto;
aSegnalazionePreliminareDanno.DataCreazione = DateTime.Now;
aSegnalazionePreliminareDanno.Definitivo = false;
aNHibernateSession.Save(aSegnalazionePreliminareDanno);
aNHibernateSession.Flush();
return(aSegnalazionePreliminareDanno);
}
catch (Exception)
{
return(null);
}
}
public string SaveFacebookId(string userId, string password)
{
Domain.Socioboard.Domain.FacebookLoginId _FacebookLoginId = new FacebookLoginId();
_FacebookLoginId.UserId = userId;
_FacebookLoginId.Password = password;
_FacebookLoginId.UpdatedAt = DateTime.UtcNow;
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
if (session.Query <FacebookLoginId>().Any(t => t.UserId == userId))
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
int i = session.CreateQuery("Update FacebookLoginId set Password =: Password, UpdatedAt = : UpdatedAt where UserId =: UserId")
.SetParameter("UserId", _FacebookLoginId.UserId)
.SetParameter("Password", _FacebookLoginId.Password)
.SetParameter("UpdatedAt", DateTime.UtcNow)
.ExecuteUpdate();
transaction.Commit();
}
}
else
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(_FacebookLoginId);
transaction.Commit();
}
}
}
return("success");
}
//public facebookpageinfo getfbpage()
//{
// facebookpageinfo fbpginfo = null;
// if (this.facebookpageinfoID == null)
// {
// return fbpginfo;
// }
// else
// {
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //Begin session trasaction and opens up.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// List<facebookpageinfo> alst = session.CreateQuery("from facebookpageinfo where Id = :fbpgid")
// .SetParameter("fbpgid", facebookpageinfoID)
// .List<facebookpageinfo>()
// .ToList<facebookpageinfo>();
// fbpginfo = alst[0];
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// //return 0;
// }
// }//End Transaction
// }//End Session
// }
// return fbpginfo;
//}
//public googleplusinfo getgpulsinfo()
//{
// googleplusinfo gpluspginfo = null;
// if (this.googleplusinfoID== null)
// {
// return gpluspginfo;
// }
// else
// {
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //Begin session trasaction and opens up.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// List<googleplusinfo> alst = session.CreateQuery("from googleplusinfo where Id = :gpluspgid")
// .SetParameter("gpluspgid", this.googleplusinfoID)
// .List<googleplusinfo>()
// .ToList<googleplusinfo>();
// gpluspginfo = alst[0];
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// //return 0;
// }
// }//End Transaction
// }//End Session
// }
// return gpluspginfo;
//}
//public instagrampage getinstagraminfo()
//{
// instagrampage instpg = null;
// if (this.instagrampageID == null)
// {
// return instpg;
// }
// else
// {
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //Begin session trasaction and opens up.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// List<instagrampage> alst = session.CreateQuery("from instagrampage where Id = :instpgid")
// .SetParameter("instpg", this.instagrampageID)
// .List<instagrampage>()
// .ToList<instagrampage>();
// instpg = alst[0];
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// //return 0;
// }
// }//End Transaction
// }//End Session
// }
// return instpg;
//}
//public linkedinpage getlinkedinpageinfo()
//{
// linkedinpage linkpg = null;
// if (this.linkedinpageID == null)
// {
// return linkpg;
// }
// else
// {
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //Begin session trasaction and opens up.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// List<linkedinpage> alst = session.CreateQuery("from linkedinpage where Id = :linkpgid")
// .SetParameter("linkpgid", this.linkedinpageID)
// .List<linkedinpage>()
// .ToList<linkedinpage>();
// linkpg = alst[0];
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// //return 0;
// }
// }//End Transaction
// }//End Session
// }
// return linkpg;
//}
//public twitterpage gettwitterpageinfo()
//{
// twitterpage twitterpg = null;
// if (this.twitterpageID == null)
// {
// return twitterpg;
// }
// else
// {
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //Begin session trasaction and opens up.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// List<twitterpage> alst = session.CreateQuery("from twitterpage where Id = :twitterpgid")
// .SetParameter("twitterpgid", this.twitterpageID)
// .List<twitterpage>()
// .ToList<twitterpage>();
// twitterpg = alst[0];
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// //return 0;
// }
// }//End Transaction
// }//End Session
// }
// return twitterpg;
//}
//public youtubepage getyoutubepageinfo()
//{
// youtubepage ytpg = null;
// if (this.twitterpageID == null)
// {
// return ytpg;
// }
// else
// {
// using (NHibernate.ISession session = SessionFactory.GetNewSession())
// {
// //Begin session trasaction and opens up.
// using (NHibernate.ITransaction transaction = session.BeginTransaction())
// {
// try
// {
// List<youtubepage> alst = session.CreateQuery("from youtubepage where Id = :ytpgid")
// .SetParameter("ytpg", this.twitterpageID)
// .List<youtubepage>()
// .ToList<youtubepage>();
// ytpg = alst[0];
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.StackTrace);
// //return 0;
// }
// }//End Transaction
// }//End Session
// }
// return ytpg;
//}
//public facebookpageinfo setfbpage()
//{
// facebookpageinfo fbpginfo = null;
// return fbpginfo;
//}
//public googleplusinfo setgpulsinfo()
//{
// googleplusinfo gplusinfo = null;
// return gplusinfo;
//}
//public instagrampage setinstagraminfo()
//{
// instagrampage instpg = null;
// return instpg;
//}
//public linkedinpage setlinkedinpageinfo()
//{
// linkedinpage linkpg = null;
// return linkpg;
//}
//public twitterpage settwitterpageinfo()
//{
// twitterpage twitterpg = null;
// return twitterpg;
//}
//public youtubepage setyoutubepageinfo()
//{
// youtubepage ytpg = null;
// return ytpg;
//}
#endregion
public bool AddcompanyProfileName(Domain.Myfashion.Domain.CompanyProfiles companyProfiles)
{
bool IsSuccess = false;
//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 data.
try
{
session.Save(companyProfiles);
transaction.Commit();
IsSuccess = true;
return(IsSuccess);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(IsSuccess);
}
} //End Transaction
} //End Session
}
public void InsertTwitterRecentDetails(Domain.Socioboard.Domain.TwitterRecentDetails data)
{
bool exists = false;
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
exists = session.Query <Domain.Socioboard.Domain.TwitterRecentDetails>()
.Any(x => x.TwitterId == data.TwitterId);
}
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
if (exists)
{
session.CreateQuery("Update twitterrecentdetails set AccountCreationDate = : AccountCreationDate , LastActivityDate = : LastActivityDate , LastFeed = : LastFeed , FeedId = : FeedId , FeedRetweetCount = : FeedRetweetCount , FeedFavoriteCount = : FeedFavoriteCount where TwitterId = : TwitterId")
.SetParameter("AccountCreationDate", data.AccountCreationDate)
.SetParameter("LastActivityDate", data.LastActivityDate)
.SetParameter("LastFeed", data.LastFeed)
.SetParameter("FeedId", data.FeedId)
.SetParameter("FeedRetweetCount", data.FeedRetweetCount)
.SetParameter("FeedFavoriteCount", data.FeedFavoriteCount)
.ExecuteUpdate();
transaction.Commit();
}
else
{
session.Save(data);
transaction.Commit();
}
}
}
}
/// <AddLog>
/// Add Log
/// </AddLog>
/// <param name="log">Set Values in a Log Class Property and Pass the Object of Log Class (SocioBoard.Domain.Log).</param>
public void AddLog(Log log)
{
//Lock the functionality
//When multiple users to access add data at same time.
lock (LockAddLog)
{
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 new details
session.Save(log);
transaction.Commit();
} //End Transaction
} //End Session
}
catch (Exception ex)
{
}
}//End Lock
}
public string Add(MandrillAccount MandrillAccount)
{
string res = null;
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 add new row.
session.Save(MandrillAccount);
transaction.Commit();
res = "Added";
} //End transaction
} //End session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(res);
}
public bool InsertCompaign(CmpFanPageLiker acc)
{
bool Flage = false;
try
{
lock (lockerInsert)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(acc);
transaction.Commit();
Flage = true;
}
}
}
}
catch (Exception ex)
{
GlobusLogHelper.log.Error("Error : " + ex.StackTrace);
}
return(Flage);
}
public int Add <T>(T item) where T : class, new()
{
int result = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession(_env))
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(item);
transaction.Commit();
result = 1;
}
}
}
catch (Exception ex)
{
result = 0;
_logger.LogCritical(ex.Message);
_logger.LogError(ex.StackTrace);
if (ex.InnerException != null)
{
_logger.LogError(ex.InnerException.Message);
_logger.LogError(ex.InnerException.StackTrace);
}
}
return(result);
}
public int Add <T>(IEnumerable <T> items) where T : class, new()
{
int result = 0;
foreach (var item in items)
{
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession(_env))
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(item);
transaction.Commit();
result = 1;
}
}
}
catch (Exception ex)
{
result = 0;
_logger.LogCritical(ex.Message);
_logger.LogError(ex.StackTrace);
}
}
return(result);
}
public static Riferimento Riferimento_Create(
String Nominativo,
String Telefono,
String EMail
)
{
try
{
Riferimento aRiferimento =
new Riferimento();
NHibernate.ISession aNHibernateSession = NHibernateHelper.GetOrCreateCurrentSession();
aRiferimento.Nominativo = Nominativo;
aRiferimento.Telefono = Telefono;
aRiferimento.EMail = EMail;
aNHibernateSession.Save(aRiferimento);
aNHibernateSession.Flush();
return(aRiferimento);
}
catch (Exception)
{
return(null);
}
}
public void AddGoogleAnalyticsReport(Domain.Socioboard.Domain.GoogleAnalyticsReport _GoogleAnalyticsReport)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
bool exist = session.Query <Domain.Socioboard.Domain.GoogleAnalyticsReport>().Any(t => t.GaProfileId == _GoogleAnalyticsReport.GaProfileId);
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
if (!exist)
{
session.Save(_GoogleAnalyticsReport);
transaction.Commit();
}
else
{
try
{
session.CreateQuery("Update GoogleAnalyticsReport set Visits=:Visits, Views=:Views,TwitterMention=:TwitterMention, Article_Blogs =: Article_Blogs where GaProfileId =: GaProfileId")
.SetParameter("Visits", _GoogleAnalyticsReport.Visits)
.SetParameter("Views", _GoogleAnalyticsReport.Views)
.SetParameter("GaProfileId", _GoogleAnalyticsReport.GaProfileId)
.SetParameter("TwitterMention", _GoogleAnalyticsReport.TwitterMention)
.SetParameter("Article_Blogs", _GoogleAnalyticsReport.Article_Blogs)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
}
}
}
}
}
/// <Add>
/// Add a new invitation in DataBase.
/// </summary>
/// <param name="user">Set Values in a invitation Class Property and Pass the Object of invitation Class (SocioBoard.Domain.Admin).</param>
public int Add(Invitation invitation)
{
int res = 0;
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 data.
session.Save(invitation);
transaction.Commit();
res = 1;
} //End Using trasaction
} //End Using session
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(res);
}
public bool AddShareathonPost(SharethonGroupPost shareathon)
{
bool IsSuccess = false;
//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 data.
try
{
session.Save(shareathon);
transaction.Commit();
IsSuccess = true;
return(IsSuccess);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(IsSuccess);
}
} //End Transaction
} //End Session
}
/// <AddBusinessSetting>
/// Check If User Id is exist or Not. If User Id is Exist then It will Update that same Users all Business Setting. Otherwise It add a new Business Setting Data.
/// </summary>
/// <param name="businessSetting">Set Values in a BusinessSetting Class Property and Pass the same Object of BusinessSetting Class.(Domain.BusinessSetting)</param>
public void AddBusinessSetting(Domain.Socioboard.Domain.BusinessSetting 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 check if user is Exist or not.
List <Domain.Socioboard.Domain.BusinessSetting> lstBusinessSetting = CheckUserId(businessSetting.UserId, businessSetting.GroupId, businessSetting.BusinessName);
//if user is Exist the it update all BusinessSetting of the Same user,
//Otherwise it add New BusinessSetting.
if (lstBusinessSetting.Count > 0)
{
UpdateBusinessSetting(businessSetting);
}
else
{
session.Save(businessSetting);
transaction.Commit();
}
} //End Transaction
} //End session
}
/// <Insert>
/// Add a Blog_Comment in a Database
/// </summary>
/// <param name="blog_Comments">The object of the Blog_Comments class(Domain.Blog_Comments)</param>
/// <returns>Return Integer</returns>
public int Insert(Blog_Comments blog_Comments)
{
int insert = 0;
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 data
session.Save(blog_Comments);
transaction.Commit();
insert = 1;
} //End Using trasaction
} //End using session
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return(insert);
}
public int AddUserRefRelation(UserRefRelation userRefRelation)
{
int res = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(userRefRelation);
transaction.Commit();
res = 1;
}
}
logger.Error("Coming out of AddUserRefRelation");
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
logger.Error("UserRefRelationRepository>>AddUserRefRelation" + ex.Message);
}
return(res);
}
public void AddStdout(string data)
{
using (NHibernate.ISession session = SessionFactory.OpenSession())
{
using (NHibernate.ITransaction trans = session.BeginTransaction())
{
var process = session
.CreateCriteria <SinterProcess>()
.Add(Restrictions.Eq("Id", this.id))
.UniqueResult <SinterProcess>();
if (process.stdout == null)
{
process.stdout = data;
}
else
{
process.stdout += data;
}
session.Save(process);
trans.Commit();
}
}
}
public void Post([FromBody] Contact contactUs)
{
using (var transaction = _session.BeginTransaction())
{
_session.Save(contactUs);
transaction.Commit();
}
}
public static void Add(Employee Employee)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(Employee);
transaction.Commit();
}
}
}
public static void addUsers(Users user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(user);
transaction.Commit();
}
}
}
public void addFacebookStats(FacebookStats fbstats)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(fbstats);
transaction.Commit();
}
}
}
public void AddLikes(Domain.Socioboard.Domain.GoogleplusLike _GoogleplusLike)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(_GoogleplusLike);
transaction.Commit();
}
}
}
public void addTwitterStats(Domain.Socioboard.Domain.TwitterStats TwtStats)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(TwtStats);
transaction.Commit();
}
}
}
public static void Add(websitereviewdata user)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(user);
transaction.Commit();
}
}
}
//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);
}