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; }