protected void Application_Start(object sender, EventArgs e) { DAL.DAL dal = new DAL.DAL(); dal.open(); DataTable dt = new DataTable(); dt = dal.RunQuery("select * from depts"); if (dt.Rows.Count == 0) { dal.ExcuChange("insert into depts VALUES('Admin')"); dal.ExcuChange("insert into depts VALUES('Softwaer')"); dal.ExcuChange("insert into depts VALUES('Netowork')"); dal.ExcuChange("insert into depts VALUES('Computer')"); } dt = dal.RunQuery("select * from users"); if (dt.Rows.Count == 0) { dt = dal.RunQuery("select id from Depts where name='admin'"); int value = Convert.ToInt32(dt.Rows[0][0]); dal.ExcuChange("Insert into Users Values('hassan','khabaz','mohanad','2010/2/2','0968845632','*****@*****.**','123456789'," + value + ") "); } dal.close(); }
protected void Session_Start(object sender, EventArgs e) { DAL.DAL dal = new DAL.DAL(); DataTable dt = new DataTable(); dal.open(); dt = dal.RunQuery("select id from Depts where name='admin'"); Session["idadmin"] = dt.Rows[0][0].ToString(); dt = dal.RunQuery("select id from Depts where name='Softwaer'"); Session["idsoftwaer"] = dt.Rows[0][0].ToString(); dt = dal.RunQuery("select id from Depts where name='Netowork'"); Session["idnetwork"] = dt.Rows[0][0].ToString(); dt = dal.RunQuery("select id from Depts where name='Computer'"); Session["idcomputer"] = dt.Rows[0][0].ToString(); dal.close(); }