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