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);
}
