// [HideInInspector] public GameObject car;
// Use this for initialization
void Awake()
{
secondCanvas = GameObject.Find("SecondCanvas");
fireBackground = GameObject.Find("FireBackground");
fireStart = GameObject.Find("FireStart");
garage = GameObject.FindObjectOfType <Garage>();
taskMenu = GameObject.FindObjectOfType <TaskMenu>();
kaController = GameObject.FindObjectOfType <KAController>();
waitBackground = GameObject.FindObjectOfType <WaitBackground>();
mainScreen = GameObject.FindObjectOfType <MainScreen>();
bg = GameObject.Find("BG");
carsInfo = GetComponent <CarsInfo>();
filling = GameObject.FindObjectOfType <Filling>();
carChanger = GameObject.FindObjectOfType <CarChanger>();
dustSmall = GameObject.Find("DustSmall");
windowWarning = GameObject.FindObjectOfType <WindowWarning>();
windowConfirmation = GameObject.FindObjectOfType <WindowConfirmation>();
mainBonus = GetComponent <MainBonus>();
dailyEvents = GetComponent <DailyEvents>();
moneyBar = GameObject.FindObjectOfType <MoneyBar>();
boosterMenu = GameObject.FindObjectOfType <BoosterMenu>();
dailyGiftMenu = GameObject.FindObjectOfType <DailyGiftMenu>();
backMenuButton = GameObject.FindObjectOfType <BackMenuButton>();
/*
* car = garage.transform.Find("Car").gameObject;
* if (car == null)
* CreateCar(); */
}
public void UpdateCar()
{
CarParametres carParametres = CarsInfo.GetCarInfo(StaticValues.NumCar);
if (library.car != null)
{
Destroy(library.car);
}
GameObject GO;
GameObject carPref;
if (carParametres == null)
{
carPref = Resources.Load("Prefabs/Cars/HemiFox") as GameObject;
}
else
{
carPref = Resources.Load("Prefabs/Cars/" + carParametres.GetName()) as GameObject;
}
carPref.transform.position = new Vector3(0, 1000, 0);
GO = Instantiate(carPref);
library.car = GO;
}
public static void DeleteRecord(string id)
{
try
{
var collection = db.GetCollection <CarsInfo>("cars");
var filter = Builders <CarsInfo> .Filter.Eq("_id", ObjectId.Parse(id));
var document = collection.Find(new BsonDocument()).ToList();
var carToUpdate = document.Where(x => x._id == ObjectId.Parse(id)).FirstOrDefault();
CarsInfo carsinfo = new CarsInfo();
carsinfo._id = ObjectId.Parse(id);
carsinfo.Car = carToUpdate.Car;
carsinfo.CarModel = carToUpdate.CarModel;
carsinfo.ProductionYear = carToUpdate.ProductionYear;
carsinfo.isDeleted = true;
carsinfo.DeletedDate = DateTime.Now;
collection.ReplaceOne(filter, carsinfo);
}
catch (Exception ex)
{
var message = ex.Message;
}
}
public DataSet USP_SaveDealerRequest(CarsInfo.DealersInfo objDealersInfo)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveDealerRequest";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@DealerName", System.Data.DbType.String, objDealersInfo.DealerName);
dbDatabase.AddInParameter(dbCommand, "@DealerPhone", System.Data.DbType.String, objDealersInfo.DealerPhone);
dbDatabase.AddInParameter(dbCommand, "@DealerEmail", System.Data.DbType.String, objDealersInfo.DealerEmail);
dbDatabase.AddInParameter(dbCommand, "@DealerAddress", System.Data.DbType.String, objDealersInfo.DealerAddress);
dbDatabase.AddInParameter(dbCommand, "@DealerCity", System.Data.DbType.String, objDealersInfo.DealerCity);
dbDatabase.AddInParameter(dbCommand, "@DealerShipName", System.Data.DbType.String, objDealersInfo.DealerShipName);
dbDatabase.AddInParameter(dbCommand, "@DealerNotes", System.Data.DbType.String, objDealersInfo.DealerNotes);
dbDatabase.AddInParameter(dbCommand, "@DealerZip", System.Data.DbType.String, objDealersInfo.DealerZip);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return dsCars;
}
catch (Exception ex)
{
throw ex;
}
}
// [HideInInspector] public GameObject car;
// Use this for initialization
void Awake()
{
secondCanvas = GameObject.Find("SecondCanvas");
fireBackground = GameObject.Find("FireBackground");
fireStart = GameObject.Find("FireStart");
garage = GameObject.FindObjectOfType<Garage>();
taskMenu = GameObject.FindObjectOfType<TaskMenu>();
kaController = GameObject.FindObjectOfType<KAController>();
waitBackground = GameObject.FindObjectOfType<WaitBackground>();
mainScreen = GameObject.FindObjectOfType<MainScreen>();
bg = GameObject.Find("BG");
carsInfo = GetComponent<CarsInfo>();
filling = GameObject.FindObjectOfType<Filling>();
carChanger = GameObject.FindObjectOfType<CarChanger>();
dustSmall = GameObject.Find("DustSmall");
windowWarning = GameObject.FindObjectOfType<WindowWarning>();
windowConfirmation = GameObject.FindObjectOfType<WindowConfirmation>();
mainBonus = GetComponent<MainBonus>();
dailyEvents = GetComponent<DailyEvents>();
moneyBar = GameObject.FindObjectOfType<MoneyBar>();
boosterMenu = GameObject.FindObjectOfType<BoosterMenu>();
dailyGiftMenu = GameObject.FindObjectOfType<DailyGiftMenu>();
backMenuButton = GameObject.FindObjectOfType<BackMenuButton>();
/*
car = garage.transform.Find("Car").gameObject;
if (car == null)
CreateCar(); */
}
public static List <CarsInfo> GetCars()
{
string sql = "SELECT c.CarID,c.License,c.Brand,c.Color,t.CarType,c.UserID,u.UserName,u.UserPhone,u.Usersfz,u.UserSex FROM t_Cars c,CarType t,t_Users u WHERE c.CarTypeID = t.CarTypeID and u.UserID = c.UserID";
List <CarsInfo> list = new List <CarsInfo>();
using (MySqlDataReader dr = DBHelper.GetReader(sql))
{
while (dr.Read())
{
CarsInfo info = new CarsInfo();
info.CarID = Convert.ToInt32(dr["CarID"]);
info.License = Convert.ToString(dr["License"]);
info.Brand = Convert.ToString(dr["Brand"]);
info.Color = Convert.ToString(dr["Color"]);
info.CarType = Convert.ToString(dr["CarType"]);
info.UserID = Convert.ToInt32(dr["UserID"]);
info.UserName = Convert.ToString(dr["UserName"]);
info.UserPhone = Convert.ToString(dr["UserPhone"]);
info.Usersfz = Convert.ToString(dr["Usersfz"]);
info.UserSex = Convert.ToString(dr["UserSex"]);
list.Add(info);
}
}
return(list);
}
public JsonResult RemoveCarFromParking(int id, string slotType)
{
CarsInfo carInfo = _carRepository.RemoveCarFromParking(id);
carInfo.ParkingInfo = _parkingInfoRepository.GetTotalCountOfParkingTypeSlots();
return(Json(carInfo, JsonRequestBehavior.AllowGet));
//return carInfo;
}
public async Task <IActionResult> PutCarsInfo(string id, CarsInfo carsInfo)
{
if (id != carsInfo.Id)
{
return(BadRequest());
}
_bookingRepository.PutCar(id, carsInfo);
return(NoContent());
}
IEnumerator CreateCar(int carNum)
{
CarParametres carParametres = CarsInfo.GetCarInfo(carNum);
this.carParametres = carParametres;
StaticValues.NumCar = carNum;
libraryMenu.filling.UpdateAllPower(
carParametres.GetParam(1),
carParametres.GetParam(2),
carParametres.GetParam(3),
PreferencesSaver.GetCarUpgrade(carNum, 1),
PreferencesSaver.GetCarUpgrade(carNum, 2),
PreferencesSaver.GetCarUpgrade(carNum, 3));
bool isOpen = PreferencesSaver.CarIsOpen(carNum);
if (!isOpen)
{
if (!carParametres.IsBonus())
{
libraryMenu.garage.ShowBuyButton(carParametres.GetCost());
}
else
{
libraryMenu.garage.ShowEnterVkButton();
}
libraryMenu.garage.HidePlayButton();
libraryMenu.garage.HideSecondPower();
}
else
{
libraryMenu.garage.HideBuyAndVkButton();
libraryMenu.garage.ShowPlayButton();
libraryMenu.garage.ShowSecondPower();
}
ResourceRequest rr = Resources.LoadAsync("Prefabs/UI/Cars/" + carParametres.GetName());
yield return(rr);
GameObject carObject = Instantiate(rr.asset as GameObject);
carObject.transform.SetParent(car.transform, false);
carObject.transform.localPosition = new Vector3(0, 0, 0);
carObject.transform.localRotation = Quaternion.Euler(0, 0, 0);
carObject.transform.localScale = new Vector3(1, 1, 1);
}
public ActionResult Index()
{
CarsInfo carsInfo = new CarsInfo
{
ParkingInfo = _parkingInfoRepository.GetTotalCountOfParkingTypeSlots()
};
SetValueToViewBags();
carsInfo.IsParked = true;
carsInfo.IsParkingSlotAvailable = true;
return(View(carsInfo));
}
private void layoutView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (e.FocusedRowHandle != null)
{
CarsInfo selectedCarsInfo = (CarsInfo)layoutView1.GetRow(e.FocusedRowHandle);
SelectedCarId = selectedCarsInfo.Id;
gridControl2.DataSource = DataManager.GetSelectedCarsFotos(SelectedCarId);
gridControl2.Refresh();
List <Ownerinfo> ownerinfos = new List <Ownerinfo>();
ownerinfos.Add(DataManager.GetSelectedCarsoOwnerinfo(SelectedCarId));
gridControl3.DataSource = ownerinfos;
gridControl3.Refresh();
}
}
public ActionResult Index(CarsInfo model)
{
if (ModelState.IsValid)
{
CarsInfo carsInfo = _carRepository.AddCarToParking(model);
SetValueToViewBags();
carsInfo.IsParked = true;
return(View(carsInfo));
}
else
{
return(View(model));
}
}
public ActionResult <CarsInfo> CreateCarInfo([FromBody] CarsInfo value)
{
try
{
if (value != null)
{
WebDb.AddCarsInfo(value);
WebDb.SaveChanges();
return(Ok(value));
}
}
catch (Exception ex)
{
return(NotFound("Couldn't post car info - error: " + ex.Message));
}
return(NotFound());
}
// Use this for initialization
void Awake()
{
CarParametres carParametres = CarsInfo.GetCarInfo(StaticValues.NumCar);
if (carParametres != null && StaticValues.NumLevel != 999)
{
speed = carParametres.GetParam(1) + PreferencesSaver.GetCarUpgrade(StaticValues.NumCar, 1);
nitro = carParametres.GetParam(2) + PreferencesSaver.GetCarUpgrade(StaticValues.NumCar, 2);
controllability = carParametres.GetParam(3) + PreferencesSaver.GetCarUpgrade(StaticValues.NumCar, 3);
carLevel = carParametres.GetLevelCar();
minSpeed = carParametres.GetMinSpeed();
}
controllability = Mathf.Clamp(controllability, 1, maxVal);
nitro = Mathf.Clamp(nitro, 1, maxVal);
speed = Mathf.Clamp(speed, 1, maxVal);
}
public List<CarsInfo.UCEDealerInfo> UploadCarDetailsFromDealerSite(CarsInfo.DealerSiteCarInfo objDealerCaInfo,string Action)
{
var obj = new List<CarsInfo.UCEDealerInfo>();
try
{
CarsBL.DealerSiteBL.UploadCarDealerSiteBL objDealerCar = new CarsBL.DealerSiteBL.UploadCarDealerSiteBL();
if (Action == "Upload")
{
obj = (List<CarsInfo.UCEDealerInfo>)objDealerCar.UploadCar(objDealerCaInfo);
}
else
{
obj = (List<CarsInfo.UCEDealerInfo>)objDealerCar.UpdateCar(objDealerCaInfo);
}
}
catch (Exception ex)
{
}
return obj;
}
public DataSet USP_SaveNewCarRequest(CarsInfo.NewCarsInfo objNewcarsInfo)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveNewCarRequest";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@NewCarRequestName", System.Data.DbType.String, objNewcarsInfo.NewCarRequestName);
dbDatabase.AddInParameter(dbCommand, "@NewCarReqPhoneNumber", System.Data.DbType.String, objNewcarsInfo.NewCarReqPhoneNumber);
dbDatabase.AddInParameter(dbCommand, "@NewCarReqEmail", System.Data.DbType.String, objNewcarsInfo.NewCarReqEmail);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return dsCars;
}
catch (Exception ex)
{
throw ex;
}
}
private void BtnSave_OnClick(object sender, RoutedEventArgs e)
{
CarsInfo car = new CarsInfo
{
Modell = TxtModel.Text,
Status = TxtStatus.Text,
Price = Convert.ToDouble(TxtPrice.Text),
Adress = TxtAdress.Text,
Insurance = DatepickerInsurance.DisplayDate,
Sold = false
};
Ownerinfo owner = new Ownerinfo
{
Vorname = TxtFirstName.Text,
Nachname = TxtLastName.Text,
Telephonenumber = TxtTelefoneNumber.Text,
Emailadress = TxtEmailAdress.Text
};
DataManager.AddNewOffer(car, CarsFotos, owner);
CarsInfo = DataManager.GetAllOffers();
}
private void btnSave_Click(object sender, EventArgs e)
{
CarsInfo car = new CarsInfo
{
Modell = textBoxModell.Text,
Status = textBoxStatus.Text,
Price = Convert.ToDouble(textBoxPrice.Text),
Adress = textBoxAdress.Text,
Insurance = dateTimePickerInsurance.Value,
Sold = false
};
Ownerinfo owner = new Ownerinfo
{
Vorname = textBoxFirstName.Text,
Nachname = textBoxLastName.Text,
Telephonenumber = textBoxTelephoneNumber.Text,
Emailadress = textBoxEmailAdress.Text
};
DataManager.AddNewOffer(car, Foto, owner);
Clearall();
MessageBox.Show("success");
}
public DataSet USP_SaveVehicleInformation(CarsInfo.CarsInfo objCarsInfo)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveVehicleInformation";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objCarsInfo.Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objCarsInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objCarsInfo.ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objCarsInfo.NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objCarsInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, objCarsInfo.NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FuelTypeID);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", System.Data.DbType.String, objCarsInfo.Zipcode);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objCarsInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objCarsInfo.StateID);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return dsCars;
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult <CarsInfo> > PostCarsInfo(CarsInfo carsInfo)
{
_bookingRepository.PostCar(carsInfo);
return(CreatedAtAction("GetCarsInfo", new { id = carsInfo.Id }, carsInfo));
}
public DataSet USP_SaveCarDetails(CarsInfo.UsedCarsInfo objCarsInfo, string Description, string ConditionDescription, string Title, int TranBy)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "[USP_SaveDealerCarDetails]";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, objCarsInfo.BodytypeID);
dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.Int32, objCarsInfo.VehicleConditionID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.Carid);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objCarsInfo.Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objCarsInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objCarsInfo.ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objCarsInfo.NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objCarsInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, objCarsInfo.NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FueltypeId);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", System.Data.DbType.String, objCarsInfo.Zipcode);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objCarsInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objCarsInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, Description);
dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, ConditionDescription);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", System.Data.DbType.String, objCarsInfo.DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, Title);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.AddInParameter(dbCommand, "@SellingPrice", System.Data.DbType.String, objCarsInfo.CurrentPrice);
dbDatabase.AddInParameter(dbCommand, "@PurchaseCost", System.Data.DbType.String, objCarsInfo.PurchaseCost);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return dsCars;
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteCarsInfo(CarsInfo Value)
{
DataBase.CarsInfo.Remove(Value);
}
public DataSet SaveCarAndSellerInfo(CarsInfo.CarsInfo objCarsInfo, string Description, string ConditionDescription, string Title, int TranBy,
UsedCarsInfo objUsedCarsInfo, int UID, int PackageID, int PaymentID, int UserPackID, int PostingID, string Ip)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveCarAndSellerInfo";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, objCarsInfo.BodyTypeID);
dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.Int32, objCarsInfo.VehicleConditionID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objCarsInfo.Price);
dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objCarsInfo.Mileage);
dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objCarsInfo.ExteriorColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objCarsInfo.NumberOfDoors);
dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objCarsInfo.VIN);
dbDatabase.AddInParameter(dbCommand, "@NumberOfCylinder", System.Data.DbType.String, objCarsInfo.NumberOfCylinder);
dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FuelTypeID);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", System.Data.DbType.String, objCarsInfo.Zipcode);
dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objCarsInfo.City);
dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objCarsInfo.StateID);
dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, Description);
dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, ConditionDescription);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", System.Data.DbType.String, objCarsInfo.DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, Title);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.AddInParameter(dbCommand, "@sellerID", System.Data.DbType.Int32, objUsedCarsInfo.SellerID);
dbDatabase.AddInParameter(dbCommand, "@sellerName", System.Data.DbType.String, objUsedCarsInfo.SellerName);
dbDatabase.AddInParameter(dbCommand, "@address1", System.Data.DbType.String, objUsedCarsInfo.Address1);
dbDatabase.AddInParameter(dbCommand, "@state", System.Data.DbType.String, objUsedCarsInfo.State);
dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objUsedCarsInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@Phone", System.Data.DbType.String, objUsedCarsInfo.Phone);
dbDatabase.AddInParameter(dbCommand, "@email", System.Data.DbType.String, objUsedCarsInfo.Email);
dbDatabase.AddInParameter(dbCommand, "@UID", System.Data.DbType.Int32, UID);
dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.Int32, PackageID);
dbDatabase.AddInParameter(dbCommand, "@PaymentID", System.Data.DbType.Int32, PaymentID);
dbDatabase.AddInParameter(dbCommand, "@UserPackID", System.Data.DbType.Int32, UserPackID);
dbDatabase.AddInParameter(dbCommand, "@PostingID", System.Data.DbType.Int32, PostingID);
dbDatabase.AddInParameter(dbCommand, "@Ip", System.Data.DbType.String, Ip);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return dsCars;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet SaveSubScribeItems(CarsInfo.PreferncesItemsInfo ObjPreferncesInfo, bool IsActive)
{
DataSet dsResult = new DataSet();
string spNameString = string.Empty;
bool bsucess = false;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader ModelsInfoDataReader = null;
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
//Assign stored procedure name
spNameString = "[Save_SubScribeItems]";
DbCommand dbCommand = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@PreferenceID", DbType.String, ObjPreferncesInfo.PreferenceID);
dbDatabase.AddInParameter(dbCommand, "@UserPreferenceID", DbType.String, ObjPreferncesInfo.UserPreferID);
dbDatabase.AddInParameter(dbCommand, "@Makeid", DbType.String, ObjPreferncesInfo.Makeid);
dbDatabase.AddInParameter(dbCommand, "@ModelID", DbType.String, ObjPreferncesInfo.ModelID);
dbDatabase.AddInParameter(dbCommand, "@PriceRange", DbType.String, ObjPreferncesInfo.PriceRange);
dbDatabase.AddInParameter(dbCommand, "@IsActive", DbType.Boolean, IsActive);
//Executing stored procedure
dsResult = dbDatabase.ExecuteDataSet(dbCommand);
bsucess = true;
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
return dsResult;
}
public DataSet SaveSubscribe(CarsInfo.PreferenceInfo ObjPreferncesInfo,int Isactive)
{
DataSet dsResult = new DataSet();
string spNameString = string.Empty;
bool bsucess = false;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader ModelsInfoDataReader = null;
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
//Assign stored procedure name
spNameString = "[Save_SubScribe]";
DbCommand dbCommand = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@UserPreferID", DbType.Int64, ObjPreferncesInfo.PreferenceID);
dbDatabase.AddInParameter(dbCommand, "@Name", DbType.String, ObjPreferncesInfo.Name );
dbDatabase.AddInParameter(dbCommand, "@Email", DbType.String, ObjPreferncesInfo.Email );
dbDatabase.AddInParameter(dbCommand, "@Phone", DbType.String, ObjPreferncesInfo.Phone );
dbDatabase.AddInParameter(dbCommand, "@IPAddress", DbType.String, ObjPreferncesInfo.IPAddress);
dbDatabase.AddInParameter(dbCommand, "@Zip", DbType.String, ObjPreferncesInfo.Zip);
dbDatabase.AddInParameter(dbCommand, "@Isactive", DbType.Int32, Isactive);
//Executing stored procedure
dsResult = dbDatabase.ExecuteDataSet(dbCommand);
bsucess = true;
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
return dsResult;
}
//all CarsInfo functions - get list, add new CarsInfo, delete current CarsInfo, and update current CarsInfo
#region CarsInfoFunctions
public void AddCarsInfo(CarsInfo Value)
{
DataBase.CarsInfo.Add(Value);
}
public void PostCar(CarsInfo carsInfo)
{
_context.CarsInfo.Add(carsInfo);
_context.SaveChangesAsync();
}
public bool UpdatePicturesByIdFromDealerSite(CarsInfo.UsedCarsInfo objCarsInfo, int TranBy)
{
try
{
bool bnew = false;
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.CarsConnTest);
spNameString = "USP_UpdatePicturesById";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@pic1", System.Data.DbType.String, objCarsInfo.PIC1);
dbDatabase.AddInParameter(dbCommand, "@pic2", System.Data.DbType.String, objCarsInfo.PIC2);
dbDatabase.AddInParameter(dbCommand, "@pic3", System.Data.DbType.String, objCarsInfo.PIC3);
dbDatabase.AddInParameter(dbCommand, "@pic4", System.Data.DbType.String, objCarsInfo.PIC4);
dbDatabase.AddInParameter(dbCommand, "@pic5", System.Data.DbType.String, objCarsInfo.PIC5);
dbDatabase.AddInParameter(dbCommand, "@pic6", System.Data.DbType.String, objCarsInfo.PIC6);
dbDatabase.AddInParameter(dbCommand, "@pic7", System.Data.DbType.String, objCarsInfo.PIC7);
dbDatabase.AddInParameter(dbCommand, "@pic8", System.Data.DbType.String, objCarsInfo.PIC8);
dbDatabase.AddInParameter(dbCommand, "@pic9", System.Data.DbType.String, objCarsInfo.PIC9);
dbDatabase.AddInParameter(dbCommand, "@pic10", System.Data.DbType.String, objCarsInfo.PIC10);
dbDatabase.AddInParameter(dbCommand, "@Pic11", System.Data.DbType.String, objCarsInfo.PIC11);
dbDatabase.AddInParameter(dbCommand, "@pic12", System.Data.DbType.String, objCarsInfo.PIC12);
dbDatabase.AddInParameter(dbCommand, "@pic13", System.Data.DbType.String, objCarsInfo.PIC13);
dbDatabase.AddInParameter(dbCommand, "@pic14", System.Data.DbType.String, objCarsInfo.PIC14);
dbDatabase.AddInParameter(dbCommand, "@pic15", System.Data.DbType.String, objCarsInfo.PIC15);
dbDatabase.AddInParameter(dbCommand, "@pic16", System.Data.DbType.String, objCarsInfo.PIC16);
dbDatabase.AddInParameter(dbCommand, "@pic17", System.Data.DbType.String, objCarsInfo.PIC17);
dbDatabase.AddInParameter(dbCommand, "@pic18", System.Data.DbType.String, objCarsInfo.PIC18);
dbDatabase.AddInParameter(dbCommand, "@pic19", System.Data.DbType.String, objCarsInfo.PIC19);
dbDatabase.AddInParameter(dbCommand, "@pic20", System.Data.DbType.String, objCarsInfo.PIC20);
dbDatabase.AddInParameter(dbCommand, "@Pic0", System.Data.DbType.String, objCarsInfo.PIC0);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.Carid);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.ExecuteDataSet(dbCommand);
bnew = true;
return bnew;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet USP_SaveVehicleType(CarsInfo.CarsInfo objCarsInfo)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveVehicleType";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID);
dbDatabase.AddInParameter(dbCommand, "@BodyTypeID", System.Data.DbType.Int32, objCarsInfo.BodyTypeID);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return dsCars;
}
catch (Exception ex)
{
throw ex;
}
}
public CarsInfo PutCar(string id, CarsInfo carsInfo)
{
_context.Entry(carsInfo).State = EntityState.Modified;
_context.SaveChangesAsync();
return(carsInfo);
}
public bool SaveUserLog(CarsInfo.UserLogInfo ObjUserLog, ref Int64 lngReturn, string logid)
{
bool returnValue = false;
bool bNew = false;
string spNameString = string.Empty;
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "[USP_Save_UserLog]";
DbCommand dbCommand = null;
try
{
if (logid == "")
{
bNew = false;
ObjUserLog.Log_Id = 0;
}
else
{
ObjUserLog.Log_Id = Int64.Parse(logid);
bNew = true;
}
//Assign stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
//Assign stored procedure parameters
dbDatabase.AddInParameter(dbCommand, "@Log_Id", DbType.Int64, ObjUserLog.Log_Id);
dbDatabase.AddInParameter(dbCommand, "@User_Id", DbType.Int64, ObjUserLog.User_Id);
dbDatabase.AddInParameter(dbCommand, "@Login_Ip", DbType.String, ObjUserLog.Login_Ip);
dbDatabase.AddInParameter(dbCommand, "@Log_Status_Id", DbType.Int32, ObjUserLog.Log_Status_Id);
dbDatabase.AddInParameter(dbCommand, "@Login_DateTime", DbType.DateTime, ObjUserLog.Login_DateTime);
dbDatabase.AddInParameter(dbCommand, "@Logout_time", DbType.DateTime, ObjUserLog.Logout_time);
dbDatabase.AddInParameter(dbCommand, "@Session_Id", DbType.String, ObjUserLog.Session_Id);
dbDatabase.AddInParameter(dbCommand, "@CookieID", DbType.String, ObjUserLog.CookieID);
dbDatabase.AddInParameter(dbCommand, "@bNew", DbType.Boolean, bNew);
dbDatabase.AddOutParameter(dbCommand, "@ID", DbType.Int64, 1);
dbDatabase.ExecuteNonQuery(dbCommand);
lngReturn = Int64.Parse(dbDatabase.GetParameterValue(dbCommand, "@Id").ToString());
returnValue = true;
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbDatabase = null;
}
return returnValue;
}
public bool UpdatePicturesByIdForSmartz(CarsInfo.CarsInfo objCarsInfo, int TranBy)
{
try
{
bool bnew = false;
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_UpdatePicturesByIdForSmartz";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbDatabase.AddInParameter(dbCommand, "@pic1", System.Data.DbType.String, objCarsInfo.Pic1);
dbDatabase.AddInParameter(dbCommand, "@pic2", System.Data.DbType.String, objCarsInfo.Pic2);
dbDatabase.AddInParameter(dbCommand, "@pic3", System.Data.DbType.String, objCarsInfo.Pic3);
dbDatabase.AddInParameter(dbCommand, "@pic4", System.Data.DbType.String, objCarsInfo.Pic4);
dbDatabase.AddInParameter(dbCommand, "@pic5", System.Data.DbType.String, objCarsInfo.Pic5);
dbDatabase.AddInParameter(dbCommand, "@pic6", System.Data.DbType.String, objCarsInfo.Pic6);
dbDatabase.AddInParameter(dbCommand, "@pic7", System.Data.DbType.String, objCarsInfo.Pic7);
dbDatabase.AddInParameter(dbCommand, "@pic8", System.Data.DbType.String, objCarsInfo.Pic8);
dbDatabase.AddInParameter(dbCommand, "@pic9", System.Data.DbType.String, objCarsInfo.Pic9);
dbDatabase.AddInParameter(dbCommand, "@pic10", System.Data.DbType.String, objCarsInfo.Pic10);
dbDatabase.AddInParameter(dbCommand, "@Pic11", System.Data.DbType.String, objCarsInfo.Pic11);
dbDatabase.AddInParameter(dbCommand, "@pic12", System.Data.DbType.String, objCarsInfo.Pic12);
dbDatabase.AddInParameter(dbCommand, "@pic13", System.Data.DbType.String, objCarsInfo.Pic13);
dbDatabase.AddInParameter(dbCommand, "@pic14", System.Data.DbType.String, objCarsInfo.Pic14);
dbDatabase.AddInParameter(dbCommand, "@pic15", System.Data.DbType.String, objCarsInfo.Pic15);
dbDatabase.AddInParameter(dbCommand, "@pic16", System.Data.DbType.String, objCarsInfo.Pic16);
dbDatabase.AddInParameter(dbCommand, "@pic17", System.Data.DbType.String, objCarsInfo.Pic17);
dbDatabase.AddInParameter(dbCommand, "@pic18", System.Data.DbType.String, objCarsInfo.Pic18);
dbDatabase.AddInParameter(dbCommand, "@pic19", System.Data.DbType.String, objCarsInfo.Pic19);
dbDatabase.AddInParameter(dbCommand, "@pic20", System.Data.DbType.String, objCarsInfo.Pic20);
dbDatabase.AddInParameter(dbCommand, "@Pic0", System.Data.DbType.String, objCarsInfo.Pic0);
dbDatabase.AddInParameter(dbCommand, "@CarID", System.Data.DbType.Int32, objCarsInfo.CarID);
dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy);
dbDatabase.ExecuteDataSet(dbCommand);
bnew = true;
return bnew;
}
catch (Exception ex)
{
throw ex;
}
}
private void AssignCarsInfoList(IDataReader CarsInfoDataReader, CarsInfo.CarsInfo objCarsInfo)
{
try
{
objCarsInfo.CarID = int.Parse(CarsInfoDataReader["makeID"].ToString());
objCarsInfo.YearOfMake = int.Parse( CarsInfoDataReader["yearOfMake"].ToString());
objCarsInfo.MakeModelID=int.Parse(CarsInfoDataReader["makeModelID"].ToString());
objCarsInfo.MakeModel = CarsInfoDataReader["MakeModel"].ToString();
objCarsInfo.Make = CarsInfoDataReader["Make"].ToString();
objCarsInfo.Mileage = CarsInfoDataReader["mileage"].ToString();
objCarsInfo.Zipcode = CarsInfoDataReader["zipcode"].ToString();
objCarsInfo.VehicleConditionID = CarsInfoDataReader["vehicleConditionID"].ToString();
objCarsInfo.VehicleCondition = CarsInfoDataReader["VehicleCondition"].ToString();
objCarsInfo.Description = CarsInfoDataReader["description"].ToString();
objCarsInfo.Price = CarsInfoDataReader["price"].ToString();
objCarsInfo.Pic1 = CarsInfoDataReader["pic1"].ToString();
objCarsInfo.Pic2 = CarsInfoDataReader["pic2"].ToString();
objCarsInfo.Pic3 = CarsInfoDataReader["pic3"].ToString();
objCarsInfo.Pic4 = CarsInfoDataReader["pic4"].ToString();
objCarsInfo.Pic5 = CarsInfoDataReader["pic5"].ToString();
objCarsInfo.Pic6 = CarsInfoDataReader["pic6"].ToString();
objCarsInfo.Pic7 = CarsInfoDataReader["pic7"].ToString();
objCarsInfo.Pic8 = CarsInfoDataReader["pic8"].ToString();
objCarsInfo.Pic9 = CarsInfoDataReader["pic9"].ToString();
objCarsInfo.Pic10 = CarsInfoDataReader["pic10"].ToString();
objCarsInfo.BodyTypeID = int.Parse(CarsInfoDataReader["bodyTypeID"].ToString());
objCarsInfo.BodyType = CarsInfoDataReader["BodyType"].ToString();
objCarsInfo.Miles_per_gallon = CarsInfoDataReader["Miles_per_gallon"].ToString();
objCarsInfo.FuelTypeID = int.Parse(CarsInfoDataReader["fuelTypeID"].ToString());
objCarsInfo.FuelType = int.Parse(CarsInfoDataReader["FuelType"].ToString());
objCarsInfo.UserFeedback = CarsInfoDataReader["userFeedback"].ToString();
objCarsInfo.ExteriorColor = CarsInfoDataReader["exteriorColor"].ToString();
objCarsInfo.InteriorColor = CarsInfoDataReader["interiorColor"].ToString();
objCarsInfo.NumberOfCylinder = CarsInfoDataReader["numberOfCylinder"].ToString();
objCarsInfo.Transmission=CarsInfoDataReader["makeModelID"].ToString();
objCarsInfo.NumberOfDoors=CarsInfoDataReader["numberOfDoors"].ToString();
objCarsInfo.NumberOfSeats=CarsInfoDataReader["numberOfSeats"].ToString();
objCarsInfo.VIN=CarsInfoDataReader["VIN"].ToString();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
}
}
public JsonResult GetParkedCar(int id)
{
CarsInfo info = _carRepository.GetCarById(id);
return(Json(info, JsonRequestBehavior.AllowGet));
}
public IList<UsedCarsInfo> FilterSearch(CarsInfo.CarsFilter objCarsFilter)
{
string spNameString = string.Empty;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader ModelsInfoDataReader = null;
IList<UsedCarsInfo> UsedCarsIList = new List<UsedCarsInfo>();
//Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
//Assign stored procedure name
spNameString = "[FilterSearch]";
DbCommand dbCommand = null;
IDataReader UsedCarsDataReader = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@makeModelID", DbType.String, objCarsFilter.CarModalId);
dbDatabase.AddInParameter(dbCommand, "@Nearby", DbType.String, objCarsFilter.WithinZip);
dbDatabase.AddInParameter(dbCommand, "@Pin", DbType.Int64, objCarsFilter.ZipCode);
dbDatabase.AddInParameter(dbCommand, "@currentPage", DbType.Int64, objCarsFilter.CurrentPage);
dbDatabase.AddInParameter(dbCommand, "@makeID", DbType.String, objCarsFilter.CarMakeid);
dbDatabase.AddInParameter(dbCommand, "@Orderby", DbType.String, objCarsFilter.Orderby);
dbDatabase.AddInParameter(dbCommand, "@sort", DbType.String, objCarsFilter.Sort);
dbDatabase.AddInParameter(dbCommand, "@pageSize", DbType.Int64, objCarsFilter.PageSize);
dbDatabase.AddInParameter(dbCommand, "@Mileage1", DbType.String , objCarsFilter.Mileage1);
dbDatabase.AddInParameter(dbCommand, "@Mileage2", DbType.String, objCarsFilter.Mileage2);
dbDatabase.AddInParameter(dbCommand, "@Mileage3", DbType.String, objCarsFilter.Mileage3);
dbDatabase.AddInParameter(dbCommand, "@Mileage4", DbType.String, objCarsFilter.Mileage4);
dbDatabase.AddInParameter(dbCommand, "@Mileage5", DbType.String, objCarsFilter.Mileage5);
dbDatabase.AddInParameter(dbCommand, "@Mileage6", DbType.String, objCarsFilter.Mileage6);
dbDatabase.AddInParameter(dbCommand, "@Mileage7", DbType.String, objCarsFilter.Mileage7);
dbDatabase.AddInParameter(dbCommand, "@Year1a", DbType.String, objCarsFilter.Year1a);
dbDatabase.AddInParameter(dbCommand, "@Year1b", DbType.String, objCarsFilter.Year1b);
dbDatabase.AddInParameter(dbCommand, "@Year1", DbType.String, objCarsFilter.Year1);
dbDatabase.AddInParameter(dbCommand, "@Year2", DbType.String, objCarsFilter.Year2);
dbDatabase.AddInParameter(dbCommand, "@Year3", DbType.String, objCarsFilter.Year3);
dbDatabase.AddInParameter(dbCommand, "@Year4", DbType.String, objCarsFilter.Year4);
dbDatabase.AddInParameter(dbCommand, "@Year5", DbType.String, objCarsFilter.Year5);
dbDatabase.AddInParameter(dbCommand, "@Year6", DbType.String, objCarsFilter.Year6);
dbDatabase.AddInParameter(dbCommand, "@Year7", DbType.String, objCarsFilter.Year7);
dbDatabase.AddInParameter(dbCommand, "@Price1", DbType.String, objCarsFilter.Price1);
dbDatabase.AddInParameter(dbCommand, "@Price2", DbType.String, objCarsFilter.Price2);
dbDatabase.AddInParameter(dbCommand, "@Price3", DbType.String, objCarsFilter.Price3);
dbDatabase.AddInParameter(dbCommand, "@Price4", DbType.String, objCarsFilter.Price4);
dbDatabase.AddInParameter(dbCommand, "@Price5", DbType.String, objCarsFilter.Price5);
dbDatabase.AddInParameter(dbCommand, "@Body1", DbType.String, objCarsFilter.Body1);
dbDatabase.AddInParameter(dbCommand, "@Body2", DbType.String, objCarsFilter.Body2);
dbDatabase.AddInParameter(dbCommand, "@Body3", DbType.String, objCarsFilter.Body3);
dbDatabase.AddInParameter(dbCommand, "@Body4", DbType.String, objCarsFilter.Body4);
dbDatabase.AddInParameter(dbCommand, "@Body5", DbType.String, objCarsFilter.Body5);
dbDatabase.AddInParameter(dbCommand, "@Body6", DbType.String, objCarsFilter.Body6);
dbDatabase.AddInParameter(dbCommand, "@Body7", DbType.String, objCarsFilter.Body7);
dbDatabase.AddInParameter(dbCommand, "@Body8", DbType.String, objCarsFilter.Body8);
dbDatabase.AddInParameter(dbCommand, "@Body9", DbType.String, objCarsFilter.Body9);
dbDatabase.AddInParameter(dbCommand, "@Fuel1", DbType.String, objCarsFilter.Fuel1);
dbDatabase.AddInParameter(dbCommand, "@Fuel2", DbType.String, objCarsFilter.Fuel2);
dbDatabase.AddInParameter(dbCommand, "@Fuel3", DbType.String, objCarsFilter.Fuel3);
dbDatabase.AddInParameter(dbCommand, "@Fuel4", DbType.String, objCarsFilter.Fuel4);
dbDatabase.AddInParameter(dbCommand, "@Fuel5", DbType.String, objCarsFilter.Fuel5);
dbDatabase.AddInParameter(dbCommand, "@Seller1", DbType.String, objCarsFilter.Seller1);
dbDatabase.AddInParameter(dbCommand, "@Seller2", DbType.String, objCarsFilter.Seller2);
dbDatabase.AddInParameter(dbCommand, "@withPic", DbType.Boolean, objCarsFilter.WithPic);
//objUsedCars.Executing stored procedure
UsedCarsDataReader = dbDatabase.ExecuteReader(dbCommand);
//'DataSet DS = dbDatabase.ExecuteDataSet(dbCommand);
while (UsedCarsDataReader.Read())
{
// objUsedCars.Assign values to the CarsInfo object list
UsedCarsInfo ObjCarsInfo_Info = new UsedCarsInfo();
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;
}
public void UpdateCarsInfo(CarsInfo Value)
{
DataBase.CarsInfo.Update(Value);
}
