tables.txt

PURPOSE OF THE PROJECT: This Application would facilitate the huge process of managing the Ad detai

CREATE TABLE MMA_USERS_TB
(
   PK_USERS_ID INTEGER IDENTITY(100,1) PRIMARY KEY,
   USERS_NAME VARCHAR(30) NOT NULL,
   USERS_PWD VARCHAR(15) NOT NULL,
   USERS_ROLE VARCHAR(1) NOT NULL
)



CREATE TABLE MMA_PRODUCTS_TB
(

	PK_PROD_ID INTEGER PRIMARY KEY,
	PROD_PNAME VARCHAR(30) NOT NULL
)




CREATE TABLE MMA_MODELS_TB
(
	PK_MOD_ID INTEGER PRIMARY KEY,
	FK_MOD_PROD_ID INTEGER FOREIGN KEY REFERENCES MMA_PRODUCTS_TB(PK_PROD_ID),
	MOD_NAME VARCHAR(30) NOT NULL,
	MOD_ADNUM INTEGER NOT NULL
)




CREATE TABLE MMA_ADS_TB
(
PK_ADS_ID INTEGER IDENTITY(1000,1) PRIMARY KEY,
FK_ADS_PROD_ID INTEGER FOREIGN KEY REFERENCES MMA_PRODUCTS_TB(PK_PROD_ID),
FK_ADS_MOD_ID INTEGER FOREIGN KEY REFERENCES MMA_MODELS_TB(PK_MOD_ID),
FK_ADS_USERS_ID INTEGER FOREIGN KEY REFERENCES MMA_USERS_TB(PK_USERS_ID),
ADS_VOICE VARCHAR(30) NOT NULL,
ADS_DURATION VARCHAR(10) NOT NULL,
ADS_CONTENT VARCHAR(30) NOT NULL,
ADS_VERSION VARCHAR(10) NOT NULL,
ADS_RELEASE VARCHAR(30) NOT NULL,
ADS_NAME VARCHAR(30) NOT NULL,
ADS_STATUS VARCHAR(20) NOT NULL,
ADS_MODDATE VARCHAR(30) NOT NULL,
ADS_REMARKS VARCHAR(100) NOT NULL
)



CREATE VIEW MMA_ALLDETAILS_VW AS 
SELECT
MMA_PRODUCTS_TB.PROD_PNAME as ALDTLS_PNAME,MMA_PRODUCTS_TB.PK_PROD_ID AS ALDTLS_PID,MMA_MODELS_TB.MOD_NAME AS ALDTLS_MNAME,MMA_MODELS_TB.PK_MOD_ID AS ALDTLS_MID,MMA_MODELS_TB.MOD_ADNUM AS ALDTLS_MADNUM,MMA_USERS_TB.PK_USERS_ID AS ALDTLS_UID,MMA_USERS_TB.USERS_NAME AS ALDTLS_UNAME,MMA_USERS_TB.USERS_ROLE AS ALDTLS_UROLE,MMA_ADS_TB.PK_ADS_ID AS ALDTLS_AID,MMA_ADS_TB.ADS_VOICE AS ALDTLS_AVOICE,MMA_ADS_TB.ADS_DURATION AS ALDTLS_ADURATION,MMA_ADS_TB.ADS_CONTENT AS ALDTLS_ACONTENT,MMA_ADS_TB.ADS_VERSION AS ALDTLS_AVERSION,MMA_ADS_TB.ADS_RELEASE AS ALDTLS_ARELEASE,MMA_ADS_TB.ADS_NAME AS ALDTLS_ANAME,MMA_ADS_TB.ADS_STATUS AS ALDTLS_ASTATUS,MMA_ADS_TB.ADS_MODDATE AS ALDTLS_AMODDATE,MMA_ADS_TB.ADS_REMARKS AS ALDTLS_AREMARKS
FROM MMA_PRODUCTS_TB,MMA_USERS_TB,MMA_MODELS_TB,MMA_ADS_TB
WHERE
   MMA_MODELS_TB.FK_MOD_PROD_ID = MMA_PRODUCTS_TB.PK_PROD_ID
