// all studennndts public DataTable getAllStd() { connectionClass obj = new connectionClass(); obj.openConn(); DataTable dt = new DataTable(); dt = obj.readData("GET_ALL_STD", null); obj.CloseConn(); return(dt); }
// get all matched std public DataTable getAllMatchedStd(string fname) { SqlParameter[] paraFname = new SqlParameter[1]; connectionClass obj = new connectionClass(); obj.openConn(); paraFname[0] = new SqlParameter("@std_fname", SqlDbType.NVarChar, 30); paraFname[0].Value = fname; DataTable dt = new DataTable(); dt = obj.readData("GET_ALL_MATCHED_STD", paraFname); obj.CloseConn(); return(dt); }
// delete std public void DELETE_STD(int ID) { SqlParameter[] paraStdId = new SqlParameter[1]; connectionClass obj = new connectionClass(); obj.openConn(); paraStdId[0] = new SqlParameter("@STD_ID", SqlDbType.Int); paraStdId[0].Value = ID; obj.excuteCmd("DELETE_STD", paraStdId); obj.CloseConn(); }
// add std public void inserting_std(string fname, string lname, string gname, string gender, string phone = "", string email = "") { SqlParameter[] paraStd = new SqlParameter[6]; connectionClass obj = new connectionClass(); obj.openConn(); paraStd[0] = new SqlParameter("@std_fname ", SqlDbType.NVarChar, 30); paraStd[0].Value = fname; paraStd[1] = new SqlParameter("@std_lname ", SqlDbType.NVarChar, 30); paraStd[1].Value = lname; paraStd[2] = new SqlParameter("@std_gname ", SqlDbType.NVarChar, 30); paraStd[2].Value = gname; paraStd[3] = new SqlParameter("@std_gender", SqlDbType.NVarChar, 5); paraStd[3].Value = gender; paraStd[4] = new SqlParameter("@std_phone", SqlDbType.NVarChar, 15); paraStd[4].Value = phone; paraStd[5] = new SqlParameter("@std_email", SqlDbType.NVarChar, 50); paraStd[5].Value = email; obj.excuteCmd("ADD_STD", paraStd); obj.CloseConn(); MessageBox.Show("تمت اضافة الطالب " + fname + " " + lname + " بنجاح"); }