I'm building kind of a online-newspaper project,but now I'm stuck in the Admin part, I will describe it like this :
There are 2 tables in SQL Server that I store all the news ,I call it 1 and 2,
1 store all the news : Pending and also the Published, and 2 store only the Published.
There's 1 acc for the admin and many for the reporters
+ The reporter write a news on the site, a database store it with the status : Pending -> store in the table 1.
+The Admin can write a news also.
+ The Admin comes to the site everyday, check if there's some Pending news, read them, edit, and change the status to Published -> save changes in table 1 and create a new record in table 2.
+The Admin want to edit a news with the status "Published" , he change it in table 2, and when he save , also that news in table 1 also will be save.
+The Admin want to delete a news with the status "Published", he delete it in table 2, and also that news in table 1 will be delete.
I don't know if it's enough for all the case happen.
And now it's hard for me to show all of them in 1 aspx page.
With the page Admin_news.aspx , I have to do tasks : create new Pending/Published news, edit Pending/Published news, change Pending/Published news status, delete Pending/Published news .
I put a radio button on the page for the Admin can change the status : Pending and Published.
All I need is an idea, how to do it in the right way.
And if you have any experiences in this kind of project, pls advise any idea to make it improve .
Very appriciate with all comments. Nice day