I want to add a textbox "phone" in the postads page, and want to add the corresponding column in the classifiedads table (phone) to show it in a label in the showads page.

It made me crazy!!! please can someone teach me how to do? Thank you

I'm not sure what frustrates you.  These are steps to do this:

1.  author a form page with the phone textbox
2. update phone number in the table of the database with the value obtained from the above page
3. retrieve the phone number from the database and display it on the second form page

Once you get it more additions are simple, but there are 10 files that need modifications 

The 10 starting in the classifieds_Ads database are of course in the "Tables" add your new column,

for the phone number you could use a nvarchar(50) for the type.

(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.

Follow how the others are set like adtype, location, url . . . In this case when you declare it you can do it "As String"

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 Phone.)

I prefer to do this part manually to keep the Scheme,

(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.

And of course the postad, and editad page.

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.

Daniel

Thank you Daniel,

I've done all what you asked me to do, but still,messages!!! grr, you're right i think i didn't respected order ,i'll try again, and keep you informed.

Thank you once again, Daniel

'sorry for my bad english! lol'

darkknight187:

Once you get it more additions are simple, but there are 10 files that need modifications 

The 10 starting in the classifieds_Ads database are of course in the "Tables" add your new column,

for the phone number you could use a nvarchar(50) for the type.

(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.

Follow how the others are set like adtype, location, url . . . In this case when you declare it you can do it "As String"

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 Phone.)

I prefer to do this part manually to keep the Scheme,

(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.

And of course the postad, and editad page.

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.

Daniel

 

darkknight187:

Once you get it more additions are simple, but there are 10 files that need modifications 

The 10 starting in the classifieds_Ads database are of course in the "Tables" add your new column,

for the phone number you could use a nvarchar(50) for the type.

(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.

Follow how the others are set like adtype, location, url . . . In this case when you declare it you can do it "As String"

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 Phone.)

I prefer to do this part manually to keep the Scheme,

(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.

And of course the postad, and editad page.

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.

Daniel

 

Very well done and beautifull your website!!

Thank you for the compliment.

Did you figure it out??

Hi!

lol,Still got pbms! so i send you copy of my BLL/ads.vb code,and DAL/ads.xsd code as i modified it to add "phone". Can you say me what's wrong?

BLL/ads.vb code:

Imports System

Imports System.Web

Imports System.Web.Security

Imports System.Text

Imports System.Net.Mail

Imports System.Collections

Imports System.Collections.Generic

Imports AdsDataComponentTableAdapters

Imports AspNet.StarterKits.Classifieds.Web

''' <summary>

''' Describes the type of an ad: "For Sale" or "Wanted."

''' "Unspecified" is used to indicate a variable of this type has not yet been set.

''' </summary>

End Enum

''' <summary>

''' Describes the level, or priority, of an ad.

''' This value is used when ordering results (highest to lowest)

''' on search queries and it can affect the display of rows.

'''

''' "Featured" indicates that the ad will be selected by the "Featured Ad" control

''' that rotates ads to display on the site.

''' "Unspecified" is used to indicate a variable of this type has not yet been set.

'''

''' Use this enumeration to differentiate ads with different priorities

''' or even price points.

''' </summary>

End Enum

''' <summary>

''' Describes the status of an ad:

''' Only ads with positive AdStatus values will be displayed on the public site;

''' administrators will be able to see all.

'''

'''

'''

''' "Unspecified" is used to indicate a variable of this type has not yet been set.

''' </summary>

End Enum

End Sub

#Region "InsertingAds"

Public Shared Function InsertAd(ByVal memberId As Integer, ByVal categoryId As Integer, ByVal title As String, ByVal description As String, ByVal url As String, ByVal price As Decimal, ByVal location As String, ByVal numDaysActive As Integer, ByVal adLevel As AdLevel, ByVal adStatus As AdStatus, ByVal adType As AdType, ByVal Phone As String) As Integer

Dim numViews As Integer = 0

Dim dateCreated As DateTime = DateTime.Now

If numDaysActive > s.MaxAdRunningDays Then

End If

If numDaysActive < 1 Then

End If

If s.AdActivationRequired Then

dateApproved = Nothing

Else

End If

If adLevel = adLevel.Unspecified Then

End If

Dim ad As AdsDataComponent.AdsRow = Nothing

adId = CInt(db.InsertAd(memberId, categoryId, title, description, url, price, location, expirationDate, dateCreated, dateApproved, numViews, numResponses, CInt(adLevel), CInt(adStatus), CInt(adType), ))

If s.AdminNotification = AdminNotificationSetting.EachAd Then

End If

End Using

If Not (ad Is Nothing) Then

End If

End Function

End Using

End Sub

Using db As New AdsDataAdapter()

Dim i As Integer

End Using

#End Region

#Region "GetAds..."

Using db As New AdsDataAdapter()

End Using

Dim escapedSearchTerm As String = AdsDB.EscapeWildcardCharacters(searchTerm)

Dim minCreatedDate As System.Nullable(Of DateTime)

If location Is Nothing Then

location = ""

End If

If dayRange > 0 Then

End If

' To return no results if the searchTerm is empty remove the following

' check on the searchTerm.

If searchTerm Is Nothing Then

searchTerm = ""

End If

Dim aa As AdsDataComponent.AdsDataTable = Nothing

End Using

Return GetAdsByStatus(AdStatus.ActivationPending, DefaultValues.IdNullValue)

Return GetAdsByStatus(AdStatus.ActivationPending, memberId)

Return GetAdsByStatus(AdStatus.Activated, memberId)

Return GetAdsByStatus(AdStatus.Inactive, memberId)

Using db As New AdsDataAdapter()

End Using

Return GetAdsByStatus(adStatus, DefaultValues.IdNullValue)

If maxNumAds < 1 Then

Return Nothing

End If

Return db.GetAdsByRandomOrder(maxNumAds, CInt(AdStatus.Activated), CInt(AdLevel.Featured))

End Using

Using db As New AdsDataAdapter()

End Using

#End Region

#Region "Update Ads"

If (url Is Nothing) Then

End If

End Using

Dim s As SiteSettings = SiteSettings.GetSharedSettings()

Dim dateApproved As System.Nullable(Of DateTime)

If numDaysActive > s.MaxAdRunningDays Then

End If

If numDaysActive < 1 Then

End If

If s.AdActivationRequired Then

dateApproved = Nothing

Else

End If

If adLevel = adLevel.Unspecified Then

End If

Dim ad As AdsDataComponent.AdsRow = Nothing

db.RelistAd(adId, categoryId, title, description, url, price, location, expirationDate, dateCreated, dateApproved, CInt(adLevel), CInt(adStatus), CInt(adType))

If s.AdminNotification = AdminNotificationSetting.EachAd Then

End If

End Using

If Not (ad Is Nothing) Then

End If

End Using

End Using

End Using

Using db As New AdsDataAdapter()

End Using