public int InsertLogTransactionS02003(List <CUSTOM_S02003_TEMP> listTempHS)
{
LogEvent logEvent = new LogEvent();
int result = 0;
try
{
if (listTempHS.Count > 0)
{
//insert into CUSTOM_TRANSACTION
CUSTOM_TRANSACTION transaction = new CUSTOM_TRANSACTION();
transaction.TicketNo = "";
transaction.ClientTag = "";
EntityHelper.SetAuditForInsert(transaction, "SERA");
entities.CUSTOM_TRANSACTION.AddObject(transaction);
var countListTempHS = listTempHS.Count;
//var countListTempIS = listTempIS.Count;
for (int i = 0; i < listTempHS.Count; i++)
{
//insert into CUSTOM_TRANSACTIONDATA
CUSTOM_TRANSACTIONDATA transactionData = new CUSTOM_TRANSACTIONDATA();
transactionData.CUSTOM_TRANSACTION = transaction;
transactionData.TransGUID = Guid.NewGuid().ToString();
transactionData.DocumentNumber = listTempHS[i].PONumber;
transactionData.FileType = "S02003";
transactionData.IPAddress = "118.97.80.12"; //"127.0.0.1";
transactionData.DestinationUser = "******";
//transactionData.Key1 = "0002"; //company toyota
transactionData.Key1 = listTempHS[i].CompanyCodeAI;
transactionData.Key2 = listTempHS[i].KodeCabangAI;
transactionData.Key3 = "";
transactionData.DataLength = null;
transactionData.RowStatus = "";
EntityHelper.SetAuditForInsert(transactionData, "SERA");
entities.CUSTOM_TRANSACTIONDATA.AddObject(transactionData);
//CHECK IF DATA HS BY PONUMBER SUDAH ADA, DELETE DULU BY ID, supaya tidak redundant ponumber nya
var poNumb = listTempHS[i].PONumber;
var query = (from o in entities.CUSTOM_S02003
where o.PONumber == poNumb
select o).ToList();
if (query.Count > 0)
{
for (int d = 0; d < query.Count; d++)
{
//delete
var delID = query[d].ID;
CUSTOM_S02003 delHS = entities.CUSTOM_S02003.Single(o => o.ID == delID);
entities.CUSTOM_S02003.DeleteObject(delHS);
}
}
//insert into CUSTOM_S02003
CUSTOM_S02003 DataDetailHS = new CUSTOM_S02003();
DataDetailHS.CUSTOM_TRANSACTIONDATA = transactionData;
DataDetailHS.PONumber = listTempHS[i].PONumber;
DataDetailHS.VersionPOSera = listTempHS[i].VersionPOSera;
DataDetailHS.DataVersion = listTempHS[i].DataVersion;
DataDetailHS.KodeCabangAI = listTempHS[i].KodeCabangAI;
DataDetailHS.ReasonRejection = listTempHS[i].ReasonRejection;
//start add identitas penambahan row custom_s02003 : by fhi 04.06.2014
DataDetailHS.dibuatOleh = "system";
DataDetailHS.dibuatTanggal = DateTime.Now;
DataDetailHS.diubahOleh = "system";
DataDetailHS.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_S02003.AddObject(DataDetailHS);
//build HS separator
var strHS = ConcateStringHSS02003(listTempHS[i]);
//insert into CUSTOM_TRANSACTIONDATADETAIL for HS
CUSTOM_TRANSACTIONDATADETAIL transactionDataDetail = new CUSTOM_TRANSACTIONDATADETAIL();
transactionDataDetail.CUSTOM_TRANSACTIONDATA = transactionData;
transactionDataDetail.Data = strHS;
//start add identitas penambahan row CUSTOM_TRANSACTIONDATADETAIL : by fhi 04.06.2014
transactionDataDetail.dibuatOleh = "system";
transactionDataDetail.dibuatTanggal = DateTime.Now;
transactionDataDetail.diubahOleh = "system";
transactionDataDetail.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_TRANSACTIONDATADETAIL.AddObject(transactionDataDetail);
}
entities.SaveChanges();
//todo: delete temp table
for (int y = 0; y < countListTempHS; y++)
{
DeleteTempHSS02003(listTempHS[y]);
}
result = 1;
}
else
{
//add task kill when failed : by fhi 04.06.2014
logEvent.WriteDBLog("", "UploadS02003_Load", false, "", "listTempHS.Count <= 0", "S02003", "SERA");
Process.Start("taskkill.exe", "/f /im B2BAISERA_S02003.exe");
//end
}
}
catch (Exception ex)
{
//add task kill when failed : by fhi 04.06.2014
logEvent.WriteDBLog("", "UploadS02003_Load", false, "", ex.Message, "S02003", "SERA");
Process.Start("taskkill.exe", "/f /im B2BAISERA_S02003.exe");
//end
throw ex;
}
return(result);
}
public int InsertLogTransactionS02007(List <CUSTOM_S02007_TEMP> listTempHS)
{
int result = 0;
try
{
if (listTempHS.Count > 0)
{
//insert into CUSTOM_TRANSACTION
CUSTOM_TRANSACTION transaction = new CUSTOM_TRANSACTION();
transaction.TicketNo = "";
transaction.ClientTag = "";
EntityHelper.SetAuditForInsert(transaction, "SERA");
entities.CUSTOM_TRANSACTION.AddObject(transaction);
var countListTempHS = listTempHS.Count;
//var countListTempIS = listTempIS.Count;
for (int i = 0; i < listTempHS.Count; i++)
{
//insert into CUSTOM_TRANSACTIONDATA
CUSTOM_TRANSACTIONDATA transactionData = new CUSTOM_TRANSACTIONDATA();
transactionData.CUSTOM_TRANSACTION = transaction;
transactionData.TransGUID = Guid.NewGuid().ToString();
transactionData.DocumentNumber = listTempHS[i].PONUMBER;
transactionData.FileType = "S02007";
transactionData.IPAddress = "118.97.80.12"; //IP ADDRESS KOMP SERVER, dan HARUS TERDAFTAR DI DB AI
transactionData.DestinationUser = "******";
//transactionData.Key1 = "0002"; //company toyota
transactionData.Key1 = listTempHS[i].CompanyCodeAI;
transactionData.Key2 = GetKodeCabangAI(listTempHS[i].PONUMBER); //trial: kode cabang AI
transactionData.Key3 = listTempHS[i].BILLINGNO; //BILLINGNO
transactionData.DataLength = null;
transactionData.RowStatus = "";
EntityHelper.SetAuditForInsert(transactionData, "SERA");
entities.CUSTOM_TRANSACTIONDATA.AddObject(transactionData);
//CHECK IF DATA HS BY PONUMBER SUDAH ADA, DELETE DULU BY ID, supaya tidak redundant ponumber nya
var poNumb = listTempHS[i].PONUMBER;
var query = (from o in entities.CUSTOM_S02007
where o.PONUMBER == poNumb
select o).ToList();
if (query.Count > 0)
{
for (int d = 0; d < query.Count; d++)
{
//delete
var delID = query[d].ID;
CUSTOM_S02007 delHS = entities.CUSTOM_S02007.Single(o => o.ID == delID);
entities.CUSTOM_S02007.DeleteObject(delHS);
}
}
//insert into CUSTOM_S02007
CUSTOM_S02007 DataDetailHS = new CUSTOM_S02007();
DataDetailHS.CUSTOM_TRANSACTIONDATA = transactionData;
DataDetailHS.PONUMBER = listTempHS[i].PONUMBER;
DataDetailHS.VERSIONPOSERA = listTempHS[i].VERSIONPOSERA;
DataDetailHS.BILLINGNO = listTempHS[i].BILLINGNO;
DataDetailHS.INVOICERECEIPTDATE = listTempHS[i].INVOICERECEIPTDATE;
DataDetailHS.DATAVERSION = listTempHS[i].DATAVERSION;
DataDetailHS.payPlan = listTempHS[i].payPlan;
//start add identitas penambahan row CUSTOM_S02007 : by fhi 05.06.2014
DataDetailHS.dibuatOleh = "system";
DataDetailHS.dibuatTanggal = DateTime.Now;
DataDetailHS.diubahOleh = "system";
DataDetailHS.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_S02007.AddObject(DataDetailHS);
//build HS separator
var strHS = ConcateStringHSS02007(listTempHS[i]);
//insert into CUSTOM_TRANSACTIONDATADETAIL for HS
CUSTOM_TRANSACTIONDATADETAIL transactionDataDetail = new CUSTOM_TRANSACTIONDATADETAIL();
transactionDataDetail.CUSTOM_TRANSACTIONDATA = transactionData;
transactionDataDetail.Data = strHS;
//start add identitas penambahan row CUSTOM_S02007 : by fhi 05.06.2014
transactionDataDetail.dibuatOleh = "system";
transactionDataDetail.dibuatTanggal = DateTime.Now;
transactionDataDetail.diubahOleh = "system";
transactionDataDetail.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_TRANSACTIONDATADETAIL.AddObject(transactionDataDetail);
}
entities.SaveChanges();
//todo: delete temp table
for (int y = 0; y < countListTempHS; y++)
{
DeleteTempHSS02007(listTempHS[y]);
}
result = 1;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}