public int InsertLogTransactionDownloadS02002(bool acknowledge, string ticketNo, string message, string transStatus, List <TransactionDataViewModel> listTransactionDataModel)
{
List <string> errorCatch2 = new List <string>();
List <CUSTOM_DOWNLOAD_TRANSACTION> listC1 = new List <CUSTOM_DOWNLOAD_TRANSACTION>();
List <CUSTOM_DOWNLOAD_TRANSACTIONDATA> listC2 = new List <CUSTOM_DOWNLOAD_TRANSACTIONDATA>();
List <CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL> listC3 = new List <CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL>();
List <CUSTOM_S02002> listC4 = new List <CUSTOM_S02002>();
int result = 0;
try
{
//insert into CUSTOM_DOWNLOAD_TRANSACTION
CUSTOM_DOWNLOAD_TRANSACTION transaction = new CUSTOM_DOWNLOAD_TRANSACTION();
transaction.Acknowledge = acknowledge;
transaction.TicketNo = ticketNo;
transaction.Message = message;
EntityHelper.SetAuditForInsert(transaction, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTION.AddObject(transaction);
listC1.Add(transaction);
for (int i = 0; i < listTransactionDataModel.Count; i++)
{
try
{
//insert into CUSTOM_DOWNLOAD_TRANSACTIONDATA
CUSTOM_DOWNLOAD_TRANSACTIONDATA transactionData = new CUSTOM_DOWNLOAD_TRANSACTIONDATA();
transactionData.CUSTOM_DOWNLOAD_TRANSACTION = transaction;
transactionData.AIID = listTransactionDataModel[i].AIID;
transactionData.TransGUID = listTransactionDataModel[i].TransGUID;
transactionData.DocumentNumber = listTransactionDataModel[i].DocumentNumber;
transactionData.FileType = listTransactionDataModel[i].FileType;
transactionData.IPAddress = listTransactionDataModel[i].IPAddress;
transactionData.DestinationUser = listTransactionDataModel[i].DestinationUser;
transactionData.Key1 = listTransactionDataModel[i].Key1;
transactionData.Key2 = listTransactionDataModel[i].Key2;
transactionData.Key3 = listTransactionDataModel[i].Key3;
transactionData.DataLength = listTransactionDataModel[i].DataLength;
transactionData.TransStatus = transStatus;
EntityHelper.SetAuditForInsert(transactionData, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATA.AddObject(transactionData);
listC2.Add(transactionData);
S02002ViewModel modelHSSO2002 = new S02002ViewModel();
S02002ViewModel modelISSO2002 = new S02002ViewModel();
for (int j = 0; j < listTransactionDataModel[i].Data.Length; j++)
{
//switch (j)
//{
// case 0:
// modelHSSO2002 = SplitStringHSS02002(listTransactionDataModel[i].Data[j]);
// break;
// case 1:
// modelISSO2002 = SplitStringISS02002(listTransactionDataModel[i].Data[j]);
// break;
// default:
// break;
//}
if (listTransactionDataModel[i].Data[j].Split('|')[0].Trim().Contains("HS"))
{
modelHSSO2002 = SplitStringHSS02002(listTransactionDataModel[i].Data[j]);
}
else if (listTransactionDataModel[i].Data[j].Split('|')[0].Trim().Contains("IS"))
{
modelISSO2002 = SplitStringISS02002(listTransactionDataModel[i].Data[j]);
}
//insert into CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL
CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL transactionDataDetail = new CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL();
transactionDataDetail.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
transactionDataDetail.Data = listTransactionDataModel[i].Data[j];
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL.AddObject(transactionDataDetail);
listC3.Add(transactionDataDetail);
}
//insert into CUSTOM_S02002 FOR HS
if (!string.IsNullOrEmpty(modelHSSO2002.PONumber))
{
CUSTOM_S02002 s02002 = new CUSTOM_S02002();
s02002.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
s02002.PONumber = modelHSSO2002.PONumber;
s02002.VersionPOSERA = modelHSSO2002.VersionPOSERA;
s02002.DataVersion = modelHSSO2002.DataVersion;
s02002.StatusPOSERA = modelHSSO2002.StatusPOSERA;
s02002.RejectRevisedPOSERA = modelHSSO2002.RejectRevisedPOSERA;
s02002.DocumentNo = modelHSSO2002.DocumentNo;
s02002.AIMaterialNumber = modelHSSO2002.AIMaterialNumber;
s02002.SERAMaterialNumber = modelHSSO2002.SERAMaterialNumber;
s02002.SERAMaterialDescription = modelHSSO2002.SERAMaterialDescription;
s02002.AIColor = modelHSSO2002.AIColor;
s02002.SERAColor = modelHSSO2002.SERAColor;
s02002.QuotationNo = modelHSSO2002.QuotationNo;
if (modelISSO2002 != null)
{
s02002.SalesOrderNo = modelISSO2002.SalesOrderNo;
s02002.SalesOrderStatus = modelISSO2002.SalesOrderStatus;
s02002.DPPByVendor = modelISSO2002.DPPByVendor;
s02002.PPNByVendor = modelISSO2002.PPNByVendor;
s02002.BBNPriceByVendor = modelISSO2002.BBNPriceByVendor;
s02002.Currency = modelISSO2002.Currency;
s02002.ChassisNumberByVendor = modelISSO2002.ChassisNumberByVendor;
s02002.MachineNumberByVendor = modelISSO2002.MachineNumberByVendor;
s02002.CBUCKD = modelISSO2002.CBUCKD;
s02002.Year = modelISSO2002.Year;
s02002.FactureDONumber = modelISSO2002.FactureDONumber;
s02002.BillingStatus = modelISSO2002.BillingStatus;
s02002.FactureDODate = modelISSO2002.FactureDODate;
s02002.NoFakturKendaraan = modelISSO2002.NoFakturKendaraan;
s02002.TanggalFakturKendaraan = modelISSO2002.TanggalFakturKendaraan;
s02002.CancellationReason = modelISSO2002.CancellationReason;
s02002.ActualDateDeliveryUnit = modelISSO2002.ActualDateDeliveryUnit;
s02002.BSTKBNo = modelISSO2002.BSTKBNo;
s02002.LicensePlateByVendor = modelISSO2002.LicensePlateByVendor;
s02002.STNKDateByVendor = modelISSO2002.STNKDateByVendor;
s02002.RevisiSTNK = modelISSO2002.RevisiSTNK;
s02002.NoSertifikat = modelISSO2002.NoSertifikat;
s02002.TglSertifikat = modelISSO2002.TglSertifikat;
s02002.NoFormulirA = modelISSO2002.NoFormulirA;
s02002.TglFormulirA = modelISSO2002.TglFormulirA;
s02002.NoSertifikatRegUjiTipe = modelISSO2002.NoSertifikatRegUjiTipe;
s02002.ActualDeliveryBPKBDate = modelISSO2002.ActualDeliveryBPKBDate;
s02002.NamaPenerima = modelISSO2002.NamaPenerima;
s02002.AlamatPenerima = modelISSO2002.AlamatPenerima;
s02002.BPKBNumber = modelISSO2002.BPKBNumber;
s02002.RemarksBPKB = modelISSO2002.RemarksBPKB;
s02002.RevisiBPKB = modelISSO2002.RevisiBPKB;
}
//start add by fhi 18.06.2014 : set owner
s02002.dibuatOleh = "system";
s02002.dibuatTanggal = DateTime.Now;
s02002.diubahOleh = "system";
s02002.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_S02002.AddObject(s02002);
listC4.Add(s02002);
}
}
catch (Exception ex)
{
errorCatch2.Add(i + " | " + listTransactionDataModel[i].DocumentNumber + " | " + ex.Message);
}
}
entities.CommandTimeout = 50000;
entities.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 0;
throw ex;
}
return(result);
}
public int InsertLogTransactionDownloadS02008(bool acknowledge, string ticketNo, string message, string transStatus, List <TransactionDataViewModel> listTransactionDataModel)
{
int result = 0;
try
{
//insert into CUSTOM_DOWNLOAD_TRANSACTION
CUSTOM_DOWNLOAD_TRANSACTION transaction = new CUSTOM_DOWNLOAD_TRANSACTION();
transaction.Acknowledge = acknowledge;
transaction.TicketNo = ticketNo;
transaction.Message = message;
EntityHelper.SetAuditForInsert(transaction, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTION.AddObject(transaction);
for (int i = 0; i < listTransactionDataModel.Count; i++)
{
//insert into CUSTOM_DOWNLOAD_TRANSACTIONDATA
CUSTOM_DOWNLOAD_TRANSACTIONDATA transactionData = new CUSTOM_DOWNLOAD_TRANSACTIONDATA();
transactionData.CUSTOM_DOWNLOAD_TRANSACTION = transaction;
transactionData.AIID = listTransactionDataModel[i].AIID;
transactionData.TransGUID = listTransactionDataModel[i].TransGUID;
transactionData.DocumentNumber = listTransactionDataModel[i].DocumentNumber;
transactionData.FileType = listTransactionDataModel[i].FileType;
transactionData.IPAddress = listTransactionDataModel[i].IPAddress;
transactionData.DestinationUser = listTransactionDataModel[i].DestinationUser;
transactionData.Key1 = listTransactionDataModel[i].Key1;
transactionData.Key2 = listTransactionDataModel[i].Key2;
transactionData.Key3 = listTransactionDataModel[i].Key3;
transactionData.DataLength = listTransactionDataModel[i].DataLength;
//transactionData.RowStatus = "";
EntityHelper.SetAuditForInsert(transactionData, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATA.AddObject(transactionData);
for (int j = 0; j < listTransactionDataModel[i].Data.Length; j++)
{
//SPLITSTRING
S02008ViewModel modelSO2008 = SplitStringS02008(listTransactionDataModel[i].Data[j]);
if (modelSO2008 != null)
{
//insert into CUSTOM_S02008
CUSTOM_S02008 s02008 = new CUSTOM_S02008();
s02008.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
s02008.PONumber = modelSO2008.PONumber;
s02008.VersionPOSERA = modelSO2008.VersionPOSERA;
s02008.DataVersion = modelSO2008.DataVersion;
s02008.SalesOrderNo = modelSO2008.SalesOrderNo;
s02008.ChassisNumberByVendor = modelSO2008.ChassisNumberByVendor;
s02008.DateEntryCarrosserieAccessories = modelSO2008.DateEntryCarrosserieAccessories;
//start add by fhi 18.06.2014 : set owner
s02008.dibuatOleh = "system";
s02008.dibuatTanggal = DateTime.Now;
s02008.diubahOleh = "system";
s02008.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_S02008.AddObject(s02008);
}
//insert into CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL
CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL transactionDataDetail = new CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL();
transactionDataDetail.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
transactionDataDetail.Data = listTransactionDataModel[i].Data[j];
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL.AddObject(transactionDataDetail);
}
}
entities.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 0;
throw ex;
}
return(result);
}
public int InsertLogTransactionDownloadS02006(bool acknowledge, string ticketNo, string message, string transStatus, List <TransactionDataViewModel> listTransactionDataModel)
{
int result = 0;
try
{
//insert into CUSTOM_DOWNLOAD_TRANSACTION
CUSTOM_DOWNLOAD_TRANSACTION transaction = new CUSTOM_DOWNLOAD_TRANSACTION();
transaction.Acknowledge = acknowledge;
transaction.TicketNo = ticketNo;
transaction.Message = message;
EntityHelper.SetAuditForInsert(transaction, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTION.AddObject(transaction);
for (int i = 0; i < listTransactionDataModel.Count; i++)
{
//insert into CUSTOM_DOWNLOAD_TRANSACTIONDATA
CUSTOM_DOWNLOAD_TRANSACTIONDATA transactionData = new CUSTOM_DOWNLOAD_TRANSACTIONDATA();
transactionData.CUSTOM_DOWNLOAD_TRANSACTION = transaction;
transactionData.AIID = listTransactionDataModel[i].AIID;
transactionData.TransGUID = listTransactionDataModel[i].TransGUID;
transactionData.DocumentNumber = listTransactionDataModel[i].DocumentNumber;
transactionData.FileType = listTransactionDataModel[i].FileType;
transactionData.IPAddress = listTransactionDataModel[i].IPAddress;
transactionData.DestinationUser = listTransactionDataModel[i].DestinationUser;
transactionData.Key1 = listTransactionDataModel[i].Key1;
transactionData.Key2 = listTransactionDataModel[i].Key2;
transactionData.Key3 = listTransactionDataModel[i].Key3;
transactionData.DataLength = listTransactionDataModel[i].DataLength;
//transactionData.RowStatus = "";
EntityHelper.SetAuditForInsert(transactionData, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATA.AddObject(transactionData);
for (int j = 0; j < listTransactionDataModel[i].Data.Length; j++)
{
//SPLITSTRING
S02006ViewModel modelSO2006 = SplitStringS02006(listTransactionDataModel[i].Data[j]);
if (modelSO2006 != null)
{
//insert into CUSTOM_S02006
CUSTOM_S02006 s02006 = new CUSTOM_S02006();
s02006.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
s02006.BillingNo = modelSO2006.BillingNo;
s02006.KuitansiNo = modelSO2006.KuitansiNo;
s02006.KuitansiDate = modelSO2006.KuitansiDate;
s02006.CurrencyCode = modelSO2006.CurrencyCode;
s02006.AmountKuitansiDC = modelSO2006.AmountKuitansiDC;
s02006.BusinessAreaCode = modelSO2006.BusinessAreaCode;
s02006.CustomerNo = modelSO2006.CustomerNo;
s02006.NomorSpes = modelSO2006.NomorSpes;
s02006.SalesOrderNo = modelSO2006.SalesOrderNo;
s02006.SalesmanNumber = modelSO2006.SalesmanNumber;
s02006.NomorFakturPajak = modelSO2006.NomorFakturPajak;
s02006.ChasisNumber = modelSO2006.ChasisNumber;
s02006.PONumberSERA = modelSO2006.PONumberSERA;
s02006.VersionPOSERA = modelSO2006.VersionPOSERA;
s02006.KuitansiNoRef = modelSO2006.KuitansiNoRef;
s02006.KuitansiDateRef = modelSO2006.KuitansiDateRef;
s02006.DownloadDate = modelSO2006.DownloadDate;
//start add by fhi 18.06.2014 : set owner
s02006.dibuatOleh = "system";
s02006.dibuatTanggal = DateTime.Now;
s02006.diubahOleh = "system";
s02006.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_S02006.AddObject(s02006);
}
//insert into CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL
CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL transactionDataDetail = new CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL();
transactionDataDetail.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
transactionDataDetail.Data = listTransactionDataModel[i].Data[j];
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATADETAIL.AddObject(transactionDataDetail);
}
}
entities.SaveChanges();
result = 1;
}
catch (Exception ex)
{
result = 0;
throw ex;
}
return(result);
}