public void Dispose() { OnDisposing(); OutputOnDemand(); outputCache.Dispose(); Session?.Dispose(); sessionFactory?.Dispose(); }
public void Dispose() { _sessionFactory?.Dispose(); _sessionFactory = null; _configuration = null; }
public void ShouldAcceptReadOnlyPropertiesDuplicatingAColumn() { var mappings = GetValidMappings(); var cfg = TestConfigurationHelper.GetDefaultConfiguration(); cfg.AddMapping(mappings); ISessionFactory factory = null; try { Assert.That( () => factory = cfg.BuildSessionFactory(), Throws.Nothing); } finally { factory?.Dispose(); } }
public void ShouldThrowSoundErrorForBadlyMappedEntity() { var mappings = GetMappings(); var cfg = TestConfigurationHelper.GetDefaultConfiguration(); cfg.AddMapping(mappings); ISessionFactory factory = null; try { Assert.That( () => factory = cfg.BuildSessionFactory(), Throws.TypeOf <MappingException>().And.Message.Contains("BadlyMappedEntity").And.InnerException .Message.Contains("SameColumn")); } finally { factory?.Dispose(); } }
public void TearDown() { _transaction.Dispose(); _session.Dispose(); _sessionFactory.Dispose(); }
void IJob.Execute(JobExecutionContext context) { ILog log = LogManager.GetLogger(typeof(read_1)); try { if (factory == null) { cfg = new Configuration(); cfg.AddAssembly("BRIChannelSchedulerNew"); factory = cfg.BuildSessionFactory(); } session = factory.OpenSession(); Console.WriteLine(schInfo + SchCode + " === Starting " + SchName + " ==="); try { //CMS Oprasioanal Status dan Payroll Oprasional Status //CMS Oprasional Parameter paramCMS = session.Load <Parameter>("CMS_OPERASIONAL_STATUS"); String cmsOprasional = paramCMS.Data; //Payroll Oprasional Parameter paramPayroll = session.Load <Parameter>("PAYROLL_OPERASIONAL_STATUS"); String payrollOprasional = paramPayroll.Data; if (cmsOprasional.Equals("1") && payrollOprasional.Equals("1")) { Commitjob_transaction(log); } else { Console.WriteLine(schInfo + " === Starting " + SchName + " CMS or Payroll Not in Oprasional Status ==="); } } catch (Exception ee) { log.Error(SchCode + " === " + SchName + " Process Error Message:: " + ee.Message); log.Error(SchCode + " === " + SchName + " Process Error Inner Exception:: " + ee.InnerException); log.Error(SchCode + " === " + SchName + " Process Error StackTrace:: " + ee.StackTrace); } Console.WriteLine(schInfo + SchCode + " === End " + SchName + " ==="); } catch (Exception ex) { log.Error(SchCode + " === " + SchName + " Failed To Start Message:: " + ex.Message); log.Error(SchCode + " === " + SchName + " Failed To Start Inner Exception:: " + ex.InnerException); log.Error(SchCode + " === " + SchName + " Failed To Start StackTrace:: " + ex.StackTrace); } finally { if (session.IsOpen) { session.Clear(); session.Close(); session.Dispose(); } factory.Close(); factory.Dispose(); cfg = null; GC.Collect(); } }
public static void Stop() { sessionFactory.Dispose(); connection.Dispose(); }
public void AfterAllTests() { SessionFactory.Dispose(); SessionFactory = null; SessionFactoryProvider = null; }
public void Dispose() { mockSolr.VerifyAll(); sessionFactory.Dispose(); System.IO.File.Delete(testdbfilename); }
public void Dispose() { _factory.Close(); _factory.Dispose(); }
public void Dispose() { _sessionFactory.Close(); _sessionFactory.Dispose(); }
public virtual void TearDown() { sessionFactory?.Dispose(); }
void IJob.Execute(JobExecutionContext context) { ILog log = LogManager.GetLogger(typeof(RunBeforePayroll)); try { if (factory == null) { cfg = new Configuration(); cfg.AddAssembly("BRIChannelSchedulerNew"); factory = cfg.BuildSessionFactory(); } session = factory.OpenSession(); Console.WriteLine(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + " - " + SchCode + " === Starting " + SchName + " ==="); try { Parameter param = session.Load <Parameter>("PAYROLL_OPERASIONAL_STATUS"); if (param.Data.Equals("1")) { // sayedzul - 2016-03-28 - Holiday parameter //string day = SchedulerHelper.isHoliday(session, 120, DateTime.Now); //if (day.Equals("[WEEKEND]")) // Console.WriteLine(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + " - " + SchCode + " === Weekend!"); //else if (day.Equals("[HOLIDAY]")) // Console.WriteLine(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + " - " + SchCode + " === Holiday!"); //else if (day.Equals("[WEEKDAY]")) //{ Parameter paramCute = session.Load <Parameter>("PAYROLL_CUTOFFTIME"); DateTime cutoff = DateTime.ParseExact(DateTime.Now.Day.ToString("00") + "/" + DateTime.Now.Month.ToString("00") + "/" + DateTime.Now.Year.ToString("0000") + " " + paramCute.Data + ":00", "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); Parameter paramStart = session.Load <Parameter>("PAYROLL_STARTTIME"); DateTime start = DateTime.ParseExact(DateTime.Now.Day.ToString("00") + "/" + DateTime.Now.Month.ToString("00") + "/" + DateTime.Now.Year.ToString("0000") + " " + paramStart.Data + ":00", "dd/MM/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); if ((cutoff.CompareTo(DateTime.Now) > 0) && (start.CompareTo(DateTime.Now) < 0)) { Commitjob_transaction(log); } else { Console.WriteLine(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + " - " + SchCode + " === CUTOFF TIME"); } //} //else // log.Error(SchCode + " === " + day); //end sayedzul - 2016-03-28 } } catch (Exception ee) { log.Error(SchCode + " === " + SchName + " Process Error Message:: " + ee.Message); log.Error(SchCode + " === " + SchName + " Process Error Inner Exception:: " + ee.InnerException); log.Error(SchCode + " === " + SchName + " Process Error StackTrace:: " + ee.StackTrace); } Console.WriteLine(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + " - " + SchCode + " === End " + SchName + " ==="); } catch (Exception ex) { log.Error(SchCode + " === " + SchName + " Failed To Start Message:: " + ex.Message); log.Error(SchCode + " === " + SchName + " Failed To Start Inner Exception:: " + ex.InnerException); log.Error(SchCode + " === " + SchName + " Failed To Start StackTrace:: " + ex.StackTrace); } finally { session.Clear(); session.Close(); session.Dispose(); factory.Close(); factory.Dispose(); cfg = null; GC.Collect(); } }
/// <summary> /// Shutdowns the specified session factory. /// </summary> /// <param name="sessionFactory">The session factory.</param> /// <remarks> /// Dispose <see cref="TestDatabaseInitializer"/> will destroy Session Factory associated with this instance. /// </remarks> public static void Shutdown([CanBeNull] ISessionFactory sessionFactory) { sessionFactory?.Dispose(); }
public void TestFixtureTeardown() { SessionFactory.Dispose(); }
/// <summary> /// 保存或更新实体 /// </summary> /// <param name="entity"></param> public void SaveOrUpdateEntity(BaseEntity entity) { ISessionFactory factory = null; ISession session = null; ITransaction transaction = null; // Tell NHibernate that this object should be updated try { factory = Connection.getConfiguration().BuildSessionFactory(); session = factory.OpenSession(); transaction = session.BeginTransaction(); session.SaveOrUpdate(session.Merge(entity)); // commit all of the changes to the DB and close the ISession transaction.Commit(); //MessageBox.Show("保存成功"); } catch (Exception e) { if (transaction != null && transaction.IsActive) { transaction.Rollback(); } throw e; } finally { if (session != null && session.IsOpen) { factory.Close(); session.Clear(); session.Close(); factory.Dispose(); session.Dispose(); } } }
public virtual void TearDown() { SessionFactory.Dispose(); SessionFactory = null; SessionFactoryProvider = null; }
public void Dispose() { CleanUp(); _sessionFactory.Dispose(); }
public static void Cleanup() { _session.Dispose(); _sessionFactory.Dispose(); _burrowsFramework.CloseWorkSpace(); }
public override void Shutdown() { base.Shutdown(); _sessionFactory.Dispose(); }
public void TearDown() { sessionFactory.Dispose(); }
public void Dispose() { _SessionFactory.Dispose(); }
public void Dispose() { session.Dispose(); sessionFactory.Dispose(); }
public void Dispose() => _inner.Dispose();
void IJob.Execute(JobExecutionContext context) { cfg = new Configuration(); cfg.AddAssembly("BRIChannelSchedulerNew"); ILog log = LogManager.GetLogger(typeof(UploadFileResponse)); Console.WriteLine(schInfo + SchCode + "STARTING SCHEDULLER COPY FILE RESPONSE PAYROLL TO SHARED FOLDER =="); try { if (factory == null) { cfg = new Configuration(); cfg.AddAssembly("BRIChannelSchedulerNew"); factory = cfg.BuildSessionFactory(); } ISession session = factory.OpenSession(); Parameter paramReport = session.Load <Parameter>("FOLDER_PAYROLL_OUTPUT"); String pathReport = paramReport.Data; Parameter paramClientId = session.Load <Parameter>("CLIENT_SHARED_FOLDER_PAYROLL"); String[] CId = paramClientId.Data.Split(new String[] { "," }, StringSplitOptions.RemoveEmptyEntries); IList <ClientMatrix> cm = session.CreateCriteria(typeof(ClientMatrix)) .Add(Expression.In("Id", CId)) .List <ClientMatrix>(); foreach (ClientMatrix cm1 in cm) { #region ger URL and kawan2 log.Info(schInfo + SchCode + "ClientID : " + cm1.Id + " - Start Checking URL"); AuthorityHelper ah = new AuthorityHelper(cm1.Matrix); url = ah.GetTransactionURL(100); //log.Info(url); uid = ah.GetTransactionUID(100); pass = ah.GetTransactionPASS(100); pid = ah.GetTransactionMAKER(100); //log.Info(maker); Email = ah.GetTransactionEmail(100); //get input url if (url.Contains("|")) { string[] url_temp = url.Split('|'); url = url_temp[1]; } IList <User> us = session.CreateCriteria(typeof(User)) .Add(Expression.Eq("Id", Convert.ToInt32(pid))) .List <User>(); foreach (User u in us) { maker = u.Handle; } log.Info(schInfo + SchCode + "ClientID : " + cm1.Id + " URL found : " + url + " for user : "******"ClientID", cm1.Id)) .Add(Expression.Eq("SharedFolderStatus", "YES|")) .Add(Expression.Like("FileDescription", maker, MatchMode.Anywhere)) .Add(Expression.Eq("Status", ParameterHelper.TRXSTATUS_REJECT)) .List <TrxPayroll>(); if (ohno.Count > 0) { #region Inquiry NACK log.Info(schInfo + SchCode + "Client Id = " + cm1.Id + ". Total File Error = " + ohno.Count.ToString()); foreach (TrxPayroll ppp in ohno) { compareTime = DateTime.Compare(ppp.LastUpdate.AddMinutes(5), DateTime.Now); if (compareTime < 0) //lASTUPDATE + 5 < NOW { FileInfo fi = new FileInfo(ppp.FilePath); string filename_error = fi.Name; localFile = pathReport + filename_error.Substring(0, filename_error.Length - 4) + ".nack"; TextWriter tw1 = new StreamWriter(pathReport + filename_error.Substring(0, filename_error.Length - 4) + ".nack"); //generate NACK int counter = 0; IList <TrxPayrollDetail> listPayDetail = ppp.TrxPayrollDetail; foreach (TrxPayrollDetail detail in listPayDetail) { string a = ""; string text_status = ""; //handling Exception (,) - Denny if (detail.Status == ParameterHelper.TRXSTATUS_SUCCESS) { if (text_status.Contains(",")) { text_status = "SUCCESS - " + detail.Description.Replace(",", " "); } else { text_status = "SUCCESS - " + detail.Description; } } else { if (text_status.Contains(",")) { text_status = "REJECTED - " + detail.Description.Replace(",", " "); } else { text_status = "REJECTED - " + detail.Description; } } if (counter == 0) { a = "NO,NAMA,ACCOUNT,AMOUNT,EMAIL,CUSTOMERREFF,STATUS"; tw1.WriteLine(a); } int no_urut = counter + 1; a = no_urut.ToString() + "," + detail.Name + "," + detail.Account + "," + detail.Amount + "," + detail.Email + "," + detail.CustomerReff + "," + text_status; tw1.WriteLine(a); counter++; } string[] batch_desc = ppp.Description.Split('|');//get batch desc tw1.WriteLine(batch_desc[0]); tw1.Close(); log.Info(schInfo + SchCode + "Client Id = " + cm1.Id + " File name : " + ppp.FileName + "Generate NACK Success"); Ext = ".nack"; string outUpload = ""; if (UploadToSharedFolder("3", filename_error.Substring(0, filename_error.Length - 4) + ".nack", pathReport, log, session, cm1, ppp.Id, SchCode, schInfo, url, uid, pass, localFile, ppp.SeqNumber, out outUpload)) { ppp.SharedFolderStatus += "1:NOT|";//a.k.a NACK } else { ppp.SharedFolderStatus += "Exception on NACK||"; ppp.ErrorDescription = "Exception on NACK||" + outUpload; } //update database session.Update(ppp); session.Flush(); } else { log.Info(schInfo + SchCode + "ClientID : " + cm1.Id + " Waiting DateTime to Retry NACK File (5 minutes)"); } } #endregion } else { #region Inquiry Exception NACK IList <TrxPayroll> ohnoex = session.CreateCriteria(typeof(TrxPayroll)) .Add(Expression.Eq("ClientID", cm1.Id)) .Add(Expression.Eq("SharedFolderStatus", "YES|Exception on NACK||")) .Add(Expression.Like("FileDescription", maker, MatchMode.Anywhere)) .Add(Expression.Eq("Status", ParameterHelper.TRXSTATUS_REJECT)) .List <TrxPayroll>(); if (ohnoex.Count > 0) { //Update status to retry sent response NACK foreach (TrxPayroll ohnoex2 in ohnoex) { ohnoex2.SharedFolderStatus = "YES|"; session.Update(ohnoex2); log.Info(schInfo + SchCode + "ClientID = " + cm1.Id + " Update Exception NACK to Retry again, SUCCESS "); } } #endregion end of Inquiry Exception NACK else { Console.WriteLine(schInfo + SchCode + "ClientID = " + cm1.Id + " Tidak ada data untuk NACK file "); } } //ACK FILE IList <TrxPayroll> ohyes = session.CreateCriteria(typeof(TrxPayroll)) .Add(Expression.Eq("ClientID", cm1.Id)) .Add(Expression.Eq("SharedFolderStatus", "YES|")) .Add(Expression.Like("FileDescription", maker, MatchMode.Anywhere)) .Add(Expression.Eq("Status", ParameterHelper.TRXSTATUS_COMPLETE)) .List <TrxPayroll>(); if (ohyes.Count > 0) { #region Inquiry ACk log.Info(schInfo + SchCode + "Client Id = " + cm1.Id + ". Total File Sukses = " + ohyes.Count.ToString()); foreach (TrxPayroll ppp in ohyes) { compareTime = DateTime.Compare(ppp.LastUpdate.AddMinutes(5), DateTime.Now); if (compareTime < 0) //lASTUPDATE + 5 < NOW { FileInfo fi = new FileInfo(ppp.FilePath); string filename_error = fi.Name; TextWriter tw1 = new StreamWriter(pathReport + filename_error.Substring(0, filename_error.Length - 4) + ".ack"); localFile = pathReport + filename_error.Substring(0, filename_error.Length - 4) + ".ack"; int counter = 0; IList <TrxPayrollDetail> listPayDetail = ppp.TrxPayrollDetail; totalRecord = listPayDetail.Count(); foreach (TrxPayrollDetail detail in listPayDetail) { string a = ""; string text_status = ""; //handling Exception (,) - Denny if (detail.Status == ParameterHelper.TRXSTATUS_SUCCESS) { if (text_status.Contains(",")) { text_status = "SUCCESS - " + detail.Description.Replace(",", " "); recordAck++; } else { text_status = "SUCCESS - " + detail.Description; recordAck++; } } else { if (text_status.Contains(",")) { text_status = "REJECTED - " + detail.Description.Replace(",", " "); recordNAPR++; } else { text_status = "REJECTED - " + detail.Description; recordNAPR++; } } if (counter == 0) { a = "NO,NAMA,ACCOUNT,AMOUNT,EMAIL,CUSTOMERREFF,STATUS"; tw1.WriteLine(a); } int no_urut = counter + 1; a = no_urut.ToString() + "," + detail.Name + "," + detail.Account + "," + detail.Amount + "," + detail.Email + "," + detail.CustomerReff + "," + text_status; tw1.WriteLine(a); counter++; } tw1.Close(); log.Info(schInfo + SchCode + "ClientID = " + cm1.Id + " File name : " + ppp.FileName + "Generate ACK Success"); Ext = ".ack"; string outUpload = ""; if (UploadToSharedFolder("", filename_error.Substring(0, filename_error.Length - 4) + ".ack", pathReport, log, session, cm1, ppp.Id, SchCode, schInfo, url, uid, pass, localFile, ppp.SeqNumber, out outUpload)) { ppp.SharedFolderStatus += "1:ACK|";//a.k.a NACK } else { ppp.SharedFolderStatus += "Exception on ACK||"; ppp.ErrorDescription = "Exception on ACK||" + outUpload; } //update database session.Update(ppp); session.Flush(); } else { log.Info(schInfo + SchCode + "ClientID : " + cm1.Id + " Waiting DateTime to Retry ACK File (5 minutes)"); } } } #endregion Inquiry ACK else { #region Inquiry Exception ACK IList <TrxPayroll> ohyesex = session.CreateCriteria(typeof(TrxPayroll)) .Add(Expression.Eq("ClientID", cm1.Id)) .Add(Expression.Eq("SharedFolderStatus", "YES|Exception on ACK||")) .Add(Expression.Like("FileDescription", maker, MatchMode.Anywhere)) .Add(Expression.Eq("Status", ParameterHelper.TRXSTATUS_COMPLETE)) .List <TrxPayroll>(); if (ohyesex.Count > 0) { //Update status to retry sent response ACK foreach (TrxPayroll ohyesex2 in ohyesex) { ohyesex2.SharedFolderStatus = "YES|"; session.Update(ohyesex2); log.Info(schInfo + SchCode + "ClientID = " + cm1.Id + " Update Exception ACk to Retry again, SUCCESS "); } } #endregion end of Inquiry Exception ACK else { Console.WriteLine(schInfo + SchCode + "ClientID = " + cm1.Id + " Tidak ada data untuk ACK file "); } } } /* Absensi SCHManager - Denny 20190207 * Absen dengan Message : RUNNING * SCHCODE harus sama dg SCHCODE di DB, sbg key * * Ketika absen UPDATE data dengan cek lastRun VS Jeda: * - Update schlast run = Date now * - Last update = Date Now * - Set message * * Ketika autorestart, * - melakukan rstart di semua job dalam 1 server * - Cek semua job support autorestart / tdk, jika tdk keluarkan message. */ #region Absensi job 1 try { Boolean absenSch = false; String outMsgAbsen = "Belum dilakukan absen"; absenSch = SchManagerHelper.AbsensiSch(session, SchCode, "RUNNING", out outMsgAbsen); Console.WriteLine(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") + " - " + SchCode + " === Absensi " + " :: " + outMsgAbsen); } catch (Exception ex) { //Cetak log kalo gagal Absen log.Error(SchCode + " === Gagal Absen Exception : " + ex.Message); log.Error(SchCode + " === Gagal Absen Inner Exception : " + ex.InnerException); log.Error(SchCode + " === Gagal Absen Stack Trace : " + ex.StackTrace); } #endregion Absensi job 1 } catch (Exception ex) { log.Error(ex.Message + " = " + ex.InnerException + " = " + ex.StackTrace); factory.Close(); factory.Dispose(); factory = null; cfg = null; GC.Collect(); } Console.WriteLine(schInfo + SchCode + "END OF SCHEDULLER FILE RESPONSE PAYROLL SHARED FOLDER =="); }
public void FixtureTeardown() { mockSolr.VerifyAll(); sessionFactory.Dispose(); }
public void Dispose() { _instanceConnection.Close(); _instanceConnection.Dispose(); _instanceSessionFactory.Dispose(); }
public void Dispose() { _currentSession?.Dispose(); _sessionFactory?.Dispose(); GC.SuppressFinalize(this); }
private static ISessionFactory getSessionFactory(ref ISessionFactory factory, NHibernate.Cfg.Configuration cfg) { if (factory != null) { if (factory.IsClosed) { factory.Dispose(); factory = null; } } if (factory == null) { factory = cfg.BuildSessionFactory(); } return factory; }
public void Dispose() { _nhHelper.Dispose(); _sessionFactory.Dispose(); }
public virtual void Dispose() { _sessionFactory.Dispose(); }
public void Teardown() { _sessionFactory.Dispose(); }
private void Run() { var shardedConfiguration = BuildShardedConfiguration(); CreateSchema(shardedConfiguration); sessionFactory = shardedConfiguration.BuildShardedSessionFactory(); AddData(); ISession session = sessionFactory.OpenSession(); try { ICriteria crit = session.CreateCriteria(typeof(WeatherReport), "weather"); var count = crit.List(); if (count != null) Console.WriteLine(count.Count); crit.Add(Restrictions.Gt("Temperature", 33)); var reports = crit.List(); if (reports != null) Console.WriteLine(reports.Count); } finally { session.Close(); } sessionFactory.Dispose(); Console.WriteLine("Done."); Console.ReadKey(true); }