public DataSet SmartzSaveRVData(RvUsedcarsInfo objRvUsedCarsInfo, RvCarsInfo objRvCarsInfo, RvSellerInfo objRvSellerInfo) { try { DataSet dsCars = new DataSet(); string spNameString = string.Empty; Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME2); spNameString = "USP_SmartzSaveRVData"; DbCommand dbCommand = null; dbCommand = dbDatabase.GetStoredProcCommand(spNameString); dbDatabase.AddInParameter(dbCommand, "@sellerName", System.Data.DbType.String, objRvSellerInfo.SellerName); dbDatabase.AddInParameter(dbCommand, "@Address1", System.Data.DbType.String, objRvSellerInfo.Address1); dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objRvSellerInfo.City); dbDatabase.AddInParameter(dbCommand, "@State", System.Data.DbType.String, objRvSellerInfo.State); dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objRvSellerInfo.Zip); dbDatabase.AddInParameter(dbCommand, "@Phone", System.Data.DbType.String, objRvSellerInfo.Phone); dbDatabase.AddInParameter(dbCommand, "@Email", System.Data.DbType.String, objRvSellerInfo.Email); dbDatabase.AddInParameter(dbCommand, "@AltPhone", System.Data.DbType.String, objRvSellerInfo.AltPhone); dbDatabase.AddInParameter(dbCommand, "@Carid", System.Data.DbType.Int32, objRvUsedCarsInfo.Carid); dbDatabase.AddInParameter(dbCommand, "@Uid", System.Data.DbType.Int32, objRvUsedCarsInfo.Uid); dbDatabase.AddInParameter(dbCommand, "@SaleDate", System.Data.DbType.DateTime, objRvUsedCarsInfo.SaleDate); dbDatabase.AddInParameter(dbCommand, "@PackageID", System.Data.DbType.Int32, objRvUsedCarsInfo.PackageID); dbDatabase.AddInParameter(dbCommand, "@SaleEnteredBy", System.Data.DbType.Int32, objRvUsedCarsInfo.SaleEnteredBy); dbDatabase.AddInParameter(dbCommand, "@Ip", System.Data.DbType.String, objRvUsedCarsInfo.Ip); dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objRvCarsInfo.YearOfMake); dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objRvCarsInfo.MakeModelID); dbDatabase.AddInParameter(dbCommand, "@Model", System.Data.DbType.String, objRvCarsInfo.Model); dbDatabase.AddInParameter(dbCommand, "@Price", System.Data.DbType.String, objRvCarsInfo.Price); dbDatabase.AddInParameter(dbCommand, "@Mileage", System.Data.DbType.String, objRvCarsInfo.Mileage); dbDatabase.AddInParameter(dbCommand, "@ExteriorColor", System.Data.DbType.String, objRvCarsInfo.ExteriorColor); dbDatabase.AddInParameter(dbCommand, "@InteriorColor", System.Data.DbType.String, objRvCarsInfo.InteriorColor); dbDatabase.AddInParameter(dbCommand, "@NumberOfDoors", System.Data.DbType.String, objRvCarsInfo.NumberOfDoors); dbDatabase.AddInParameter(dbCommand, "@VIN", System.Data.DbType.String, objRvCarsInfo.VIN); dbDatabase.AddInParameter(dbCommand, "@FuelTypeID", System.Data.DbType.Int32, objRvCarsInfo.FuelTypeID); dbDatabase.AddInParameter(dbCommand, "@StateID", System.Data.DbType.Int32, objRvCarsInfo.StateID); dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, objRvCarsInfo.Description); dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, objRvCarsInfo.ConditionDescription); dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.String, objRvCarsInfo.VehicleConditionID); dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, objRvCarsInfo.Title); dbDatabase.AddInParameter(dbCommand, "@AirConditioners", System.Data.DbType.Int32, objRvCarsInfo.AirConditioners); dbDatabase.AddInParameter(dbCommand, "@Length", System.Data.DbType.String, objRvCarsInfo.Length); dbDatabase.AddInParameter(dbCommand, "@WaterCapacity", System.Data.DbType.String, objRvCarsInfo.WaterCapacity); dbDatabase.AddInParameter(dbCommand, "@Towing_Capacity", System.Data.DbType.String, objRvCarsInfo.Towing_Capacity); dbDatabase.AddInParameter(dbCommand, "@Dry_Weight", System.Data.DbType.String, objRvCarsInfo.Dry_Weight); dbDatabase.AddInParameter(dbCommand, "@SleepingCapacity", System.Data.DbType.Int32, objRvCarsInfo.SleepingCapacity); dbDatabase.AddInParameter(dbCommand, "@SlideOuts", System.Data.DbType.Int32, objRvCarsInfo.SlideOuts); dbDatabase.AddInParameter(dbCommand, "@EngineManufacturer", System.Data.DbType.String, objRvCarsInfo.EngineManufacturer); dbDatabase.AddInParameter(dbCommand, "@EngineType", System.Data.DbType.String, objRvCarsInfo.EngineType); dsCars = dbDatabase.ExecuteDataSet(dbCommand); return dsCars; } catch (Exception ex) { throw ex; } }
public bool SmartzUpdateRVEditData(RvSellerInfo objSellerInfo, RvCarsInfo objCarsInfo, RvUsedcarsInfo objUsedCarsInfo, int TranBy) { try { bool bnew = false; string spNameString = string.Empty; Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME2); spNameString = "USP_SmartzUpdateRVEditData"; DbCommand dbCommand = null; dbCommand = dbDatabase.GetStoredProcCommand(spNameString); dbDatabase.AddInParameter(dbCommand, "@Phone", System.Data.DbType.String, objSellerInfo.Phone); dbDatabase.AddInParameter(dbCommand, "@City", System.Data.DbType.String, objSellerInfo.City); dbDatabase.AddInParameter(dbCommand, "@Email", System.Data.DbType.String, objSellerInfo.Email); dbDatabase.AddInParameter(dbCommand, "@State", System.Data.DbType.String, objSellerInfo.State); dbDatabase.AddInParameter(dbCommand, "@Zip", System.Data.DbType.String, objSellerInfo.Zip); dbDatabase.AddInParameter(dbCommand, "@AltPhone", System.Data.DbType.String, objSellerInfo.AltPhone); dbDatabase.AddInParameter(dbCommand, "@YearOfMake", System.Data.DbType.Int32, objCarsInfo.YearOfMake); dbDatabase.AddInParameter(dbCommand, "@MakeModelID", System.Data.DbType.Int32, objCarsInfo.MakeModelID); dbDatabase.AddInParameter(dbCommand, "@Model", System.Data.DbType.String, objCarsInfo.Model); dbDatabase.AddInParameter(dbCommand, "@VehicleConditionID", System.Data.DbType.String, 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, "@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, "@FuelTypeID", System.Data.DbType.Int32, objCarsInfo.FuelTypeID); dbDatabase.AddInParameter(dbCommand, "@Description", System.Data.DbType.String, objCarsInfo.Description); dbDatabase.AddInParameter(dbCommand, "@ConditionDescription", System.Data.DbType.String, objCarsInfo.ConditionDescription); dbDatabase.AddInParameter(dbCommand, "@Title", System.Data.DbType.String, objCarsInfo.Title); dbDatabase.AddInParameter(dbCommand, "@AirConditioners", System.Data.DbType.Int32, objCarsInfo.AirConditioners); dbDatabase.AddInParameter(dbCommand, "@Length", System.Data.DbType.String, objCarsInfo.Length); dbDatabase.AddInParameter(dbCommand, "@WaterCapacity", System.Data.DbType.String, objCarsInfo.WaterCapacity); dbDatabase.AddInParameter(dbCommand, "@Towing_Capacity", System.Data.DbType.String, objCarsInfo.Towing_Capacity); dbDatabase.AddInParameter(dbCommand, "@Dry_Weight", System.Data.DbType.String, objCarsInfo.Dry_Weight); dbDatabase.AddInParameter(dbCommand, "@SleepingCapacity", System.Data.DbType.Int32, objCarsInfo.SleepingCapacity); dbDatabase.AddInParameter(dbCommand, "@SlideOuts", System.Data.DbType.Int32, objCarsInfo.SlideOuts); dbDatabase.AddInParameter(dbCommand, "@EngineManufacturer", System.Data.DbType.String, objCarsInfo.EngineManufacturer); dbDatabase.AddInParameter(dbCommand, "@EngineType", System.Data.DbType.String, objCarsInfo.EngineType); dbDatabase.AddInParameter(dbCommand, "@InternalNotes", System.Data.DbType.String, objCarsInfo.InternalNotes); dbDatabase.AddInParameter(dbCommand, "@IsActive", System.Data.DbType.Int32, objUsedCarsInfo.IsActive); dbDatabase.AddInParameter(dbCommand, "@ListingStatus", System.Data.DbType.Int32, objUsedCarsInfo.AdStatus); dbDatabase.AddInParameter(dbCommand, "@SellerID", System.Data.DbType.Int32, objUsedCarsInfo.SellerID); dbDatabase.AddInParameter(dbCommand, "@PostingID", System.Data.DbType.Int32, objUsedCarsInfo.PostingID); dbDatabase.AddInParameter(dbCommand, "@TranBy", System.Data.DbType.Int32, TranBy); dbDatabase.ExecuteDataSet(dbCommand); bnew = true; return bnew; } catch (Exception ex) { throw ex; } }