public IList<UsedCarsInfoRV> FindCarID(string CarID)
{
///objUsedCars.Decalaring CarsInfo division object collection
IList<UsedCarsInfoRV> UsedCarsIList = new List<UsedCarsInfoRV>();
string spNameString = string.Empty;
//objUsedCars.Setting Connection
//objUsedCars.Global.INSTANCE_NAME = strCurrentConn;
IDataReader UsedCarsDataReader = null;
//objUsedCars.Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME2);
//objUsedCars.Assign stored procedure name
spNameString = "[USP_FindCarID]";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@CarID", DbType.String, CarID);
//objUsedCars.Executing stored procedure
UsedCarsDataReader = dbDatabase.ExecuteReader(dbCommand);
// DataSet ds =dbDatabase.ExecuteDataSet(dbCommand);
while (UsedCarsDataReader.Read())
{
// objUsedCars.Assign values to the CarsInfo object list
UsedCarsInfoRV ObjCarsInfo_Info = new UsedCarsInfoRV();
AssignCarsInfoList(UsedCarsDataReader, ObjCarsInfo_Info);
UsedCarsIList.Add(ObjCarsInfo_Info);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
finally
{
UsedCarsDataReader.Close();
}
return UsedCarsIList;
}
private void AssignCarsInfoList(IDataReader UsedCarsDataReader, UsedCarsInfoRV objUsedCars)
{
try
{
objUsedCars.PostingID = Convert.ToInt32(UsedCarsDataReader["PostingID"].ToString());
objUsedCars.Carid = Convert.ToInt32(UsedCarsDataReader["Carid"].ToString());
objUsedCars.SellerType = UsedCarsDataReader["SellerType"].ToString();
objUsedCars.SellerID = Convert.ToInt32(UsedCarsDataReader["SellerID"].ToString());
objUsedCars.DateOfPosting = Convert.ToDateTime(UsedCarsDataReader["DateOfPosting"].ToString());
objUsedCars.ExpirtyDate = UsedCarsDataReader["ExpirtyDate"].ToString() == "" ? System.DateTime.Now : Convert.ToDateTime(UsedCarsDataReader["ExpirtyDate"].ToString());
objUsedCars.PackageID = UsedCarsDataReader["PackageID"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["PackageID"].ToString());
objUsedCars.PaymentID = UsedCarsDataReader["PaymentID"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["PaymentID"].ToString());
objUsedCars.IsActive = UsedCarsDataReader["IsActive"].ToString() == "" ? true : Convert.ToBoolean(UsedCarsDataReader["IsActive"].ToString());
objUsedCars.InternalreviewID = UsedCarsDataReader["InternalreviewID"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["InternalreviewID"].ToString());
objUsedCars.CancelledBy = UsedCarsDataReader["CancelledBy"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["CancelledBy"].ToString());
objUsedCars.CancelledReason = UsedCarsDataReader["CancelledReason"].ToString();
objUsedCars.CancelledDate = UsedCarsDataReader["CancelledDate"].ToString() == "" ? System.DateTime.Now : Convert.ToDateTime(UsedCarsDataReader["CancelledDate"].ToString());
objUsedCars.Zipcode = UsedCarsDataReader["Zipcode"].ToString();
objUsedCars.Uid = UsedCarsDataReader["Uid"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["Uid"].ToString());
objUsedCars.SellerName = UsedCarsDataReader["SellerName"].ToString() == "" ? "Emp" : UsedCarsDataReader["SellerName"].ToString();
objUsedCars.Address1 = UsedCarsDataReader["Address1"].ToString() == "" ? "Emp" : UsedCarsDataReader["Address1"].ToString();
objUsedCars.Address2 = UsedCarsDataReader["Address2"].ToString() == "" ? "Emp" : UsedCarsDataReader["Address2"].ToString();
objUsedCars.City = UsedCarsDataReader["City"].ToString() == "" ? "Emp" : UsedCarsDataReader["City"].ToString();
objUsedCars.State = UsedCarsDataReader["State"].ToString();
objUsedCars.Zip = UsedCarsDataReader["Zip"].ToString();
objUsedCars.Country = UsedCarsDataReader["Country"].ToString() == "1" ? "USA" : UsedCarsDataReader["Country"].ToString();
objUsedCars.Phone = UsedCarsDataReader["Phone"].ToString();
objUsedCars.AltPhone = UsedCarsDataReader["AltPhone"].ToString();
objUsedCars.Fax = UsedCarsDataReader["Fax"].ToString();
objUsedCars.Email = UsedCarsDataReader["Email"].ToString() == "" ? "Emp" : UsedCarsDataReader["Email"].ToString();
objUsedCars.AltEmail = UsedCarsDataReader["AltEmail"].ToString() == "" ? "Emp" : UsedCarsDataReader["Email"].ToString();
objUsedCars.NotesForBuyers = UsedCarsDataReader["NotesForBuyers"].ToString();
objUsedCars.Model = UsedCarsDataReader["model"].ToString();
objUsedCars.Make = UsedCarsDataReader["make"].ToString();
objUsedCars.YearOfMake = UsedCarsDataReader["yearOfMake"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["yearOfMake"].ToString());
objUsedCars.Mileage = UsedCarsDataReader["mileage"].ToString() == "" ? 0 : Convert.ToInt32(Convert.ToDouble(UsedCarsDataReader["mileage"].ToString()));
objUsedCars.MakeID = UsedCarsDataReader["makeID"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["makeID"].ToString());
objUsedCars.MakeModelID = UsedCarsDataReader["makeModelID"].ToString() == "" ? 0 : Convert.ToInt32(UsedCarsDataReader["makeModelID"].ToString());
objUsedCars.Price = UsedCarsDataReader["price"].ToString() == "" ? 0.00 : Convert.ToDouble(UsedCarsDataReader["price"].ToString());
objUsedCars.Description = UsedCarsDataReader["description"].ToString() == "" ? "Emp" : UsedCarsDataReader["description"].ToString();
objUsedCars.Title = UsedCarsDataReader["Title"].ToString() == "" ? "Emp" : UsedCarsDataReader["Title"].ToString();
objUsedCars.Bodytype = UsedCarsDataReader["bodytype"].ToString();
objUsedCars.BodytypeID = Convert.ToInt32(UsedCarsDataReader["BodytypeID"].ToString() == "" ? "0" : UsedCarsDataReader["BodytypeID"].ToString().ToString());
objUsedCars.FueltypeId = Convert.ToInt32(UsedCarsDataReader["FueltypeID"].ToString());
objUsedCars.Fueltype = UsedCarsDataReader["Fueltype"].ToString();
objUsedCars.ExteriorColor = UsedCarsDataReader["exteriorColor"].ToString() == "" ? "Emp" : UsedCarsDataReader["exteriorColor"].ToString();
objUsedCars.NumberOfSeats = UsedCarsDataReader["numberOfSeats"].ToString() == "" ? "Emp" : UsedCarsDataReader["numberOfSeats"].ToString();
objUsedCars.NumberOfDoors = UsedCarsDataReader["numberOfDoors"].ToString() == "" ? "Emp" : UsedCarsDataReader["numberOfDoors"].ToString();
objUsedCars.NumberOfCylinder = UsedCarsDataReader["numberOfCylinder"].ToString() == "" ? "Emp" : UsedCarsDataReader["numberOfCylinder"].ToString();
objUsedCars.Transmission = UsedCarsDataReader["Transmission"].ToString() == "" ? "Emp" : UsedCarsDataReader["Transmission"].ToString();
objUsedCars.InteriorColor = UsedCarsDataReader["interiorColor"].ToString() == "" ? "Emp" : UsedCarsDataReader["interiorColor"].ToString();
objUsedCars.UserFeedback = UsedCarsDataReader["UserFeedback"].ToString();
objUsedCars.VIN = UsedCarsDataReader["VIN"].ToString() == "" ? "Emp" : UsedCarsDataReader["VIN"].ToString();
objUsedCars.PIC0 = UsedCarsDataReader["PIC0"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC0"].ToString();
objUsedCars.PIC1 = UsedCarsDataReader["PIC1"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC1"].ToString();
objUsedCars.PIC2 = UsedCarsDataReader["PIC2"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC2"].ToString();
objUsedCars.PIC3 = UsedCarsDataReader["PIC3"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC3"].ToString();
objUsedCars.PIC4 = UsedCarsDataReader["PIC4"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC4"].ToString();
objUsedCars.PIC5 = UsedCarsDataReader["PIC5"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC5"].ToString();
objUsedCars.PIC6 = UsedCarsDataReader["PIC6"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC6"].ToString();
objUsedCars.PIC7 = UsedCarsDataReader["PIC7"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC7"].ToString();
objUsedCars.PIC8 = UsedCarsDataReader["PIC8"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC8"].ToString();
objUsedCars.PIC9 = UsedCarsDataReader["PIC9"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC9"].ToString();
objUsedCars.PIC10 = UsedCarsDataReader["PIC10"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC10"].ToString();
objUsedCars.PICLOC0 = UsedCarsDataReader["PICLOC0"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC0"].ToString();
objUsedCars.PICLOC1 = UsedCarsDataReader["PICLOC1"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC1"].ToString();
objUsedCars.PICLOC2 = UsedCarsDataReader["PICLOC2"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC2"].ToString();
objUsedCars.PICLOC3 = UsedCarsDataReader["PICLOC3"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC3"].ToString();
objUsedCars.PICLOC4 = UsedCarsDataReader["PICLOC4"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC4"].ToString();
objUsedCars.PICLOC5 = UsedCarsDataReader["PICLOC5"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC5"].ToString();
objUsedCars.PICLOC6 = UsedCarsDataReader["PICLOC6"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC6"].ToString();
objUsedCars.PICLOC7 = UsedCarsDataReader["PICLOC7"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC7"].ToString();
objUsedCars.PICLOC8 = UsedCarsDataReader["PICLOC8"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC8"].ToString();
objUsedCars.PICLOC9 = UsedCarsDataReader["PICLOC9"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC9"].ToString();
objUsedCars.PICLOC10 = UsedCarsDataReader["PICLOC10"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC10"].ToString();
objUsedCars.ConditionDescription = UsedCarsDataReader["ConditionDescription"].ToString() == "" ? "Emp" : UsedCarsDataReader["ConditionDescription"].ToString();
objUsedCars.DriveTrain = UsedCarsDataReader["DriveTrain"].ToString() == "" ? "Emp" : UsedCarsDataReader["DriveTrain"].ToString();
objUsedCars.TypeName = UsedCarsDataReader["TypeName"].ToString() == "" ? "Emp" : UsedCarsDataReader["TypeName"].ToString();
objUsedCars.TypeID = UsedCarsDataReader["TypeID"].ToString() == "" ? "Emp" : UsedCarsDataReader["TypeID"].ToString();
objUsedCars.AirConditioners = UsedCarsDataReader["AirConditioners"].ToString() == "" ? "Emp" : UsedCarsDataReader["AirConditioners"].ToString(); ;
objUsedCars.Length = UsedCarsDataReader["Length"].ToString() == "" ? "Emp" : UsedCarsDataReader["Length"].ToString(); ;
objUsedCars.WaterCapacity = UsedCarsDataReader["WaterCapacity"].ToString() == "" ? "Emp" : UsedCarsDataReader["WaterCapacity"].ToString(); ;
objUsedCars.Towing_Capacity = UsedCarsDataReader["Towing_Capacity"].ToString() == "" ? "Emp" : UsedCarsDataReader["Towing_Capacity"].ToString(); ;
objUsedCars.Dry_Weight = UsedCarsDataReader["Dry_Weight"].ToString() == "" ? "Emp" : UsedCarsDataReader["Dry_Weight"].ToString(); ;
objUsedCars.SleepingCapacity = UsedCarsDataReader["SleepingCapacity"].ToString() == "" ? "Emp" : UsedCarsDataReader["SleepingCapacity"].ToString(); ;
objUsedCars.SlideOuts = UsedCarsDataReader["SlideOuts"].ToString() == "" ? "Emp" : UsedCarsDataReader["SlideOuts"].ToString(); ;
objUsedCars.EngineManufacturer = UsedCarsDataReader["EngineManufacturer"].ToString() == "" ? "Emp" : UsedCarsDataReader["EngineManufacturer"].ToString();
objUsedCars.EngineType = UsedCarsDataReader["EngineType"].ToString() == "" ? "Emp" : UsedCarsDataReader["EngineType"].ToString();
objUsedCars.RowNumber = UsedCarsDataReader["RowNumber"].ToString() == "" ? "Emp" : UsedCarsDataReader["RowNumber"].ToString();
objUsedCars.CarUniqueID = Convert.ToInt64(UsedCarsDataReader["CarUniqueID"].ToString());
objUsedCars.TotalRecords = UsedCarsDataReader["TotalRecords"].ToString() == "" ? "Emp" : UsedCarsDataReader["TotalRecords"].ToString();
objUsedCars.PageCount = UsedCarsDataReader["PageCount"].ToString() == "" ? "Emp" : UsedCarsDataReader["PageCount"].ToString();
objUsedCars.PIC11 = UsedCarsDataReader["PIC11"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC11"].ToString();
objUsedCars.PIC12 = UsedCarsDataReader["PIC12"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC12"].ToString();
objUsedCars.PIC13 = UsedCarsDataReader["PIC13"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC13"].ToString();
objUsedCars.PIC14 = UsedCarsDataReader["PIC14"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC14"].ToString();
objUsedCars.PIC15 = UsedCarsDataReader["PIC15"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC15"].ToString();
objUsedCars.PIC16 = UsedCarsDataReader["PIC16"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC16"].ToString();
objUsedCars.PIC17 = UsedCarsDataReader["PIC17"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC17"].ToString();
objUsedCars.PIC18 = UsedCarsDataReader["PIC18"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC18"].ToString();
objUsedCars.PIC19 = UsedCarsDataReader["PIC19"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC19"].ToString();
objUsedCars.PIC20 = UsedCarsDataReader["PIC20"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC20"].ToString();
objUsedCars.PICLOC11 = UsedCarsDataReader["PICLOC11"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC11"].ToString();
objUsedCars.PICLOC12 = UsedCarsDataReader["PICLOC12"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC12"].ToString();
objUsedCars.PICLOC13 = UsedCarsDataReader["PICLOC13"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC13"].ToString();
objUsedCars.PICLOC14 = UsedCarsDataReader["PICLOC14"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC14"].ToString();
objUsedCars.PICLOC15 = UsedCarsDataReader["PICLOC15"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC15"].ToString();
objUsedCars.PICLOC16 = UsedCarsDataReader["PICLOC16"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC16"].ToString();
objUsedCars.PICLOC17 = UsedCarsDataReader["PICLOC17"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC17"].ToString();
objUsedCars.PICLOC18 = UsedCarsDataReader["PICLOC18"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC18"].ToString();
objUsedCars.PICLOC19 = UsedCarsDataReader["PICLOC19"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC19"].ToString();
objUsedCars.PICLOC20 = UsedCarsDataReader["PICLOC20"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC20"].ToString();
objUsedCars.PIC21 = UsedCarsDataReader["PIC21"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC21"].ToString();
objUsedCars.PIC22 = UsedCarsDataReader["PIC22"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC22"].ToString();
objUsedCars.PIC23 = UsedCarsDataReader["PIC23"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC23"].ToString();
objUsedCars.PIC24 = UsedCarsDataReader["PIC24"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC24"].ToString();
objUsedCars.PIC25 = UsedCarsDataReader["PIC25"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC25"].ToString();
objUsedCars.PIC26 = UsedCarsDataReader["PIC26"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC26"].ToString();
objUsedCars.PIC27 = UsedCarsDataReader["PIC27"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC27"].ToString();
objUsedCars.PIC28 = UsedCarsDataReader["PIC28"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC28"].ToString();
objUsedCars.PIC29 = UsedCarsDataReader["PIC29"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC29"].ToString();
objUsedCars.PIC30 = UsedCarsDataReader["PIC30"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC30"].ToString();
objUsedCars.PICLOC21 = UsedCarsDataReader["PICLOC21"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC21"].ToString();
objUsedCars.PICLOC22 = UsedCarsDataReader["PICLOC22"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC22"].ToString();
objUsedCars.PICLOC23 = UsedCarsDataReader["PICLOC23"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC23"].ToString();
objUsedCars.PICLOC24 = UsedCarsDataReader["PICLOC24"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC24"].ToString();
objUsedCars.PICLOC25 = UsedCarsDataReader["PICLOC25"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC25"].ToString();
objUsedCars.PICLOC26 = UsedCarsDataReader["PICLOC26"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC26"].ToString();
objUsedCars.PICLOC27 = UsedCarsDataReader["PICLOC27"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC27"].ToString();
objUsedCars.PICLOC28 = UsedCarsDataReader["PICLOC28"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC28"].ToString();
objUsedCars.PICLOC29 = UsedCarsDataReader["PICLOC29"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC29"].ToString();
objUsedCars.PICLOC30 = UsedCarsDataReader["PICLOC30"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC30"].ToString();
objUsedCars.PIC31 = UsedCarsDataReader["PIC31"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC31"].ToString();
objUsedCars.PIC32 = UsedCarsDataReader["PIC32"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC32"].ToString();
objUsedCars.PIC33 = UsedCarsDataReader["PIC33"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC33"].ToString();
objUsedCars.PIC34 = UsedCarsDataReader["PIC34"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC34"].ToString();
objUsedCars.PIC35 = UsedCarsDataReader["PIC35"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC35"].ToString();
objUsedCars.PIC36 = UsedCarsDataReader["PIC36"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC36"].ToString();
objUsedCars.PIC37 = UsedCarsDataReader["PIC37"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC37"].ToString();
objUsedCars.PIC38 = UsedCarsDataReader["PIC38"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC38"].ToString();
objUsedCars.PIC39 = UsedCarsDataReader["PIC39"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC39"].ToString();
objUsedCars.PIC40 = UsedCarsDataReader["PIC40"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC40"].ToString();
objUsedCars.PICLOC31 = UsedCarsDataReader["PICLOC31"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC31"].ToString();
objUsedCars.PICLOC32 = UsedCarsDataReader["PICLOC32"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC32"].ToString();
objUsedCars.PICLOC33 = UsedCarsDataReader["PICLOC33"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC33"].ToString();
objUsedCars.PICLOC34 = UsedCarsDataReader["PICLOC34"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC34"].ToString();
objUsedCars.PICLOC35 = UsedCarsDataReader["PICLOC35"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC35"].ToString();
objUsedCars.PICLOC36 = UsedCarsDataReader["PICLOC36"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC36"].ToString();
objUsedCars.PICLOC37 = UsedCarsDataReader["PICLOC37"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC37"].ToString();
objUsedCars.PICLOC38 = UsedCarsDataReader["PICLOC38"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC38"].ToString();
objUsedCars.PICLOC39 = UsedCarsDataReader["PICLOC39"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC39"].ToString();
objUsedCars.PICLOC40 = UsedCarsDataReader["PICLOC40"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC40"].ToString();
objUsedCars.PIC41 = UsedCarsDataReader["PIC41"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC41"].ToString();
objUsedCars.PIC42 = UsedCarsDataReader["PIC42"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC42"].ToString();
objUsedCars.PIC43 = UsedCarsDataReader["PIC43"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC43"].ToString();
objUsedCars.PIC44 = UsedCarsDataReader["PIC44"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC44"].ToString();
objUsedCars.PIC45 = UsedCarsDataReader["PIC45"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC45"].ToString();
objUsedCars.PIC46 = UsedCarsDataReader["PIC46"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC46"].ToString();
objUsedCars.PIC47 = UsedCarsDataReader["PIC47"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC47"].ToString();
objUsedCars.PIC48 = UsedCarsDataReader["PIC48"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC48"].ToString();
objUsedCars.PIC49 = UsedCarsDataReader["PIC49"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC49"].ToString();
objUsedCars.PIC50 = UsedCarsDataReader["PIC50"].ToString() == "" ? "Emp" : UsedCarsDataReader["PIC50"].ToString();
objUsedCars.PICLOC41 = UsedCarsDataReader["PICLOC41"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC41"].ToString();
objUsedCars.PICLOC42 = UsedCarsDataReader["PICLOC42"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC42"].ToString();
objUsedCars.PICLOC43 = UsedCarsDataReader["PICLOC43"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC43"].ToString();
objUsedCars.PICLOC44 = UsedCarsDataReader["PICLOC44"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC44"].ToString();
objUsedCars.PICLOC45 = UsedCarsDataReader["PICLOC45"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC45"].ToString();
objUsedCars.PICLOC46 = UsedCarsDataReader["PICLOC46"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC46"].ToString();
objUsedCars.PICLOC47 = UsedCarsDataReader["PICLOC47"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC47"].ToString();
objUsedCars.PICLOC48 = UsedCarsDataReader["PICLOC48"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC48"].ToString();
objUsedCars.PICLOC49 = UsedCarsDataReader["PICLOC49"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC49"].ToString();
objUsedCars.PICLOC50 = UsedCarsDataReader["PICLOC50"].ToString() == "" ? "Emp" : UsedCarsDataReader["PICLOC50"].ToString();
//objUsedCars.pic0 = UsedCarsDataReader["pic0"].ToString();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
}
}