Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 130
  • Last Modified:

dynamic classic asp form

Team - I am creating project management application in classic asp. since the milestones will be different from project to project, I created a Template table to save milestones with milestone id and template id as primary and foreign key. I also have a project master table with project id  being primary key. I am facing problem to call the milestones dynamically and saving them to ms sql.

Ex: project id is 5000
template Id is 2000 which has milestone id from 1 to 10.

In the dynamic form I would like to display milestone name, start date, end date, resource name and allocated hours and save them to sql. Kindly help
0
Manju
Asked:
Manju
  • 3
  • 2
1 Solution
 
ManjuIT - Project ManagerAuthor Commented:
To Add:

Tables in SQL:
1. Project Master (ProjectID)
2. Resource Master (ResourceID, ProjectID)
3. Template Master (TemplateID, MilestoneID, MilestoneName)

How do I want my front end to look:
ProjectID (Hidden)
TemplateID (Hidden)
MilestoneId (Hidden)
MilestoneName (Visible)
StartDate (Visible - should be a datepicker)
EndDate (Visible - should be a datepicker)
ResourceName (Visible - drop down from Resourcemaster for this projectid)
Hours (visible - textbox)
Upon "Save" button, it should save the below in "Milestone Master" Table
ProjectID
TemplateID
MilestoneID
MilestoneName
MilestoneStartDate
MilestoneEndDate
ResourceName
AllocatedHours
Status ("New")

Kindly help pls
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
i'm unclear on what you're asking here, can you be more specific? are you looking for someone to write this out for you? i highly doubt you'll find anyone on EE who'll do that. have you written any code yet and are stuck at a specific point?

also, is there a specific reason why you're writing out your own project management app? There are countless ones out there, doing a quick google search for "project management application" yields tons of results. would none of those work for you?
0
 
ManjuIT - Project ManagerAuthor Commented:
I need help in logic. I am able to dynamically display fields that I want but need help in logic so that I can save them correctly in sql. Any help or guide to that direction would be helpful.  Pls
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
You need a way to tie the Templates table to the Projects table, right? I would do this by adding a ProjectID to your Templates table, or if you only have a fixed amount of Templates, create a cross reference table that contains both ProjectID and TemplateID, that way you can properly retrieve your data.

For saving everything, I would created a stored procedure and pass all of the data as parameters into it, then do your INSERT or UPDATE statements there
0
 
ManjuIT - Project ManagerAuthor Commented:
Thanks for pointing me to the right direction. I was able to fix the problem.
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now