public int UpdateS02002HS(string poNumber, string HSorIS, S02002ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02002_HS", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = poNumber;
//CUSTOM_VENDOR_TRANSATION
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("STATUSPOSERA", DbType.String).Value = model.StatusPOSERA;
cmd.Parameters.Add("REJECTREVISEDPOSERA", DbType.String).Value = model.RejectRevisedPOSERA;
cmd.Parameters.Add("DOCUMENTNO", DbType.String).Value = model.DocumentNo;
cmd.Parameters.Add("AIMATERIALNUMBER", DbType.String).Value = model.AIMaterialNumber;
cmd.Parameters.Add("SERAMATERIALNUMBER", DbType.String).Value = model.SERAMaterialNumber;
cmd.Parameters.Add("SERAMATERIALDESCRIPTION", DbType.String).Value = model.SERAMaterialDescription;
cmd.Parameters.Add("AICOLOR", DbType.String).Value = model.AIColor;
cmd.Parameters.Add("SERACOLOR", DbType.String).Value = model.SERAColor;
cmd.Parameters.Add("QUOTATIONNO", DbType.String).Value = model.QuotationNo;
//cmd.Parameters.Add("HSORIS", DbType.String).Value = HSorIS;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
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 UpdateS02002IS(string poNumber, string HSorIS, S02002ViewModel model)
{
int result;
try
{
EntityCommand cmd = new EntityCommand("EProcEntities.sp_UpdateS02002_IS", entityConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("PONUMBER", DbType.String).Value = poNumber;
cmd.Parameters.Add("HARGADPP_INPUT", DbType.Double).Value = model.DPPByVendor;
cmd.Parameters.Add("HARGAPPNUNIT_INPUT", DbType.Double).Value = model.PPNByVendor;
cmd.Parameters.Add("HARGABBN_INPUT", DbType.Double).Value = model.BBNPriceByVendor;
// cmd.Parameters.Add("CBUCKD", DbType.String).Value = model.CBUCKD;// tidak ada di table
cmd.Parameters.Add("DONUMBER", DbType.String).Value = model.FactureDONumber;
cmd.Parameters.Add("DODATE", DbType.DateTime).Value = model.FactureDODate;
cmd.Parameters.Add("ACTUALDATEDELIVEREDUNIT", DbType.DateTime).Value = model.ActualDateDeliveryUnit;
cmd.Parameters.Add("NOCHASIS_INPUT", DbType.String).Value = model.ChassisNumberByVendor;
cmd.Parameters.Add("NOENGINE_INPUT", DbType.String).Value = model.MachineNumberByVendor;
cmd.Parameters.Add("NOFAKTUR", DbType.String).Value = model.NoFakturKendaraan;
cmd.Parameters.Add("TGLFAKTUR", DbType.DateTime).Value = model.TanggalFakturKendaraan;
cmd.Parameters.Add("NOPOLISI_INPUT", DbType.String).Value = model.LicensePlateByVendor;
cmd.Parameters.Add("TGLSTNK_INPUT", DbType.DateTime).Value = model.STNKDateByVendor;
cmd.Parameters.Add("NOSERTIFIKAT", DbType.String).Value = model.NoSertifikat;
cmd.Parameters.Add("TGLSERTIFIKAT", DbType.DateTime).Value = model.TglSertifikat;
cmd.Parameters.Add("NOFORMULIRA", DbType.String).Value = model.NoFormulirA;
cmd.Parameters.Add("TGLFORMULIRA", DbType.DateTime).Value = model.TglFormulirA;
cmd.Parameters.Add("NOSERTIFIKATREGUJITIPE", DbType.String).Value = model.NoSertifikatRegUjiTipe;
cmd.Parameters.Add("DATEDELIVERYTOBRANCHORVENDOR", DbType.DateTime).Value = model.ActualDeliveryBPKBDate;
cmd.Parameters.Add("NOBPKB", DbType.String).Value = model.BPKBNumber;
cmd.Parameters.Add("KETBPKB", DbType.String).Value = model.RemarksBPKB;
cmd.Parameters.Add("REVISEDATE", DbType.DateTime).Value = model.RevisiBPKB;
////CUSTOM_VENDOR_TRANSATION
//cmd.Parameters.Add("VERSIONPOSERA", DbType.Int32).Value = model.VersionPOSERA;
//cmd.Parameters.Add("DATAVERSION", DbType.Int32).Value = model.DataVersion;
//cmd.Parameters.Add("STATUSPOSERA", DbType.String).Value = model.StatusPOSERA;
//cmd.Parameters.Add("REJECTREVISEDPOSERA", DbType.String).Value = model.RejectRevisedPOSERA;
//cmd.Parameters.Add("DOCUMENTNO", DbType.String).Value = model.DocumentNo;
//cmd.Parameters.Add("AIMATERIALNUMBER", DbType.String).Value = model.AIMaterialNumber;
//cmd.Parameters.Add("SERAMATERIALNUMBER", DbType.String).Value = model.SERAMaterialNumber;
//cmd.Parameters.Add("SERAMATERIALDESCRIPTION", DbType.String).Value = model.SERAMaterialDescription;
//cmd.Parameters.Add("AICOLOR", DbType.String).Value = model.AIColor;
//cmd.Parameters.Add("SERACOLOR", DbType.String).Value = model.SERAColor;
//cmd.Parameters.Add("QUOTATIONNO", DbType.String).Value = model.QuotationNo;
cmd.Parameters.Add("SALESORDERNO", DbType.String).Value = model.SalesOrderNo;
cmd.Parameters.Add("SALESORDERSTATUS", DbType.Boolean).Value = model.SalesOrderStatus;
cmd.Parameters.Add("CURRENCY", DbType.String).Value = model.Currency;
cmd.Parameters.Add("YEAR", DbType.Int32).Value = model.Year;
cmd.Parameters.Add("BILLINGSTATUS", DbType.Boolean).Value = model.BillingStatus;
cmd.Parameters.Add("BSTKBNO", DbType.String).Value = model.BSTKBNo;
cmd.Parameters.Add("REVISISTNK", DbType.DateTime).Value = model.RevisiSTNK;
cmd.Parameters.Add("NAMAPENERIMA", DbType.String).Value = model.NamaPenerima;
cmd.Parameters.Add("ALAMATPENERIMA", DbType.String).Value = model.AlamatPenerima;
//cmd.Parameters.Add("HSORIS", DbType.String).Value = HSorIS;
OpenConnection();
result = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
result = 0;
throw ex;
}
finally
{
CloseConnection();
}
return(result);
}
public int UpdateTransactionS02002(List <TransactionDataViewModel> listTransactionDataModel)
{
int result = 0;
List <string> errorCatch = new List <string>();
try
{
for (int i = 0; i < listTransactionDataModel.Count; i++)
{
string poNumber = listTransactionDataModel[i].Data[0].Split('|')[1].Trim();
if (!string.IsNullOrEmpty(poNumber))
{
CUSTOMPO customPO = entities.CUSTOMPOes.SingleOrDefault(x => x.PONUMBER == poNumber);
CUSTOMGR customGR = entities.CUSTOMGRs.SingleOrDefault(x => x.PONUMBER == poNumber);
CUSTOMBPKB customBPKB = entities.CUSTOMBPKBs.SingleOrDefault(x => x.PONUMBER == poNumber);
for (int j = 0; j < listTransactionDataModel[i].Data.Length; j++)
{
try
{
S02002ViewModel modelSO2002 = new S02002ViewModel();
//switch (j)
//{
// case 0:
// S02002ViewModel modelHSSO2002 = SplitStringHSS02002(listTransactionDataModel[i].Data[j]);
// break;
// case 1:
// S02002ViewModel modelISSO2002 = SplitStringISS02002(listTransactionDataModel[i].Data[j]);
// break;
// default:
// break;
//}
if (listTransactionDataModel[i].Data[j].Split('|')[0].Trim().Contains("HS"))
{
modelSO2002 = SplitStringHSS02002(listTransactionDataModel[i].Data[j]);
}
else if (listTransactionDataModel[i].Data[j].Split('|')[0].Trim().Contains("IS"))
{
modelSO2002 = SplitStringISS02002(listTransactionDataModel[i].Data[j]);
}
//HS-IS update
if (listTransactionDataModel[i].Data[j].Split('|')[0].Trim().Contains("HS"))
{
result = UpdateS02002HS(poNumber, "HS", modelSO2002);
}
else if (listTransactionDataModel[i].Data[j].Split('|')[0].Trim().Contains("IS"))
{
if (customPO != null && customGR != null && customBPKB != null)
{
result = UpdateS02002IS(poNumber, "IS", modelSO2002);
}
}
//CustomPO Update
if (customGR.ACTUALRECEIVEDUNIT.HasValue && modelSO2002.ActualDateDeliveryUnit.HasValue && customPO.ACTUALDATEDELIVEREDUNIT.HasValue)
{
UpdateCustomPOStatusPOId(poNumber, "5");
}
}
catch (Exception ex)
{
errorCatch.Add(poNumber + " | " + ex.Message);
//something
}
}
}
}
}
catch (Exception ex)
{
return(result = 0);
}
return(result);
}
private S02002ViewModel SplitStringISS02002(string stringHS)
{
S02002ViewModel model = new S02002ViewModel();
try
{
//TODO 21-08-2013:VALIDASI SUBSTRING
string[] words = stringHS.Split('|');
for (int i = 1; i < words.Length; i++)
{
if (!string.IsNullOrEmpty(words[i]))
{
double doubleValue;
int intValue;
//DateTime datetimeValue;
var date = words[i].Trim();
switch (i)
{
case 1:
model.SalesOrderNo = words[i].Length > 15 ? words[i].Substring(0, 15).Trim() : words[i].Trim();
break;
case 2:
model.SalesOrderStatus = words[i] == "1" ? true : false;
break;
case 3:
if (Double.TryParse(words[i], out doubleValue))
{
model.DPPByVendor = Convert.ToDouble(words[i]);
}
break;
case 4:
if (Double.TryParse(words[i], out doubleValue))
{
model.PPNByVendor = Convert.ToDouble(words[i]);
}
break;
case 5:
if (Double.TryParse(words[i], out doubleValue))
{
model.BBNPriceByVendor = Convert.ToDouble(words[i]);
}
break;
case 6:
model.Currency = words[i];
break;
case 7:
model.ChassisNumberByVendor = words[i];
break;
case 8:
model.MachineNumberByVendor = words[i];
break;
case 9:
model.CBUCKD = words[i];
break;
case 10:
if (Int32.TryParse(words[i], out intValue))
{
model.Year = Convert.ToInt32(words[i]);
}
break;
case 11:
model.FactureDONumber = words[i];
break;
case 12:
model.BillingStatus = words[i] == "1" ? true : false;
break;
case 13:
//if (words[i].Substring(0, 2) == "20")
//{
// if (DateTime.TryParse(words[i], out datetimeValue))
// {
// model.FactureDODate = Convert.ToDateTime(words[i]);
// }
//}
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.FactureDODate = dateFormat;
//}
}
break;
case 14:
model.NoFakturKendaraan = words[i];
break;
case 15:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.TanggalFakturKendaraan = dateFormat;
//}
}
break;
case 16:
model.CancellationReason = words[i];
break;
case 17:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.ActualDateDeliveryUnit = dateFormat;
//}
}
break;
case 18:
model.BSTKBNo = words[i];
break;
case 19:
model.LicensePlateByVendor = words[i];
break;
case 20:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.STNKDateByVendor = dateFormat;
//}
}
break;
case 21:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.RevisiSTNK = dateFormat;
//}
}
break;
case 22:
model.NoSertifikat = words[i];
break;
case 23:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.TglSertifikat = dateFormat;
//}
}
break;
case 24:
model.NoFormulirA = words[i];
break;
case 25:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.TglFormulirA = dateFormat;
//}
}
break;
case 26:
model.NoSertifikat = words[i];
break;
case 27:
if (date.Length == 8)
{
//if (date.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.ActualDeliveryBPKBDate = dateFormat;
//}
}
break;
case 28:
model.NamaPenerima = words[i];
break;
case 29:
model.AlamatPenerima = words[i];
break;
case 30:
model.BPKBNumber = words[i];
break;
case 31:
model.RemarksBPKB = words[i];
break;
case 32:
var lastDate = words[i].Remove(words[i].IndexOf('}')).Trim();
if (lastDate.Length == 8)
{
//if (lastDate.Substring(0, 2) == "20")
//{
var dateFormat = Convert.ToDateTime(date.Substring(0, 4) + "-" + date.Substring(4, 2) + "-" + date.Substring(6, 2), new CultureInfo("id-ID"));
model.RevisiBPKB = dateFormat;
//}
}
break;
default:
break;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
private S02002ViewModel SplitStringHSS02002(string stringHS)
{
S02002ViewModel model = new S02002ViewModel();
try
{
//TODO 21-08-2013:VALIDASI SUBSTRING
string[] words = stringHS.Split('|');
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.StatusPOSERA = words[i];
break;
case 5:
model.RejectRevisedPOSERA = words[i];
break;
case 6:
model.DocumentNo = words[i];
break;
case 7:
model.AIMaterialNumber = words[i];
break;
case 8:
model.SERAMaterialNumber = words[i];
break;
case 9:
model.SERAMaterialDescription = words[i];
break;
case 10:
model.AIColor = words[i];
break;
case 11:
model.SERAColor = words[i];
break;
case 12:
var lastWord = words[i].Remove(words[i].IndexOf('}')).Trim();
model.QuotationNo = lastWord;
break;
default:
break;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
