Free 3 Months
|
| |
| robinwilliams | Asp.Net User |
| GetAdById, add more fileds to AdRow | 4/22/2007 11:52:11 PM |
0/0 | |
|
Hi guys,
If you have a look in the ShowAd.aspx.vb code, you will notice you can type in something like,
Label1.text = ad.EpirationDate or
Label2.Text = ad.NumViews
What I wold like to do is add more options to that ad. part, like ad.PhoneNumber or ad.EmailAddress
Does anyone know how to access this? I know you will need to add more rows to the classifieds_Ads table, I changed the GetAdById stored procedure, but still isn;'t working??
What code do you think I need to change in order to get to that ad. part? Do I need to change the AdsTableAdapter ?
Thanks :)
Success comes to those who prepare well and put in effort. |
| darkknight187 | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 4/23/2007 3:11:38 AM |
0/0 | |
|
I don't know what Adapter your talking about but you have to change around 10 main files, as well as Postad.aspx & UpdateAd.aspx.
The 10 starting in the database are of course in the "Tables" Database add your new catagories,
(I started out by copying the code for AdType and Location)
2: In the Views folder "ClassifiedsView_Ads" Check the empty boxes next to your new addition.
3: "Stored Procedures" There's a lot here so here they are GetAdById, GetSavedAds, InsertAd, RelistAd, UpdateAd.
4: Now in the Solutions Explorer (I'm working off of VWD) go in App_Code folder, into BLL folder and change Ads.vb.
5: Now into DAL and into Ads.xsd, add your new addition, don't forget to change the properties of your new column after you insert it.
(NOW THIS PART IS VERY IMPORTANT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!)
Still in Ads.xsd after you save, right click and choose view code.
This file needs to be modified as well but you must be entering your new code in the same order, ie (1)(2)(3)(4)
if you enter your new catagories in any order (1)(3)(2)(4) and then in (1)(2)(4)(3) it will end up uploading info to the wrong database column.
Your Ads page will have errors until you have them all correct.
So with that said the biggest piece of advise I can give you is copy your project folder and save it as a backup elsewhere just in case.
Good luck, if you get stuck let me know.
Be sure to visit www.detelli.comAnd please remember to click ?Mark as Answer? on the post that helps you. This can be beneficial to other community members reading the thread. |
| r1kob | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 8/1/2007 10:54:34 AM |
0/0 | |
|
I am a little stock on the following areas of your well laid out advice, i am trying to add a telephone colum to the data base, but more imprtantly would be pleased to understand how to do this, i can see lots of diiferent applications for it ( Telephone int not allow nulls )
(1) I started out by copying the code for AdType and Location)
1) What do you mean by the above statement ?
(4) Now in the Solutions Explorer (I'm working off of VWD) go in App_Code folder, into BLL folder and change Ads.vb.
4) what do i change in this file ?, i couldnt find anything to change at all
(5) Still in Ads.xsd after you save, right click and choose view code.
This file needs to be modified as well but you must be entering your new code in the same order, ie (1)(2)(3)(4)
5) I get what you mean but dont understand what i am ment to be chaning, i can see the source code and there is a lot of it, but dont know what to do, ?
After following this, what next ?
thank you for your help
|
| r1kob | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 8/1/2007 11:38:46 AM |
0/0 | |
|
It went to run it and got a total of 58 errors, ideas what i have done wrong ? <?xml version="1.0" encoding="utf-8"?>
< xs:schema id="AdsDataComponent" targetNamespace="uri:AspNet:StarterKits:Classifieds:Data" xmlns:mstns="uri:AspNet:StarterKits:Classifieds:Data" xmlns="uri:AspNet:StarterKits:Classifieds:Data" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified"><xs:annotation>
< xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource"><DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
< Connections><Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="classifiedsConnection" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="classifiedsConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.classifiedsConnection.ConnectionString" Provider="System.Data.SqlClient">
</ Connection></Connections>
< Tables><TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AdsDataAdapter" Name="Ads">
< MainSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAdById" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAdById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
< DeleteCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemoveAd</CommandText><Parameters>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ DeleteCommand><InsertCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>InsertAd</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="CategoryId" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Location" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ExpirationDate" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DateCreated" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DateApproved" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumViews" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumViews" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumResponses" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumResponses" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdLevel" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdStatus" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdType" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></InsertCommand>
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetAdById</CommandText><Parameters>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand><UpdateCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>UpdateAd</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Location" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></UpdateCommand>
</ DbSource></MainSource>
< Mappings><Mapping SourceColumn="Id" DataSetColumn="Id" />
< Mapping SourceColumn="MemberId" DataSetColumn="MemberId" /><Mapping SourceColumn="CategoryId" DataSetColumn="CategoryId" />
< Mapping SourceColumn="Title" DataSetColumn="Title" /><Mapping SourceColumn="Description" DataSetColumn="Description" />
< Mapping SourceColumn="URL" DataSetColumn="URL" /><Mapping SourceColumn="Price" DataSetColumn="Price" />
< Mapping SourceColumn="Location" DataSetColumn="Location" /><Mapping SourceColumn="ExpirationDate" DataSetColumn="ExpirationDate" />
< Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" /><Mapping SourceColumn="DateApproved" DataSetColumn="DateApproved" />
< Mapping SourceColumn="NumViews" DataSetColumn="NumViews" /><Mapping SourceColumn="NumResponses" DataSetColumn="NumResponses" />
< Mapping SourceColumn="AdLevel" DataSetColumn="AdLevel" /><Mapping SourceColumn="AdStatus" DataSetColumn="AdStatus" />
< Mapping SourceColumn="AdType" DataSetColumn="AdType" /><Mapping SourceColumn="PreviewImageId" DataSetColumn="PreviewImageId" />
< Mapping SourceColumn="MemberName" DataSetColumn="MemberName" /><Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
< Mapping SourceColumn="Telephone" DataSetColumn="Telephone" /></Mappings>
< Sources><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.ExpireAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="ExpireAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>ExpireAd</CommandText><Parameters>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAdsByRandomOrder" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAdsByRandomOrder" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetAdsByRandomOrder</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumRecords" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAdsByStatus" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAdsByStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetAdsByStatus</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAllAdsByQuery" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAllAdsByQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetAllAdsByQuery</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LimitResultCount" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MaxPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SearchTerm" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MinDateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MustHaveImage" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MustHaveImage" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetExpiredAds" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetExpiredAds" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetExpiredAds</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetSavedAds" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetSavedAds" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetSavedAds</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertAd" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
< CommandText>InsertAd</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertSavedAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertSavedAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>InsertSavedAd</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.MoveAds" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="MoveAds" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>MoveAds</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrentCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NewCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RelistAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RelistAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>RelistAd</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemoveAd</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveAdsByStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveAdsByStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>RemoveAdsByStatus</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveSavedAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveSavedAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemoveSavedAd</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="True"><CommandText>UpdateAd</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdCategory" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdCategory" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>UpdateAdCategory</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdLevel" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdLevel" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>UpdateAdLevel</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdStats" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdStats" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>UpdateAdStats</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>UpdateAdStatus</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource></Sources>
</ TableAdapter><TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PhotosDataAdapter" Name="Photos">
< MainSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotosByAdId" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetPhotosByAdId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetPhotosByAdId</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
</ MainSource><Mappings>
< Mapping SourceColumn="Id" DataSetColumn="Id" /><Mapping SourceColumn="AdId" DataSetColumn="AdId" />
< Mapping SourceColumn="IsMainPreview" DataSetColumn="IsMainPreview" /><Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
</ Mappings><Sources>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotoBytesById" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="GetPhotoBytesById" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetPhotoBytesById</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Size" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotosByAdStatus" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetPhotosByAdStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetPhotosByAdStatus</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertPhoto" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="True"><CommandText>InsertPhoto</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesFull" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesMedium" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesSmall" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsMainPreview" Precision="1" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemovePhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemovePhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemovePhoto</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemovePhotosByAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemovePhotosByAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>RemovePhotosByAdStatus</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.SetAdPreviewPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="SetAdPreviewPhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>SetAdPreviewPhoto</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
</ Sources></TableAdapter>
</ Tables><Sources>
</ Sources></DataSource>
</ xs:appinfo></xs:annotation>
< xs:element name="AdsDataComponent" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"><xs:complexType>
< xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="Ads">
< xs:complexType><xs:sequence>
< xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /><xs:element name="MemberId" type="xs:int" />
< xs:element name="CategoryId" type="xs:int" /><xs:element name="Title">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="100" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="Description"><xs:simpleType>
< xs:restriction base="xs:string"><xs:maxLength value="1073741823" />
</ xs:restriction></xs:simpleType>
</ xs:element><xs:element name="URL">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="500" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="Price" type="xs:decimal" /><xs:element name="Location">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="50" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="ExpirationDate" type="xs:dateTime" minOccurs="0" /><xs:element name="DateCreated" type="xs:dateTime" />
< xs:element name="DateApproved" type="xs:dateTime" minOccurs="0" /><xs:element name="NumViews" type="xs:int" />
< xs:element name="NumResponses" type="xs:int" /><xs:element name="AdLevel" type="xs:int" />
< xs:element name="AdStatus" type="xs:int" /><xs:element name="AdType" type="xs:int" />
< xs:element name="PreviewImageId" type="xs:int" minOccurs="0" /><xs:element name="MemberName">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="256" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="CategoryName"><xs:simpleType>
< xs:restriction base="xs:string"><xs:maxLength value="50" />
</ xs:restriction></xs:simpleType>
</ xs:element><xs:element name="Telephone">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="50" /></xs:restriction>
</ xs:simpleType></xs:element>
</ xs:sequence></xs:complexType>
</ xs:element><xs:element name="Photos">
< xs:complexType><xs:sequence>
< xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /><xs:element name="AdId" type="xs:int" />
< xs:element name="IsMainPreview" type="xs:boolean" /><xs:element name="DateCreated" type="xs:dateTime" />
</ xs:sequence></xs:complexType>
</ xs:element></xs:choice>
</ xs:complexType><xs:unique name="Constraint1" msdata:PrimaryKey="true">
< xs:selector xpath=".//mstns:Ads" /><xs:field xpath="mstns:Id" />
</ xs:unique><xs:unique name="Photos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
< xs:selector xpath=".//mstns:Photos" /><xs:field xpath="mstns:Id" />
</ xs:unique></xs:element>
</ xs:schema> |
| r1kob | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 8/1/2007 11:44:34 AM |
0/0 | |
|
It went to run it and got a total of 58 errors, ideas what i have done wrong ? <?xml version="1.0" encoding="utf-8"?>
< xs:schema id="AdsDataComponent" targetNamespace="uri:AspNet:StarterKits:Classifieds:Data" xmlns:mstns="uri:AspNet:StarterKits:Classifieds:Data" xmlns="uri:AspNet:StarterKits:Classifieds:Data" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified"><xs:annotation>
< xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource"><DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
< Connections><Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="classifiedsConnection" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="classifiedsConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.classifiedsConnection.ConnectionString" Provider="System.Data.SqlClient">
</ Connection></Connections>
< Tables><TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AdsDataAdapter" Name="Ads">
< MainSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAdById" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAdById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
< DeleteCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemoveAd</CommandText><Parameters>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ DeleteCommand><InsertCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>InsertAd</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="CategoryId" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Location" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ExpirationDate" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DateCreated" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DateApproved" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumViews" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumViews" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumResponses" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumResponses" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdLevel" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdStatus" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdType" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></InsertCommand>
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetAdById</CommandText><Parameters>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand><UpdateCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>UpdateAd</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Location" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></UpdateCommand>
</ DbSource></MainSource>
< Mappings><Mapping SourceColumn="Id" DataSetColumn="Id" />
< Mapping SourceColumn="MemberId" DataSetColumn="MemberId" /><Mapping SourceColumn="CategoryId" DataSetColumn="CategoryId" />
< Mapping SourceColumn="Title" DataSetColumn="Title" /><Mapping SourceColumn="Description" DataSetColumn="Description" />
< Mapping SourceColumn="URL" DataSetColumn="URL" /><Mapping SourceColumn="Price" DataSetColumn="Price" />
< Mapping SourceColumn="Location" DataSetColumn="Location" /><Mapping SourceColumn="ExpirationDate" DataSetColumn="ExpirationDate" />
< Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" /><Mapping SourceColumn="DateApproved" DataSetColumn="DateApproved" />
< Mapping SourceColumn="NumViews" DataSetColumn="NumViews" /><Mapping SourceColumn="NumResponses" DataSetColumn="NumResponses" />
< Mapping SourceColumn="AdLevel" DataSetColumn="AdLevel" /><Mapping SourceColumn="AdStatus" DataSetColumn="AdStatus" />
< Mapping SourceColumn="AdType" DataSetColumn="AdType" /><Mapping SourceColumn="PreviewImageId" DataSetColumn="PreviewImageId" />
< Mapping SourceColumn="MemberName" DataSetColumn="MemberName" /><Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
< Mapping SourceColumn="Telephone" DataSetColumn="Telephone" /></Mappings>
< Sources><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.ExpireAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="ExpireAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>ExpireAd</CommandText><Parameters>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAdsByRandomOrder" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAdsByRandomOrder" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetAdsByRandomOrder</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumRecords" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAdsByStatus" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAdsByStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetAdsByStatus</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetAllAdsByQuery" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetAllAdsByQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetAllAdsByQuery</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LimitResultCount" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MaxPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SearchTerm" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MinDateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MustHaveImage" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MustHaveImage" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetExpiredAds" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetExpiredAds" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetExpiredAds</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetSavedAds" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetSavedAds" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetSavedAds</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertAd" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="True">
< CommandText>InsertAd</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertSavedAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertSavedAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>InsertSavedAd</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.MoveAds" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="MoveAds" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>MoveAds</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrentCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NewCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RelistAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RelistAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>RelistAd</CommandText>
< Parameters><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemoveAd</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveAdsByStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveAdsByStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>RemoveAdsByStatus</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemoveSavedAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemoveSavedAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemoveSavedAd</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAd" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="True"><CommandText>UpdateAd</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="Int" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdCategory" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdCategory" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>UpdateAdCategory</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdLevel" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdLevel" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>UpdateAdLevel</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdStats" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdStats" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>UpdateAdStats</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.UpdateAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="UpdateAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>UpdateAdStatus</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource></Sources>
</ TableAdapter><TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PhotosDataAdapter" Name="Photos">
< MainSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotosByAdId" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetPhotosByAdId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetPhotosByAdId</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
</ MainSource><Mappings>
< Mapping SourceColumn="Id" DataSetColumn="Id" /><Mapping SourceColumn="AdId" DataSetColumn="AdId" />
< Mapping SourceColumn="IsMainPreview" DataSetColumn="IsMainPreview" /><Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
</ Mappings><Sources>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotoBytesById" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="GetPhotoBytesById" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>GetPhotoBytesById</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Size" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.GetPhotosByAdStatus" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetPhotosByAdStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>GetPhotosByAdStatus</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.InsertPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="InsertPhoto" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="True"><CommandText>InsertPhoto</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesFull" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesMedium" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesSmall" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsMainPreview" Precision="1" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemovePhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemovePhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>RemovePhoto</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
< DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.RemovePhotosByAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="RemovePhotosByAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True"><SelectCommand>
< DbCommand CommandType="StoredProcedure" ModifiedByUser="False"><CommandText>RemovePhotosByAdStatus</CommandText>
< Parameters><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter><Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</ Parameter></Parameters>
</ DbCommand></SelectCommand>
</ DbSource><DbSource ConnectionRef="classifiedsConnection (Web.config)" DbObjectName="classifieds.SetAdPreviewPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="True" Modifier="Public" Name="SetAdPreviewPhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
< SelectCommand><DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
< CommandText>SetAdPreviewPhoto</CommandText><Parameters>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
< Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current"></Parameter>
</ Parameters></DbCommand>
</ SelectCommand></DbSource>
</ Sources></TableAdapter>
</ Tables><Sources>
</ Sources></DataSource>
</ xs:appinfo></xs:annotation>
< xs:element name="AdsDataComponent" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"><xs:complexType>
< xs:choice minOccurs="0" maxOccurs="unbounded"><xs:element name="Ads">
< xs:complexType><xs:sequence>
< xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /><xs:element name="MemberId" type="xs:int" />
< xs:element name="CategoryId" type="xs:int" /><xs:element name="Title">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="100" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="Description"><xs:simpleType>
< xs:restriction base="xs:string"><xs:maxLength value="1073741823" />
</ xs:restriction></xs:simpleType>
</ xs:element><xs:element name="URL">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="500" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="Price" type="xs:decimal" /><xs:element name="Location">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="50" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="ExpirationDate" type="xs:dateTime" minOccurs="0" /><xs:element name="DateCreated" type="xs:dateTime" />
< xs:element name="DateApproved" type="xs:dateTime" minOccurs="0" /><xs:element name="NumViews" type="xs:int" />
< xs:element name="NumResponses" type="xs:int" /><xs:element name="AdLevel" type="xs:int" />
< xs:element name="AdStatus" type="xs:int" /><xs:element name="AdType" type="xs:int" />
< xs:element name="PreviewImageId" type="xs:int" minOccurs="0" /><xs:element name="MemberName">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="256" /></xs:restriction>
</ xs:simpleType></xs:element>
< xs:element name="CategoryName"><xs:simpleType>
< xs:restriction base="xs:string"><xs:maxLength value="50" />
</ xs:restriction></xs:simpleType>
</ xs:element><xs:element name="Telephone">
< xs:simpleType><xs:restriction base="xs:string">
< xs:maxLength value="50" /></xs:restriction>
</ xs:simpleType></xs:element>
</ xs:sequence></xs:complexType>
</ xs:element><xs:element name="Photos">
< xs:complexType><xs:sequence>
< xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" type="xs:int" /><xs:element name="AdId" type="xs:int" />
< xs:element name="IsMainPreview" type="xs:boolean" /><xs:element name="DateCreated" type="xs:dateTime" />
</ xs:sequence></xs:complexType>
</ xs:element></xs:choice>
</ xs:complexType><xs:unique name="Constraint1" msdata:PrimaryKey="true">
< xs:selector xpath=".//mstns:Ads" /><xs:field xpath="mstns:Id" />
</ xs:unique><xs:unique name="Photos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
< xs:selector xpath=".//mstns:Photos" /><xs:field xpath="mstns:Id" />
</ xs:unique></xs:element>
</ xs:schema> |
| darkknight187 | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 8/1/2007 6:09:37 PM |
0/0 | |
|
All right you're on the right track.
First off the database type "int" stands for integer, as in numeric only.
Since you will probably be formating with "-" in the number I would use a NVarChar.
Just for future reference in that ads.xsd code file there is no "int" there's "int16" and "int32" so that's part of the problem.
So change the int references to NVarChar, I saw three missing references to your new telephone column in the code file.
And be sure to use the same format of code as is already written in each section, in other words DO NOT just write the telephone entry once and copy the same thing in each section, most are different. This step takes forever.
Since you are no longer using an "integer" you will also need to change those references to "string".
When you get to a point needing to enter the phone number in a text box try this validator.
It will error if it's not in a 555-555-1234 format
<asp:TextBox Text='<%# Bind("Telephone") %>' runat="server" ID="PhoneTB" MaxLength="100" Width="150"></asp:TextBox>
<asp:RegularExpressionValidator runat="server" ControlToValidate="PhoneTB" ValidationExpression="^((\d{3}))?[-]\d{3}[-]\d{4}$" ErrorMessage="A valid phone number is required." ToolTip="A valid phone number is required." ID="PhoneValidator" Display="dynamic" Text="*"> </asp:RegularExpressionValidator> (555-555-1234)
And by the way while the code file is open it will show errors, the VWD will show errors, it does it with the unmodified kit so I just ignore it.
I think that's it.
Be sure to visit www.detelli.comAnd please remember to click ?Mark as Answer? on the post that helps you. This can be beneficial to other community members reading the thread. |
| r1kob | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 8/9/2007 8:46:35 AM |
0/0 | |
|
Thank you for your help and advice, Since i last posted i have taken the time to read Working with DATA ACCESS LAYER
I am having problems still never the less, i have tried to add a PHONE Table, followed your kind instructions but have this error
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30311: Value of type 'System.Nullable(Of Date)' cannot be converted to 'Integer'.
Source Error:
|
Line 98: Dim ad As AdsDataComponent.AdsRow = Nothing
Line 99: Using db As New AdsDataAdapter()
Line 100: adId = CInt(db.InsertAd(memberId, categoryId, title, description, url, price, location, phone, expirationDate, dateCreated, dateApproved, numViews, numResponses, CInt(adLevel), CInt(adStatus), CInt(adType)))
Line 101:
Line 102: If s.AdminNotification = AdminNotificationSetting.EachAd Then
| Source File: C:\Documents and Settings\Richard\Desktop\Classifieds3\App_Code\BLL\Ads.vb Line: 100
|
| darkknight187 | Asp.Net User |
| Re: GetAdById, add more fileds to AdRow | 8/10/2007 1:57:11 AM |
0/0 | |
|
In you Ads.xsd file code view you are using telephone, in the error it says phone, make sure all references are the same.
Be sure to visit www.detelli.comAnd please remember to click ?Mark as Answer? on the post that helps you. This can be beneficial to other community members reading the thread. |
|
| |
Free Download:
Search This Site:
|
|