public IList <UsedCarsInfo> FindDealerCarID(string DealerCarID, string DealerCode)
{
///objUsedCars.Decalaring CarsInfo division object collection
IList <UsedCarsInfo> UsedCarsIList = new List <UsedCarsInfo>();
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_NAME);
//objUsedCars.Assign stored procedure name
spNameString = "[USP_FindDealerCarID]";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@DealerCarID", DbType.String, DealerCarID);
dbDatabase.AddInParameter(dbCommand, "@DealerCode", DbType.String, DealerCode);
//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();
AssignCarsInfoList1(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 DataSet USP_SaveSellerInfo(UsedCarsInfo objUsedCarsInfo, int CarID, int UID)
{
try
{
bool bnew = false;
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.CarsConnTest);
spNameString = "USP_UpdateMobileSellerInfo";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
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, "@city", System.Data.DbType.String, objUsedCarsInfo.City);
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, "@CarID", System.Data.DbType.Int32, CarID);
dbDatabase.AddInParameter(dbCommand, "@UID", System.Data.DbType.Int32, UID);
dsCars = dbDatabase.ExecuteDataSet(dbCommand);
return(dsCars);
}
catch (Exception ex)
{
throw ex;
}
}
public bool USP_SaveSellerInfoForBulkUpload(UsedCarsInfo objUsedCarsInfo, int CarID, string Source, string SourcePicID, int SellerType, string HomeViewCount)
{
try
{
bool bnew = false;
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveSellerInfoForBulkUpload";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 1500;
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, "@city", System.Data.DbType.String, objUsedCarsInfo.City);
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, "@CarID", System.Data.DbType.Int32, CarID);
dbDatabase.AddInParameter(dbCommand, "@Source", System.Data.DbType.String, Source);
dbDatabase.AddInParameter(dbCommand, "@SourcePicID", System.Data.DbType.String, SourcePicID);
dbDatabase.AddInParameter(dbCommand, "@SellerType", System.Data.DbType.Int32, SellerType);
dbDatabase.AddInParameter(dbCommand, "@HomeViewCount", System.Data.DbType.String, HomeViewCount);
dbDatabase.ExecuteDataSet(dbCommand);
bnew = true;
return(bnew);
}
catch (Exception ex)
{
throw ex;
}
}
public List <UsedCarsInfo> GetCarsAdsMakeAndModel()
{
List <UsedCarsInfo> UsedCarsIList = new List <UsedCarsInfo>();
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.CENTRAL_INSTANCE_NAME);
//objUsedCars.Assign stored procedure name
spNameString = "[USP_CarsAdsMake&Model]";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
//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
{
///dbCommand.Dispose();
}
return(UsedCarsIList);
}
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 string UpdateSellerInformation(string sellerID, string sellerName, string city, string state, string zip, string phone, string email, string carID, string UID, string AuthenticationID, string CustomerID, string SessionID)
{
string returnPostingID = "Failure";
MobileBL objMobileBL = new MobileBL();
if (CustomerID.Trim() != "")
{
DataSet dsSaveCustInfo = objMobileBL.SaveMobileCustomerInfo("UpdateSellerInformation", CustomerID, AuthenticationID, sellerID);
}
bool bnew = objMobileBL.CheckMobileAuthorizeUSer(SessionID, Convert.ToInt32(UID));
if (bnew)
{
try
{
if (AuthenticationID == ConfigurationManager.AppSettings["AppleID"].ToString())
{
UsedCarsInfo objUsedCarsInfo = new UsedCarsInfo();
objUsedCarsInfo.SellerID = Convert.ToInt32(sellerID);
objUsedCarsInfo.SellerName = sellerName;
objUsedCarsInfo.City = city;
objUsedCarsInfo.State = state;
objUsedCarsInfo.Zip = zip;
objUsedCarsInfo.Phone = phone;
objUsedCarsInfo.Email = email;
DataSet dsposting = new DataSet();
dsposting = objMobileBL.UpdateMobileSellerInfo(objUsedCarsInfo, Convert.ToInt32(carID), Convert.ToInt32(UID));
if (dsposting.Tables.Count > 0)
{
if (dsposting.Tables[0].Rows.Count > 0)
{
returnPostingID = "Success";
}
}
}
}
catch (Exception ex)
{
}
}
else
{
returnPostingID = "Session timed out";
}
return(returnPostingID);
}
public DataSet USP_SaveSellerInfo(UsedCarsInfo objUsedCarsInfo, int CarID, int UID, int PackageID, int PaymentID, int UserPackID, int PostingID, string Ip)
{
try
{
bool bnew = false;
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "[USP_DealerSaveSellerInfo]";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
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, "@city", System.Data.DbType.String, objUsedCarsInfo.City);
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, "@CarID", System.Data.DbType.Int32, CarID);
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;
}
}
private void AssignCarsInfoList(IDataReader UsedCarsDataReader, UsedCarsInfo 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() == "" ? "Emp" : 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() == "" ? "Emp" : 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" : 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.Bodytype = UsedCarsDataReader["bodytype"].ToString();
objUsedCars.BodytypeID = Convert.ToInt32(UsedCarsDataReader["BodytypeID"].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.VIN = UsedCarsDataReader["VIN"].ToString() == "" ? "Emp" : UsedCarsDataReader["VIN"].ToString();
objUsedCars.ConditionDescription = UsedCarsDataReader["ConditionDescription"].ToString() == "" ? "Emp" : UsedCarsDataReader["ConditionDescription"].ToString();
objUsedCars.DriveTrain = UsedCarsDataReader["DriveTrain"].ToString() == "" ? "Emp" : UsedCarsDataReader["DriveTrain"].ToString();
objUsedCars.Title = UsedCarsDataReader["Title"].ToString() == "" ? "Emp" : UsedCarsDataReader["Title"].ToString();
objUsedCars.CarUniqueID = UsedCarsDataReader["CarUniqueID"].ToString() == "" ? "Emp" : UsedCarsDataReader["CarUniqueID"].ToString();
objUsedCars.AdStatus = UsedCarsDataReader["AdStatusName"].ToString() == "" ? "Emp" : UsedCarsDataReader["AdStatusName"].ToString();
objUsedCars.PIC0 = UsedCarsDataReader["PIC0"].ToString() == "" ? GetStockURL(objUsedCars.Make, objUsedCars.Model) : 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.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.RowNumber = UsedCarsDataReader["RowNumber"].ToString() == "" ? "Emp" : UsedCarsDataReader["RowNumber"].ToString();
objUsedCars.TotalRecords = UsedCarsDataReader["TotalRecords"].ToString() == "" ? "Emp" : UsedCarsDataReader["TotalRecords"].ToString();
objUsedCars.PageCount = UsedCarsDataReader["PageCount"].ToString() == "" ? "Emp" : UsedCarsDataReader["PageCount"].ToString();
objUsedCars.UserFeedback = UsedCarsDataReader["UserFeedback"].ToString();
//objUsedCars.pic0 = UsedCarsDataReader["pic0"].ToString();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
}
}
public IList <UsedCarsInfo> GetDealersSearchCarsNew(string carMakeid, string CarModalId, string YearID, string PriceOrderby,
string MarginRangeOrderby, string NoofDayActive, string AdStatus, string CarActive, string VehicleTypeTrim,
string InventoryID,
string DealerCode)
{
///objUsedCars.Decalaring CarsInfo division object collection
IList <UsedCarsInfo> UsedCarsIList = new List <UsedCarsInfo>();
string spNameString = string.Empty;
IDataReader UsedCarsDataReader = null;
//objUsedCars.Connect to the database
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_Dealers_SearchCarsNew";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@makeID", DbType.String, carMakeid);
dbDatabase.AddInParameter(dbCommand, "@makeModelID", DbType.String, CarModalId);
dbDatabase.AddInParameter(dbCommand, "@YearID", DbType.Int64, YearID);
dbDatabase.AddInParameter(dbCommand, "@PriceOrderby", DbType.String, PriceOrderby);
dbDatabase.AddInParameter(dbCommand, "@MarginRangeOrderby", DbType.String, MarginRangeOrderby);
dbDatabase.AddInParameter(dbCommand, "@NoofDayActive", DbType.String, NoofDayActive);
dbDatabase.AddInParameter(dbCommand, "@AdStatus", DbType.String, AdStatus);
dbDatabase.AddInParameter(dbCommand, "@CarActive", DbType.String, CarActive);
dbDatabase.AddInParameter(dbCommand, "@VehicleTypeTrim", DbType.String, VehicleTypeTrim);
dbDatabase.AddInParameter(dbCommand, "@InventoryID", DbType.String, InventoryID);
dbDatabase.AddInParameter(dbCommand, "@DealerCode", DbType.String, DealerCode);
//objUsedCars.Executing stored procedure
UsedCarsDataReader = dbDatabase.ExecuteReader(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 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 SaveCarPicturesFromDealerSite(int CarID, string PicLocation, string PicName, int UserID)
{
UCEDealerSiteBL objDealer = new UCEDealerSiteBL();
UsedCarsInfo objCarPicInfo = new UsedCarsInfo();
Dealer.DealerActions objAction = new CarsBL.Dealer.DealerActions();
string bSuccess = string.Empty;
try
{
DataSet ds = objDealer.GetCarImageIDsToDealerSite(CarID);
objCarPicInfo.Carid = Convert.ToInt32(CarID);
string picId = objDealer.SaveCarPictureFromDealerSite(PicLocation, PicName, UserID);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
objCarPicInfo.PIC0 = ds.Tables[0].Rows[0]["pic0"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic0"].ToString();
objCarPicInfo.PIC1 = ds.Tables[0].Rows[0]["pic1"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic1"].ToString();
objCarPicInfo.PIC2 = ds.Tables[0].Rows[0]["pic2"].ToString() == "" ? null: ds.Tables[0].Rows[0]["pic2"].ToString();
objCarPicInfo.PIC3 = ds.Tables[0].Rows[0]["pic3"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic3"].ToString();
objCarPicInfo.PIC4 = ds.Tables[0].Rows[0]["pic4"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic4"].ToString();
objCarPicInfo.PIC5 = ds.Tables[0].Rows[0]["pic5"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic5"].ToString();
objCarPicInfo.PIC6 = ds.Tables[0].Rows[0]["pic6"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic6"].ToString();
objCarPicInfo.PIC7 = ds.Tables[0].Rows[0]["pic7"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic7"].ToString();
objCarPicInfo.PIC8 = ds.Tables[0].Rows[0]["pic8"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic8"].ToString();
objCarPicInfo.PIC9 = ds.Tables[0].Rows[0]["pic9"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic9"].ToString();
objCarPicInfo.PIC10 = ds.Tables[0].Rows[0]["pic10"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic10"].ToString();
objCarPicInfo.PIC11 = ds.Tables[0].Rows[0]["pic11"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic11"].ToString();
objCarPicInfo.PIC12 = ds.Tables[0].Rows[0]["pic12"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic12"].ToString();
objCarPicInfo.PIC13 = ds.Tables[0].Rows[0]["pic13"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic13"].ToString();
objCarPicInfo.PIC14 = ds.Tables[0].Rows[0]["pic14"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic14"].ToString();
objCarPicInfo.PIC15 = ds.Tables[0].Rows[0]["pic15"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic15"].ToString();
objCarPicInfo.PIC16 = ds.Tables[0].Rows[0]["pic16"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic16"].ToString();
objCarPicInfo.PIC17 = ds.Tables[0].Rows[0]["pic17"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic17"].ToString();
objCarPicInfo.PIC18 = ds.Tables[0].Rows[0]["pic18"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic18"].ToString();
objCarPicInfo.PIC19 = ds.Tables[0].Rows[0]["pic19"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic19"].ToString();
objCarPicInfo.PIC20 = ds.Tables[0].Rows[0]["pic20"].ToString() == "" ? null : ds.Tables[0].Rows[0]["pic20"].ToString();
if (objCarPicInfo.PIC0 == null || objCarPicInfo.PIC0 == "")
{
objCarPicInfo.PIC0 = picId;
}
else if (objCarPicInfo.PIC1 == null || objCarPicInfo.PIC1 == "")
{
objCarPicInfo.PIC1 = picId;
}
else if (objCarPicInfo.PIC2 == null || objCarPicInfo.PIC2 == "")
{
objCarPicInfo.PIC2 = picId;
}
else if (objCarPicInfo.PIC3 == null || objCarPicInfo.PIC3 == "")
{
objCarPicInfo.PIC3 = picId;
}
else if (objCarPicInfo.PIC4 == null || objCarPicInfo.PIC4 == "")
{
objCarPicInfo.PIC4 = picId;
}
else if (objCarPicInfo.PIC5 == null || objCarPicInfo.PIC5 == "")
{
objCarPicInfo.PIC5 = picId;
}
else if (objCarPicInfo.PIC6 == null || objCarPicInfo.PIC6 == "")
{
objCarPicInfo.PIC6 = picId;
}
else if (objCarPicInfo.PIC7 == null || objCarPicInfo.PIC7 == "")
{
objCarPicInfo.PIC7 = picId;
}
else if (objCarPicInfo.PIC8 == null || objCarPicInfo.PIC8 == "")
{
objCarPicInfo.PIC8 = picId;
}
else if (objCarPicInfo.PIC9 == null || objCarPicInfo.PIC9 == "")
{
objCarPicInfo.PIC9 = picId;
}
else if (objCarPicInfo.PIC10 == null || objCarPicInfo.PIC10 == "")
{
objCarPicInfo.PIC10 = picId;
}
else if (objCarPicInfo.PIC11 == null || objCarPicInfo.PIC11 == "")
{
objCarPicInfo.PIC11 = picId;
}
else if (objCarPicInfo.PIC12 == null || objCarPicInfo.PIC12 == "")
{
objCarPicInfo.PIC12 = picId;
}
else if (objCarPicInfo.PIC13 == null || objCarPicInfo.PIC13 == "")
{
objCarPicInfo.PIC13 = picId;
}
else if (objCarPicInfo.PIC14 == null || objCarPicInfo.PIC14 == "")
{
objCarPicInfo.PIC14 = picId;
}
else if (objCarPicInfo.PIC15 == null || objCarPicInfo.PIC15 == "")
{
objCarPicInfo.PIC15 = picId;
}
else if (objCarPicInfo.PIC16 == null || objCarPicInfo.PIC16 == "")
{
objCarPicInfo.PIC16 = picId;
}
else if (objCarPicInfo.PIC17 == null || objCarPicInfo.PIC17 == "")
{
objCarPicInfo.PIC17 = picId;
}
else if (objCarPicInfo.PIC18 == null || objCarPicInfo.PIC18 == "")
{
objCarPicInfo.PIC18 = picId;
}
else if (objCarPicInfo.PIC19 == null || objCarPicInfo.PIC19 == "")
{
objCarPicInfo.PIC19 = picId;
}
else if (objCarPicInfo.PIC20 == null || objCarPicInfo.PIC19 == "")
{
objCarPicInfo.PIC20 = picId;
}
objDealer.UpdatePicturesByIdFromDealerSite(objCarPicInfo, UserID);
}
}
}
catch (Exception ex)
{
}
}
public IList <UsedCarsInfo> SearchMultiUsedCars(string carMakeid, string CarModalId, string ZipCode, string WithinZip,
string currentPage, string pageSize,
string Orderby)
{
///objUsedCars.Decalaring CarsInfo division object collection
IList <UsedCarsInfo> UsedCarsIList = new List <UsedCarsInfo>();
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_NAME);
//objUsedCars.Assign stored procedure name
spNameString = "[USP_SearchMultiCars]";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@makeID", DbType.String, carMakeid);
dbDatabase.AddInParameter(dbCommand, "@makeModelID", DbType.String, CarModalId);
dbDatabase.AddInParameter(dbCommand, "@Nearby", DbType.String, WithinZip);
dbDatabase.AddInParameter(dbCommand, "@Pin", DbType.String, ZipCode);
dbDatabase.AddInParameter(dbCommand, "@currentPage", DbType.Int64, currentPage);
dbDatabase.AddInParameter(dbCommand, "@pageSize", DbType.Int64, pageSize);
dbDatabase.AddInParameter(dbCommand, "@Orderby", DbType.String, Orderby);
//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 IList <UsedCarsInfo> SimialarCars(string MakeId, string ModelID, string zipcode, string Price)
{
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 = "[USP_SimilarCars]";
DbCommand dbCommand = null;
IDataReader UsedCarsDataReader = null;
try
{
//Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@MakeID", DbType.String, MakeId);
dbDatabase.AddInParameter(dbCommand, "@Zipcode", DbType.String, zipcode);
dbDatabase.AddInParameter(dbCommand, "@Price", DbType.String, Price);
dbDatabase.AddInParameter(dbCommand, "@ModelID", DbType.String, ModelID);
//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 IList <UsedCarsInfo> GetRecentCarsMobile(string sCurrentPage, string PageSize,
string Orderby, string Sort, string Pin)
{
///objUsedCars.Decalaring CarsInfo division object collection
IList <UsedCarsInfo> UsedCarsIList = new List <UsedCarsInfo>();
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_NAME);
//objUsedCars.Assign stored procedure name
spNameString = "[USP_RecentCarsMobile]";
DbCommand dbCommand = null;
try
{
//objUsedCars.Set stored procedure to the command object
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 10000;
dbCommand.CommandTimeout = 10000;
dbDatabase.AddInParameter(dbCommand, "@currentPage", DbType.String, sCurrentPage);
dbDatabase.AddInParameter(dbCommand, "@pageSize", DbType.String, PageSize);
dbDatabase.AddInParameter(dbCommand, "@Orderby", DbType.String, Orderby);
dbDatabase.AddInParameter(dbCommand, "@Sort", DbType.String, Sort);
dbDatabase.AddInParameter(dbCommand, "@Pin", DbType.String, Pin);
//objUsedCars.Executing stored procedure
UsedCarsDataReader = dbDatabase.ExecuteReader(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 DataSet SaveCarDetailsForBulkUploadDealers(UsedCarsInfo objCarsInfo,
string SellerID, String SellerTypeID, string Source, String SourcePicID, string DealerCarid, string UserPackID, string DealerCode)
{
try
{
DataSet dsCars = new DataSet();
string spNameString = string.Empty;
Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME);
spNameString = "USP_SaveCarDetailsForBulkUploadDealers";
DbCommand dbCommand = null;
dbCommand = dbDatabase.GetStoredProcCommand(spNameString);
dbCommand.CommandTimeout = 1500;
dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.String, objCarsInfo.YearOfMake);
dbDatabase.AddInParameter(dbCommand, "@Make", System.Data.DbType.String, objCarsInfo.Make);
dbDatabase.AddInParameter(dbCommand, "@Model", System.Data.DbType.String, objCarsInfo.Model);
dbDatabase.AddInParameter(dbCommand, "@BodyType", System.Data.DbType.String, objCarsInfo.Bodytype);
dbDatabase.AddInParameter(dbCommand, "@VehicleCondition", System.Data.DbType.String, objCarsInfo.VehicleConditionID);
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, "@InteriorColor", System.Data.DbType.String, objCarsInfo.InteriorColor);
dbDatabase.AddInParameter(dbCommand, "@Transmission", System.Data.DbType.String, objCarsInfo.Transmission);
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.String, objCarsInfo.Fueltype);
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.String, objCarsInfo.State);
dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, objCarsInfo.Description);
dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, objCarsInfo.ConditionDescription);
dbDatabase.AddInParameter(dbCommand, "@DriveTrain", System.Data.DbType.String, objCarsInfo.DriveTrain);
dbDatabase.AddInParameter(dbCommand, "@sellerID", System.Data.DbType.String, SellerID);
dbDatabase.AddInParameter(dbCommand, "@SellerType", System.Data.DbType.String, SellerTypeID);
dbDatabase.AddInParameter(dbCommand, "@Source", System.Data.DbType.String, Source);
dbDatabase.AddInParameter(dbCommand, "@SourcePicID", System.Data.DbType.String, SourcePicID);
dbDatabase.AddInParameter(dbCommand, "@DealerCarID", System.Data.DbType.String, DealerCarid);
dbDatabase.AddInParameter(dbCommand, "@address1", System.Data.DbType.String, objCarsInfo.Address1);
dbDatabase.AddInParameter(dbCommand, "@sellerName", System.Data.DbType.String, objCarsInfo.SellerName);
dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.String, objCarsInfo.PackageID);
dbDatabase.AddInParameter(dbCommand, "@UserPackID", System.Data.DbType.String, UserPackID);
dbDatabase.AddInParameter(dbCommand, "@Phone", System.Data.DbType.String, objCarsInfo.Phone);
dbDatabase.AddInParameter(dbCommand, "@Email", System.Data.DbType.String, objCarsInfo.Email);
dbDatabase.AddInParameter(dbCommand, "@DealerCode", System.Data.DbType.String, DealerCode);
dbDatabase.AddInParameter(dbCommand, "@UID", System.Data.DbType.String, objCarsInfo.Uid);
//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;
}
}
