public int UpdateS02004(S02004ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02004", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = model.PONumber;
cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = Convert.ToInt32(model.VersionPOSERA);
cmd.Parameters.Add("DATAVERSION", DbType.Int32).Value = Convert.ToInt32(model.DataVersion);
cmd.Parameters.Add("STATUS", DbType.DateTime).Value = model.Status;
cmd.Parameters.Add("REASONREJECTION", DbType.String).Value = model.ReasonRejection;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
private S02004ViewModel SplitStringS02004(string stringHS)
{
S02004ViewModel model = new S02004ViewModel();
try
{
string[] words = stringHS.Split('|');
for (int i = 1; i < words.Length; i++)
{
if (!string.IsNullOrEmpty(words[i]))
{
decimal decimalValue;
switch (i)
{
case 1:
model.PONumber = words[i].Length > 50 ? words[i].Substring(0, 50).Trim() : words[i].Trim();
break;
case 2:
if (Decimal.TryParse(words[i], out decimalValue))
{
model.VersionPOSERA = Convert.ToDecimal(words[i]);
}
break;
case 3:
if (Decimal.TryParse(words[i], out decimalValue))
{
model.DataVersion = Convert.ToDecimal(words[i]);
}
break;
case 4:
model.Status = words[i].Length > 1 ? words[i].Substring(0, 1).Trim() : words[i].Trim();
break;
case 5:
var reasonRejection = words[i].Remove(words[i].IndexOf('}')).Trim();
reasonRejection = reasonRejection.Length > 500 ? reasonRejection.Substring(0, 500).Trim() : reasonRejection;
model.ReasonRejection = reasonRejection;
break;
default:
break;
}
}
}
//}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public int UpdateTransactionS02004(List <TransactionDataViewModel> listTransactionDataModel)
{
int result = 0;
try
{
for (int i = 0; i < listTransactionDataModel.Count; i++)
{
for (int j = 0; j < listTransactionDataModel[i].Data.Length; j++)
{
//SPLITSTRING
S02004ViewModel modelHSSO2004 = SplitStringS02004(listTransactionDataModel[i].Data[j]);
result = UpdateS02004(modelHSSO2004);
}
}
}
catch (Exception ex)
{
return(result = 0);
}
return(result);
}
public int InsertLogTransactionDownloadS02004(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.TransStatus = transStatus;
EntityHelper.SetAuditForInsert(transactionData, "SERA");
entities.CUSTOM_DOWNLOAD_TRANSACTIONDATA.AddObject(transactionData);
for (int j = 0; j < listTransactionDataModel[i].Data.Length; j++)
{
//SPLITSTRING
S02004ViewModel modelSO2004 = SplitStringS02004(listTransactionDataModel[i].Data[j]);
if (modelSO2004 != null)
{
//insert into CUSTOM_S02004
CUSTOM_S02004 s02004 = new CUSTOM_S02004();
s02004.CUSTOM_DOWNLOAD_TRANSACTIONDATA = transactionData;
s02004.PONumber = modelSO2004.PONumber;
s02004.VersionPOSERA = modelSO2004.VersionPOSERA;
s02004.DataVersion = modelSO2004.DataVersion;
s02004.Status = modelSO2004.Status;
s02004.ReasonRejection = modelSO2004.ReasonRejection;
//start add by fhi 18.06.2014 : set owner
s02004.dibuatOleh = "system";
s02004.dibuatTanggal = DateTime.Now;
s02004.diubahOleh = "system";
s02004.diubahTanggal = DateTime.Now;
//end
entities.CUSTOM_S02004.AddObject(s02004);
}
//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);
}
