public IList<UsedHotLeadInfo> FindCarID(string CarID)
{
///objUsedCars.Decalaring HotLeadInfo division object collection
IList<UsedHotLeadInfo> UsedCarsIList = new List<UsedHotLeadInfo>();
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_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 HotLeadInfo object list
UsedHotLeadInfo ObjHotLeadInfo_Info = new UsedHotLeadInfo();
AssignHotLeadInfoList(UsedCarsDataReader, ObjHotLeadInfo_Info);
UsedCarsIList.Add(ObjHotLeadInfo_Info);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
finally
{
UsedCarsDataReader.Close();
}
return UsedCarsIList;
}
private void AssignHotLeadInfoList(IDataReader UsedCarsDataReader, UsedHotLeadInfo 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.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.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.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.ConditionDescription = UsedCarsDataReader["ConditionDescription"].ToString() == "" ? "Emp" : UsedCarsDataReader["ConditionDescription"].ToString();
objUsedCars.DriveTrain = UsedCarsDataReader["DriveTrain"].ToString() == "" ? "Emp" : UsedCarsDataReader["DriveTrain"].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.Title = UsedCarsDataReader["Title"].ToString() == "" ? "Emp" : UsedCarsDataReader["Title"].ToString();
objUsedCars.AdStatus = UsedCarsDataReader["AdStatusName"].ToString() == "" ? "Emp" : UsedCarsDataReader["AdStatusName"].ToString();
//objUsedCars.pic0 = UsedCarsDataReader["pic0"].ToString();
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
}
}
public IList<UsedHotLeadInfo> SimialarCars(string MakeId,string zipcode)
{
string spNameString = string.Empty;
//Setting Connection
//Global.INSTANCE_NAME = strCurrentConn;
IDataReader ModelsInfoDataReader = null;
IList<UsedHotLeadInfo> UsedCarsIList = new List<UsedHotLeadInfo>();
//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);
//objUsedCars.Executing stored procedure
UsedCarsDataReader = dbDatabase.ExecuteReader(dbCommand);
//DataSet DS = dbDatabase.ExecuteDataSet(dbCommand);
while (UsedCarsDataReader.Read())
{
// objUsedCars.Assign values to the HotLeadInfo object list
UsedHotLeadInfo ObjHotLeadInfo_Info = new UsedHotLeadInfo();
AssignHotLeadInfoList(UsedCarsDataReader, ObjHotLeadInfo_Info);
UsedCarsIList.Add(ObjHotLeadInfo_Info);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
finally
{
UsedCarsDataReader.Close();
}
return UsedCarsIList;
}
public IList<UsedHotLeadInfo> SearchUsedCarsSort(string carMakeid, string CarModalId, string ZipCode, string WithinZip,
string currentPage, string pageSize,
string Orderby,string sortorder)
{
///objUsedCars.Decalaring HotLeadInfo division object collection
IList<UsedHotLeadInfo> UsedCarsIList = new List<UsedHotLeadInfo>();
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_SearchCarsSort]";
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.Int64, WithinZip);
dbDatabase.AddInParameter(dbCommand, "@Pin", DbType.Int64, ZipCode);
dbDatabase.AddInParameter(dbCommand, "@currentPage", DbType.Int64, currentPage);
dbDatabase.AddInParameter(dbCommand, "@pageSize", DbType.Int64, pageSize);
dbDatabase.AddInParameter(dbCommand, "@Orderby", DbType.String, Orderby);
dbDatabase.AddInParameter(dbCommand, "@Sort", DbType.String, sortorder);
//objUsedCars.Executing stored procedure
UsedCarsDataReader = dbDatabase.ExecuteReader(dbCommand);
//DataSet ds = dbDatabase.ExecuteDataSet (dbCommand);
while (UsedCarsDataReader.Read())
{
// objUsedCars.Assign values to the HotLeadInfo object list
UsedHotLeadInfo ObjHotLeadInfo_Info = new UsedHotLeadInfo();
AssignHotLeadInfoList(UsedCarsDataReader, ObjHotLeadInfo_Info);
UsedCarsIList.Add(ObjHotLeadInfo_Info);
}
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY);
if (rethrow)
throw;
}
finally
{
UsedCarsDataReader.Close();
}
return UsedCarsIList;
}