public void GetJobId(Session session)
{
try
{
CriteriaOperator criteria_0 = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria_1 = new BinaryOperator("Code", JobRegisterCode, BinaryOperatorType.Equal);
CriteriaOperator criteria_2 = new BinaryOperator("Code", "Accounting", BinaryOperatorType.Equal);
CriteriaOperator criteria = new GroupOperator(GroupOperatorType.And, criteria_0, criteria_1);
CriteriaOperator criteria_cat = new GroupOperator(GroupOperatorType.And, criteria_2);
NAS.DAL.ETL.ETLJob _ETLJob = session.FindObject <NAS.DAL.ETL.ETLJob>(criteria);
if (_ETLJob == null)
{
_ETLJob = new NAS.DAL.ETL.ETLJob(session);
_ETLJob.Code = JobRegisterCode;
_ETLJob.Description = "";
_ETLJob.ETLCategory = session.FindObject <ETLCategory>(criteria_cat);
_ETLJob.Is24x7 = true;
_ETLJob.Priority = 1;
_ETLJob.RowStatus = Constant.ROWSTATUS_ACTIVE;
_ETLJob.Save();
}
JobId = _ETLJob.ETLJobId;
}
catch (Exception ex)
{
ETLUtils etlUtil = new ETLUtils();
etlUtil.logs("d:/logs/Process_history.txt", DateTime.Now.ToString() + " : COGS GetJobId:" + ex.Message);
return;
}
}
public void Run()
{
ETLUtils etlUtil = new ETLUtils();
session = XpoHelper.GetNewSession();
GetJobId(session);
WorkFlow();
}
public void Run()
{
ETLUtils etlUtil = new ETLUtils();
string FilePath = Application.StartupPath + "\\";
session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "ID"), etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "DBName"));
GetJobId(session);
WorkFlow();
}
public void Run()
{
ETLUtils etlUtil = new ETLUtils();
string FilePath = Application.StartupPath + "\\";
session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "ID"), etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "DBName"));
//session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML("../../dbConfig.xml", "ID"), etlUtil.GetValFromXML("../../dbConfig.xml", "DBName"));
GetJobId(session);
Stop = false;
//Console.WriteLine("Start Job");
WorkFlow();
//Console.WriteLine("End Job");
}
public void Run()
{
ETLUtils etlUtil = new ETLUtils();
string FilePath = Application.StartupPath + "\\";
session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "ID"), etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "DBName"));
//session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML("../../dbConfig.xml", "ID"), etlUtil.GetValFromXML("../../dbConfig.xml", "DBName"));
GetJobId(session);
//delete GeneralLedger
CriteriaOperator criteria = new BinaryOperator("RowStatus", Constant.ROWSTATUS_DELETED, BinaryOperatorType.Equal);
XPCollection <GeneralLedger> temp = new XPCollection <GeneralLedger>(session, criteria);
session = Utility.ETL.DatabaseHelper.GetNewSession("192.168.1.133", "ERPCore");
session.PurgeDeletedObjects();
}
public static void Populate(Session dbSession)
{
Session session = null;
try
{
ETLUtils util = new ETLUtils();
ETLJob.Populate(dbSession);
session = dbSession;
ETLJob etlJob;
CriteriaOperator criteria = new BinaryOperator("Code", Utility.Constant.NAAN_DEFAULT_CODE, BinaryOperatorType.Equal);
etlJob = session.FindObject <ETLJob>(criteria);
//insert default data into ETLCategory table
if (!Util.IsExistXpoObject <ETLJobDetail>(session, "ETLJobId", etlJob))
{
etlJob = session.FindObject <ETLJob>(criteria);
ETLJobDetail _ETLJobDetail = new ETLJobDetail(session)
{
Data = null,
ETLJobId = etlJob
};
_ETLJobDetail.Save();
}
criteria = new BinaryOperator("Code", Utility.Constant.NAAN_DEFAULT_CODE, BinaryOperatorType.Equal);
etlJob = session.FindObject <ETLJob>(criteria);
if (!Util.IsExistXpoObject <ETLJobDetail>(session, "ETLJobId", etlJob))
{
etlJob = session.FindObject <ETLJob>(criteria);
ETLJobDetail _ETLJobDetail = new ETLJobDetail(session)
{
Data = ETLUtils.ConvertStringToByte(Utility.Constant.NAAN_DEFAULT_CODE),
ETLJobId = etlJob
};
_ETLJobDetail.Save();
}
}
catch (Exception)
{
throw;
}
finally
{
//if (session != null) session.Dispose();
}
}
protected static ProcessStartInfo GetETLMasterProcessInfo()
{
ProcessStartInfo newProcess = null;
try
{
ETLUtils util = new ETLUtils();
var etlMasterpath = "C:/Program Files (x86)/NAANSolution/NAS_ETL";
etlMasterpath = Application.StartupPath + "\\";
newProcess = new ProcessStartInfo();
newProcess.FileName = etlMasterpath + "NAS_ETLMaster.exe";
newProcess.UseShellExecute = false;
newProcess.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
}
catch (Exception)
{
throw;
}
finally
{
}
return(newProcess);
}
public void RepairCOGSByTransaction(Session session, Guid _TransactionId)
{
try
{
InventoryTransaction transaction = session.GetObjectByKey <InventoryTransaction>(_TransactionId);
ETLUtils etlUtil = new ETLUtils();
if (transaction == null)
{
etlUtil.logs("d:/logs/Process_history.txt", "TransactionId: " + _TransactionId.ToString() + "was not found");
return;
}
int i = 1;
foreach (COGS cogs in transaction.COGSs)
{
RepairCOGS(session, cogs.COGSId);
}
}
catch (Exception)
{
return;
}
}
static void Main(string[] args)
{
try
{
ETLUtils etlUtil = new ETLUtils();
//etlUtil.logs("d:/logs/history.txt", "Start");
string FilePath = Application.StartupPath + "\\";
session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "ID"), etlUtil.GetValFromXML(FilePath + "dbConfig.xml", "DBName"));
//session = Utility.ETL.DatabaseHelper.GetNewSession(etlUtil.GetValFromXML("../../dbConfig.xml", "ID"), etlUtil.GetValFromXML("../../dbConfig.xml", "DBName"));
//session = Utility.ETL.DatabaseHelper.GetNewSession("192.168.1.150","ERPCore_Vuong");
ProcessHelper processHelper = new ProcessHelper();
ETLUtils util = new ETLUtils();
Util ETLUtil = new Util();
Util.Populate(session);
//etlUtil.logs("d:/logs/history.txt", "Start Launch");
#region TestLogic
#endregion
#region Init TempData For Testing
#endregion
#region InitBO
ETLEntryObjectHistoryBO _ETLEntryObjectHistoryBO = new ETLEntryObjectHistoryBO();
ObjectEntryLogBO _ObjectEntryLogBO = new ObjectEntryLogBO();
ETLJobBO _ETLJobBO = new ETLJobBO();
ETLLogBO _ETLLogBO = new ETLLogBO();
BusinessObjectBO _BusinessObjectBO = new BusinessObjectBO();
ETL_DiaryJournal _ETL_DiaryJournal = new ETL_DiaryJournal();
#endregion
#region TestETL
//FinancialSupplierLiabilityBO bo = new FinancialSupplierLiabilityBO();
//ETLAccountingBO bo1 = new ETLAccountingBO();
//ETLInventoryBO inventoryBO = new ETLInventoryBO();
//double crbl = bo1.GetAccountingBalanceAtTime(session, Guid.Parse("11000000-0000-0000-0000-000000000001"), Guid.Parse("00110000-0000-0000-0000-000000000001"), DateTime.Parse("2014-01-03 12:00:00"));
//COGS cogs = inventoryBO.GetPreviousCOGS(session, Guid.Parse("12300000-0000-0000-0000-000000000002"));
//InventoryLedger crledger = session.GetObjectByKey<InventoryLedger>(Guid.Parse("e6be6f9a-a661-498a-a389-471945bde8c6"));
//InventoryLedger preledger;
//XPQuery<COGS> COGSQuery = new XPQuery<COGS>(session);
//IQueryable<COGS> COGSCol = (from c in COGSQuery
// where c.InventoryTransactionId.RowStatus >= Constant.ROWSTATUS_ACTIVE
// select c);
//preledger = inventoryBO.GetPreviousInventoryLedger(session, crledger);
//XPQuery<InventoryLedger> ledgerQuery = new XPQuery<InventoryLedger>(session);
//var TransactionList = (from r in ledgerQuery
// select r.InventoryTransactionId).Distinct();
//ETL_Transaction tran = bo1.ExtractTransaction(session, Guid.Parse("5cbaa5b8-9e7c-48ed-b2a7-7353f4a15fc4"),"131");
//List<ETL_FinnancialSupplierLiabilityDetail> detail = bo.TransformTransactionToSupplierLiabilityDetail(session, tran, "131");
//bo.LoadFinancialSupplierLiabilityDetail(session, detail, "131");
//List<ETL_GeneralJournal> jl = new List<ETL_GeneralJournal>();
//ETL_GeneralJournal jo1 = new ETL_GeneralJournal();
//ETL_GeneralJournal jo2 = new ETL_GeneralJournal();
//ETL_GeneralJournal jo3 = new ETL_GeneralJournal();
//ETL_GeneralJournal jo4 = new ETL_GeneralJournal();
//jo1.AccountId = Guid.Parse("2B7F3BA9-4AE4-42E7-8568-F5D5B8A009EB");//111
//jo1.CreateDate = DateTime.Now;
//jo1.Credit = 100;
//jo1.Debit = 0;
//jo1.Description = "111";
//jo1.JournalType = 'C';
//jl.Add(jo1);
//jo2.AccountId = Guid.Parse("B107C675-2895-40B6-BD33-B4D501BBB0D9");//331
//jo2.CreateDate = DateTime.Now;
//jo2.Credit = 100;
//jo2.Debit = 0;
//jo2.Description = "331";
//jo2.JournalType = 'C';
//jl.Add(jo2);
//jo3.AccountId = Guid.Parse("BDEF51E0-5318-42AA-BA2C-D5F713EA0711");//121
//jo3.CreateDate = DateTime.Now;
//jo3.Credit = 400;
//jo3.Debit = 0;
//jo3.Description = "121";
//jo3.JournalType = 'C';
//jl.Add(jo3);
//jo4.AccountId = Guid.Parse("E573B446-D70D-46A3-9AE3-9E7F8A3C71C7");//521
//jo4.CreateDate = DateTime.Now;
//jo4.Credit = 0;
//jo4.Debit = 600;
//jo4.Description = "521";
//jo4.JournalType = 'C';
//jl.Add(jo4);
//List<ETL_GeneralJournal> rs = _ETL_DiaryJournal.JoinJournalList(session, jl);
//ETL_Transaction transaction = new ETL_Transaction();
//transaction.Amount = 0;
//transaction.Code = "ABC";
//transaction.CreateDate = DateTime.Now;
//transaction.Description = "Description";
//transaction.GeneralJournalList = rs;
//transaction.IsBalanceForward = false;
//transaction.IssuedDate = DateTime.Now;
//transaction.OwnerOrgId = Guid.Empty;
//transaction.TransactionId = Guid.NewGuid();
//List<DJ_Fact> djList = _ETL_DiaryJournal.TransformToDiaryJournal(session, transaction);
//List<ETL_GeneralJournal> rs = bo.JoinJournal(session, jl);
//List<ETL_GeneralJournal> rs1 = bo.ClearJournalList(session, rs, Guid.Parse("C32268A6-5843-4199-A840-F6042B66686A"));
//List<int> BusinessObjectTypeId = new List<int> { Constant.BusinessObjectType_Transaction,
// Constant.BusinessObjectType_FinancialTransaction,
// Constant.BusinessObjectType_InputInventoryCommandFinancialTransaction,
// Constant.BusinessObjectType_OutputInventoryCommandFinancialTransaction,
// Constant.BusinessObjectType_PaymentVoucherTransaction,
// Constant.BusinessObjectType_PurcharseFinancialTransaction,
// Constant.BusinessObjectType_ReceiptVoucherTransaction,
// Constant.BusinessObjectType_SalesFinancialTransaction };
//Guid refid = _ETLJobBO.ETLGetNextProcessObject(session, Guid.Parse("7688b739-f90e-43ac-8ccb-5c0663e30d0b"), BusinessObjectTypeId);
#endregion
bool checkDependency = true;
bool checkService = true;
checkService = processHelper.IsExistMutex(Utility.Constant.Process_Running_Mutex_Name_ETLService);
//Check service running
//if (!checkService)
//{
// Console.WriteLine("You can't start NAS_ETLMaster without ETLService.\n2s to close...");
// //Thread.Sleep(2000);
// return;
//}
checkDependency = processHelper.IsExistMutex(Utility.Constant.Process_Running_Mutex_Name_ETLMaster);
if (checkDependency)
{
Console.WriteLine("Another NAS_ETLMaster Process Is Running.\nCan't open more than one NAS_ETLMaster Process...\n2s to close");
return;
}
Mutex ETLMasterMutex = new Mutex(true, Utility.Constant.Process_Running_Mutex_Name_ETLMaster);
Console.WriteLine("ETLMaster Running");
bool running = true;
bool processRunning = false;
do
{
for (int i = 0; i < processName.Length; i++)
{
if (run[i])
{
processRunning = processHelper.IsExistMutex(Utility.Constant.Process_Running_Mutex_Name_ETLProcess + "_" + processName[i]);
if (!processRunning)
{
Console.WriteLine("Calling {0}", processName[i]);
CallProcess(processName[i]);
}
}
}
checkService = processHelper.IsExistMutex(Utility.Constant.Process_Running_Mutex_Name_ETLService);
running = !processHelper.IsExistMutex(Utility.Constant.Process_Stop_Mutex_Name_ETLMaster) && running;// && checkService;
Thread.Sleep(10000);
}while (running);
ETLMasterMutex.Dispose();
ETLMasterMutex.Close();
}
catch (Exception ex)
{
ETLUtils etlUtil = new ETLUtils();
etlUtil.logs("d:/logs/history.txt", DateTime.Now.ToString() + " : Master Error:" + ex.Message);
//Console.WriteLine(ex.ToString());
}
finally
{
}
}
