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