public int UpdateS02008(S02008ViewModel model) { int result; try { EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02008", 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("SALESORDERNO", DbType.String).Value = model.SalesOrderNo; cmd.Parameters.Add("NOCHASIS_INPUT", DbType.String).Value = model.ChassisNumberByVendor; cmd.Parameters.Add("TGLMASUKKAROSERI", DbType.DateTime).Value = model.DateEntryCarrosserieAccessories; OpenConnection(); result = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { result = 0; throw ex; } finally { CloseConnection(); } return(result); }
public int UpdateTransactionS02008(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 S02008ViewModel modelSO2008 = SplitStringS02008(listTransactionDataModel[i].Data[j]); //UPDATE CUSTOMPO CUSTOMPO customPO = entities.CUSTOMPOes.SingleOrDefault(x => x.PONUMBER == modelSO2008.PONumber); //customPO.TGLMASUKKAROSERI = modelSO2008.DateEntryCarrosserieAccessories; //UPDATE CUSTOMGR CUSTOMGR customGR = entities.CUSTOMGRs.SingleOrDefault(x => x.PONUMBER == modelSO2008.PONumber); //customGR.NOCHASIS_INPUT = modelSO2008.ChassisNumberByVendor; if (customPO != null && customGR != null) { //calling sp_UpdateS02008 result = UpdateS02008(modelSO2008); } //entities.SaveChanges(); } } //result = 1; } catch (Exception ex) { return(result = 0); } 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); }
private S02008ViewModel SplitStringS02008(string stringHS) { S02008ViewModel model = new S02008ViewModel(); try { string[] words = stringHS.Split('|'); //if (words.Length == 3) //{ for (int i = 1; i < words.Length; i++) { if (!string.IsNullOrEmpty(words[i])) { decimal decimalValue; var date = words[i].Trim(); 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.SalesOrderNo = words[i].Length > 15 ? words[i].Substring(0, 15).Trim() : words[i].Trim(); break; case 5: model.ChassisNumberByVendor = words[i].Length > 18 ? words[i].Substring(0, 18).Trim() : words[i].Trim(); break; case 6: var lastDate = words[i].Remove(words[i].IndexOf('}')).Trim(); model.DateEntryCarrosserieAccessories = !string.IsNullOrEmpty(lastDate) ? Convert.ToDateTime(lastDate) : Convert.ToDateTime("19000101"); //if (lastDate.Length == 8) //{ // if (lastDate.Substring(0, 2) == "20") // { // var dateFormat = Convert.ToDateTime(lastDate); // var dateFormatString = dateFormat.ToString("yyyyMMdd"); // model.DateEntryCarrosserieAccessories = dateFormat; // } //} break; default: break; } } } //} } catch (Exception ex) { throw ex; } return(model); }