/// <summary>
/// This method is used to get data and insert data in database for vehicle
/// </summary>
/// <param name="BatchId"></param>
/// <param name="User"></param>
/// <returns></returns>
public bool VehicleImportTransactionProcess(int batchId, string user)
{
bool isSucceeded = false;
var query = string.Empty;
try
{
List <VehicleLocationImportTransactionProp> vehicleLocationImportTransactionProp = new List <VehicleLocationImportTransactionProp>();
using (PortStorageEntities objAppWorksEntities = new PortStorageEntities())
{
VINDecodeList lstVINDecodeList = new VINDecodeList();
//If jst(lSessionHost,'U')='DAIDB'
// Sta: exec DataHub.dbo.DAIYMSP_GetStorageReceiptData
// Else If jst(lSessionHost,'U')='DAIDBVPC'
// Sta: exec DataHUBVPC.dbo.DAIYMSP_GetStorageReceiptData
// Else
// Sta: exec DataHubDev.dbo.DAIYMSP_GetStorageReceiptData
// End If
// Get current database name
string currentDatabaseName = objAppWorksEntities.Database.Connection.Database;
//if (currentDatabaseName.Equals("psdb", StringComparison.OrdinalIgnoreCase))
//{
query = SqlConstants.VEHICLE_LOCATION_IMPORT_TRANSACTION;
//}
var result = objAppWorksEntities.Database.SqlQuery <VehicleLocationImportTransactionProp>(query).ToList();
if (result != null && result.Count > 0)
{
PortStorageVehiclesImport portStorageVehiclesImport = new PortStorageVehiclesImport();
foreach (var item in result)
{
VehicleLocationImportTransactionProp obj = new VehicleLocationImportTransactionProp();
obj.VinNumberAndVinKey = item.VinNumberAndVinKey;
obj.Row = item.Row;
obj.Bay = item.Bay;
obj.DealerCode = item.DealerCode;
obj.ColorCode = item.ColorCode;
obj.DamageCode = item.DamageCode;
obj.HandheldActionDate = item.HandheldActionDate;
obj.UserCode = item.UserCode;
vehicleLocationImportTransactionProp.Add(obj);
obj = null;
}
if (vehicleLocationImportTransactionProp.Count > 0)
{
foreach (var val in vehicleLocationImportTransactionProp)
{
if (val.VinNumberAndVinKey.Length > 17)// check validation
{
if ((val.VinNumberAndVinKey.Length == 18) && (val.VinNumberAndVinKey.Substring(0, 1).Equals("I")))
{
val.VinNumberAndVinKey = val.VinNumberAndVinKey.Remove(0, 1);
}
else
{
val.VinNumberAndVinKey = val.VinNumberAndVinKey.Substring(0, 17);
}
}
lstVINDecodeList = GetDataByDecodeVIN(val.VinNumberAndVinKey);
if (lstVINDecodeList != null)
{
portStorageVehiclesImport.VehicleYear = lstVINDecodeList.VehicleYear;
portStorageVehiclesImport.Make = lstVINDecodeList.Make;
portStorageVehiclesImport.Model = lstVINDecodeList.Model;
portStorageVehiclesImport.Bodystyle = lstVINDecodeList.Bodystyle;
portStorageVehiclesImport.VehicleLength = lstVINDecodeList.VehicleLength;
portStorageVehiclesImport.VehicleWidth = lstVINDecodeList.VehicleWidth;
portStorageVehiclesImport.VehicleHeight = lstVINDecodeList.VehicleHeight;
}
else
{
portStorageVehiclesImport.VehicleYear = string.Empty;
portStorageVehiclesImport.Make = string.Empty;
portStorageVehiclesImport.Model = string.Empty;
portStorageVehiclesImport.Bodystyle = string.Empty;
portStorageVehiclesImport.VehicleLength = string.Empty;
portStorageVehiclesImport.VehicleWidth = string.Empty;
portStorageVehiclesImport.VehicleHeight = string.Empty;
}
portStorageVehiclesImport.VINDecodedInd = 0;
portStorageVehiclesImport.BatchID = batchId;
portStorageVehiclesImport.DateIn = val.HandheldActionDate.Value.ToString("MM/dd/yyyy");
portStorageVehiclesImport.DealerCode = val.DealerCode;
portStorageVehiclesImport.VIN = val.VinNumberAndVinKey;
portStorageVehiclesImport.Color = val.ColorCode;
//portStorageVehiclesImport.DamageCodeList = val.DealerCode;
portStorageVehiclesImport.DamageCodeList = val.DamageCode;
portStorageVehiclesImport.Location = (val.Row + " " + val.Bay).Trim();
portStorageVehiclesImport.ImportedInd = 0;
portStorageVehiclesImport.CreationDate = DateTime.Now;
portStorageVehiclesImport.CreatedBy = user;
portStorageVehiclesImport.RecordStatus = "Import Pending";
objAppWorksEntities.PortStorageVehiclesImports.Add(portStorageVehiclesImport); /// Insert the Record in Respected Table.
objAppWorksEntities.SaveChanges();
isSucceeded = true;
}
}
}
else
{
isSucceeded = true;
}
}
}
catch (Exception ex)
{
var message = ex.Message;
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
return(isSucceeded);
}
/// <summary>
/// This method is used to get data and insert data in database
/// </summary>
/// <param name="BatchId"></param>
/// <param name="User"></param>
/// <returns></returns>
public bool LocationImportTransactionProcess(int BatchId, string User)
{
bool Result = true;
try
{
List <VehicleLocationImportTransactionProp> vehicleLocationImportTransactionProp = new List <VehicleLocationImportTransactionProp>();
// creating the object of PortStorageEntities Database
using (PortStorageEntities objAppWorksEntities = new PortStorageEntities())
{
string CurruntDatabaseName = objAppWorksEntities.Database.Connection.Database; // Get currunt database name
var result = objAppWorksEntities.spGetDataStoragePhyDataImportLocation(CurruntDatabaseName).ToList();
if (result != null && result.Count > 0)
{
PortStorageVehicleLocationImport portStorageVehicleLocationImport = new PortStorageVehicleLocationImport();
foreach (var item in result)
{
VehicleLocationImportTransactionProp obj = new VehicleLocationImportTransactionProp();
obj.VinNumberAndVinKey = item.VINNumberAndVINKey;
obj.Row = item.Row;
obj.Bay = item.Bay;
obj.ByRowFlag = item.ByRowFlg;
obj.HandheldActionDate = item.HandheldActionDate;
obj.UserCode = item.UserCode;
vehicleLocationImportTransactionProp.Add(obj);
obj = null;
}
if (vehicleLocationImportTransactionProp.Count > 0)
{
foreach (var val in vehicleLocationImportTransactionProp)
{
// If len(iSqlRow.VIN)>17
//If (len(iSqlRow.VIN)=18)&(left(iSqlRow.VIN,1)='I')
//Calculate iSqlRow.VIN as right(iSqlRow.VIN,17)
//Else
//Calculate iSqlRow.VIN as left(iSqlRow.VIN,17)
if (val.VinNumberAndVinKey.Length > 17)
{
if ((val.VinNumberAndVinKey.Length == 18) && (val.VinNumberAndVinKey.Substring(0, 1).Equals("I")))
{
val.VinNumberAndVinKey = val.VinNumberAndVinKey.Remove(0, 1);
}
else
{
val.VinNumberAndVinKey = val.VinNumberAndVinKey.Substring(0, 17);
}
}
portStorageVehicleLocationImport.BatchID = BatchId;
portStorageVehicleLocationImport.VIN = val.VinNumberAndVinKey;
portStorageVehicleLocationImport.Location = (val.Row + " " + val.Bay).Trim();
portStorageVehicleLocationImport.ImportedInd = 0;
portStorageVehicleLocationImport.CreationDate = DateTime.Now;
portStorageVehicleLocationImport.CreatedBy = User;
portStorageVehicleLocationImport.RecordStatus = "Import Pending";
objAppWorksEntities.PortStorageVehicleLocationImports.Add(portStorageVehicleLocationImport); /// Insert the Record in Respected Table.
objAppWorksEntities.SaveChanges(); /// Check the Chenges in Table After Record Insertion.
Result = false;
}
}
}
}
}
catch (Exception)
{
throw;
}
finally
{
CommonDAL.logger.LogInfo(typeof(string), string.Format(CultureInfo.InvariantCulture, "End {2} function ::{0} {1}.", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), MethodBase.GetCurrentMethod().Name));
}
return(Result);
}