AND 
   MMA_ADS_TB.FK_ADS_USERS_ID = MMA_USERS_TB.PK_USERS_ID
AND 
   MMA_ADS_TB.FK_ADS_MOD_ID=MMA_MODELS_TB.PK_MOD_ID




MMA_PRODUCTS_TB.PROD_PNAME as ALDTLS_PNAME,
MMA_PRODUCTS_TB.PK_PROD_ID AS ALDTLS_PID,
MMA_MODELS_TB.MOD_NAME AS ALDTLS_MNAME,
MMA_MODELS_TB.PK_MOD_ID AS ALDTLS_MID,
MMA_MODELS_TB.MOD_ADNUM AS ALDTLS_MADNUM,
MMA_USERS_TB.PK_USERS_ID AS ALDTLS_UID,
MMA_USERS_TB.USERS_NAME AS ALDTLS_UNAME,
MMA_USERS_TB.USERS_ROLE AS ALDTLS_UROLE,
MMA_ADS_TB.PK_ADS_ID AS ALDTLS_AID,
MMA_ADS_TB.ADS_VOICE AS ALDTLS_AVOICE,
MMA_ADS_TB.ADS_DURATION AS ALDTLS_ADURATION,
MMA_ADS_TB.ADS_CONTENT AS ALDTLS_ACONTENT,
MMA_ADS_TB.ADS_VERSION AS ALDTLS_AVERSION,
MMA_ADS_TB.ADS_RELEASE AS ALDTLS_ARELEASE,
MMA_ADS_TB.ADS_NAME AS ALDTLS_ANAME,
MMA_ADS_TB.ADS_STATUS AS ALDTLS_ASTATUS,
MMA_ADS_TB.ADS_MODDATE AS ALDTLS_AMODDATE,
MMA_ADS_TB.ADS_REMARKS AS ALDTLS_AREMARKS














if (MyFile.PostedFile.ContentLength == 0)
			{
			lbl.Text ="no file";
			}











if(ext.EndsWith("wav")) 
				{
					string s,s1;
					s= tb.Text;
					s+=".wav";
					s1="C:\\Inetpub\\wwwroot\\Expts\\Audio\\" + s;
					lbl.Text = ext.EndsWith("wav") + " ! " + MyFile.PostedFile.FileName;
					MyFile.PostedFile.SaveAs(s1);
					
				}
				else
				{
lbl.Text = "nop";

			
					
				}



accept="image/gif,image/jpeg"















122,100,1001,5,SRK,2,qwe,3,4,sdfg,Accepted,as,None;
123,100,1001,3,SRK,2,qwe,3,4,sdfg,Accepted,as,None;
124,100,1001,4,Amir,1,qwe,3,4,sdfg,Not Evaluated,as,None;


125,100,1002,4,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
126,100,1002,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
127,100,1001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;






222,200,2001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
223,200,2001,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
224,200,2001,4,Amir,1,qwe,3,4,sdfg,Not Evaluated,as,None;


225,200,2002,4,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
226,200,2002,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
227,200,2001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;







322,300,3001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
323,300,3001,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
324,300,3001,4,Amir,1,qwe,3,4,sdfg,Not Evaluated,as,None;

325,300,3002,4,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
326,300,3002,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
327,300,3001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;






422,400,4001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
423,400,4001,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
424,400,4001,4,Amir,1,qwe,3,4,sdfg,Not Evaluated,as,None;

425,400,4002,4,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
426,400,4002,3,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;
427,400,4001,5,SRK,2,qwe,3,4,sdfg,Not Evaluated,as,None;

,100,1001,102,Female,00:00:30,HarryPotter,1.2.3.0,11/23/2006 2:50:59 PM,HP,Accepted,11/23/2006 2:50:59 PM,good;