public void UPDATE_Research(string Unique_num, int doctor_code, string title_research, string type, string date, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@Unique_num", SqlDbType.VarChar);
param[0].Value = Unique_num;
param[1] = new SqlParameter("@doctor_code", SqlDbType.Int);
param[1].Value = doctor_code;
param[2] = new SqlParameter("@title_research", SqlDbType.VarChar);
param[2].Value = title_research;
param[3] = new SqlParameter("@type", SqlDbType.VarChar);
param[3].Value = type;
param[4] = new SqlParameter("@date", SqlDbType.Date);
param[4].Value = date;
param[5] = new SqlParameter("@Research_code", SqlDbType.Int);
param[5].Value = id;
DAL.ExectCommand("UPDATE_Research", param);
DAL.close();
}
public void ADD_Course_B_D(int id_course, int id_doctor, int id_intake, string id_book, int id_program, string from_date, string to_date, string plan)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@course_code", SqlDbType.Int);
param[0].Value = id_course;
param[1] = new SqlParameter("@doctor_code", SqlDbType.Int);
param[1].Value = id_doctor;
param[2] = new SqlParameter("@Intake_code", SqlDbType.Int);
param[2].Value = id_intake;
param[3] = new SqlParameter("@ISPN", SqlDbType.VarChar);
param[3].Value = id_book;
param[4] = new SqlParameter("@program_code", SqlDbType.Int);
param[4].Value = id_program;
param[5] = new SqlParameter("@from_date", SqlDbType.Date);
param[5].Value = from_date;
param[6] = new SqlParameter("@to_date", SqlDbType.Date);
param[6].Value = to_date;
param[7] = new SqlParameter("@plan", SqlDbType.VarChar);
param[7].Value = plan;
DAL.ExectCommand("ADD_Course_B_D", param);
DAL.close();
}
public void UPDATE_Exam(int course_code, int doctor_code, int Intake_code, string date_Exam, string date_resetExam, string path, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@course_code", SqlDbType.Int);
param[0].Value = course_code;
param[1] = new SqlParameter("@doctor_code", SqlDbType.Int);
param[1].Value = doctor_code;
param[2] = new SqlParameter("@Intake_code", SqlDbType.Int);
param[2].Value = Intake_code;
param[3] = new SqlParameter("@date_Exam", SqlDbType.Date);
param[3].Value = date_Exam;
param[4] = new SqlParameter("@date_resetExam", SqlDbType.Date);
param[4].Value = date_resetExam;
param[5] = new SqlParameter("@path", SqlDbType.VarChar);
param[5].Value = path;
param[6] = new SqlParameter("@Exam_code", SqlDbType.Int);
param[6].Value = id;
DAL.ExectCommand("UPDATE_Exam", param);
DAL.close();
}
public void UPDATE_Attendances(string Unique_num, int houre_come, int houre_absence, string date, int Intake_code, int course_code, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Unique_num", SqlDbType.VarChar);
param[0].Value = Unique_num;
param[1] = new SqlParameter("@houre_come", SqlDbType.Int);
param[1].Value = houre_come;
param[2] = new SqlParameter("@houre_absence", SqlDbType.Int);
param[2].Value = houre_absence;
param[3] = new SqlParameter("@date", SqlDbType.Date);
param[3].Value = date;
param[4] = new SqlParameter("@Intake_code", SqlDbType.Int);
param[4].Value = Intake_code;
param[5] = new SqlParameter("@course_code", SqlDbType.Int);
param[5].Value = course_code;
param[6] = new SqlParameter("@code", SqlDbType.Int);
param[6].Value = id;
DAL.ExectCommand("UPDATE_Attendances", param);
DAL.close();
}
public void UPDATE_Book(string name, string publisher, string auther, string text_book, string id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
param[1] = new SqlParameter("@publisher", SqlDbType.VarChar);
param[1].Value = publisher;
param[2] = new SqlParameter("@auther", SqlDbType.VarChar);
param[2].Value = auther;
param[3] = new SqlParameter("@text_book", SqlDbType.VarChar);
param[3].Value = text_book;
param[4] = new SqlParameter("@ISPN", SqlDbType.VarChar);
param[4].Value = id;
DAL.ExectCommand("UPDATE_Book", param);
DAL.close();
}
public void UPDATE_Discussant(int ntake_code, string Unique_num, string Internal_Examainer, string External_Examiner, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@Intake_code", SqlDbType.Int);
param[0].Value = ntake_code;
param[1] = new SqlParameter("@Unique_num", SqlDbType.VarChar);
param[1].Value = Unique_num;
param[2] = new SqlParameter("@Internal_Examainer", SqlDbType.VarChar);
param[2].Value = Internal_Examainer;
param[3] = new SqlParameter("@External_Examiner", SqlDbType.VarChar);
param[3].Value = External_Examiner;
param[4] = new SqlParameter("@id", SqlDbType.Int);
param[4].Value = id;
DAL.ExectCommand("UPDATE_Discussant", param);
DAL.close();
}
public void Add_Grade(int course_code, int Intake_code, string Unique_num, decimal Assignment, decimal final_Exam, decimal Total_grade, string year)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@course_code", SqlDbType.Int);
param[0].Value = course_code;
param[1] = new SqlParameter("@Intake_code", SqlDbType.Int);
param[1].Value = Intake_code;
param[2] = new SqlParameter("@Unique_num", SqlDbType.VarChar);
param[2].Value = Unique_num;
param[3] = new SqlParameter("@Assignment", SqlDbType.Decimal);
param[3].Value = Assignment;
param[4] = new SqlParameter("@final_Exam", SqlDbType.Decimal);
param[4].Value = final_Exam;
param[5] = new SqlParameter("@Total_grade", SqlDbType.Decimal);
param[5].Value = Total_grade;
param[6] = new SqlParameter("@year", SqlDbType.Date);
param[6].Value = year;
DAL.ExectCommand("Add_Grade", param);
DAL.close();
}
public void UPDATE_Registered_Student(string TOEFL, string Specialization, string Worked_Fulltime, string document_path, int Intake_code, string accepted, string id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@TOEFL", SqlDbType.VarChar);
param[0].Value = TOEFL;
param[1] = new SqlParameter("@Specialization", SqlDbType.VarChar);
param[1].Value = Specialization;
param[2] = new SqlParameter("@Worked_Fulltime", SqlDbType.VarChar);
param[2].Value = Worked_Fulltime;
param[3] = new SqlParameter("@document_path", SqlDbType.VarChar);
param[3].Value = document_path;
param[4] = new SqlParameter("@Intake_code", SqlDbType.Int);
param[4].Value = Intake_code;
param[5] = new SqlParameter("@accepted", SqlDbType.VarChar);
param[5].Value = accepted;
param[6] = new SqlParameter("@Unique_num", SqlDbType.VarChar);
param[6].Value = id;
DAL.ExectCommand("UPDATE_Registered_Student", param);
DAL.close();
}
public void UPDATE_Acadimic_Staff(string first_name, string middle_name, string last_name, int cell_phone, int office_phone, int fax, string sex, string major, string scientific_degree, string qualifies, string organization, string nationality, string cv, string address, string date, int doctor_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[16];
param[0] = new SqlParameter("@first_name", SqlDbType.VarChar);
param[0].Value = first_name;
param[1] = new SqlParameter("@middle_name", SqlDbType.VarChar);
param[1].Value = middle_name;
param[2] = new SqlParameter("@last_name", SqlDbType.VarChar);
param[2].Value = last_name;
param[3] = new SqlParameter("@cell_phone", SqlDbType.Int);
param[3].Value = cell_phone;
param[4] = new SqlParameter("@office_phone", SqlDbType.Int);
param[4].Value = office_phone;
param[5] = new SqlParameter("@fax", SqlDbType.Int);
param[5].Value = fax;
param[6] = new SqlParameter("@sex", SqlDbType.VarChar);
param[6].Value = sex;
param[7] = new SqlParameter("@major", SqlDbType.VarChar);
param[7].Value = major;
param[8] = new SqlParameter("@scientific_degree", SqlDbType.VarChar);
param[8].Value = scientific_degree;
param[9] = new SqlParameter("@qualifies", SqlDbType.VarChar);
param[9].Value = qualifies;
param[10] = new SqlParameter("@organization", SqlDbType.VarChar);
param[10].Value = organization;
param[11] = new SqlParameter("@nationality", SqlDbType.VarChar);
param[11].Value = nationality;
param[12] = new SqlParameter("@cv", SqlDbType.VarChar);
param[12].Value = cv;
param[13] = new SqlParameter("@address", SqlDbType.VarChar);
param[13].Value = address;
param[14] = new SqlParameter("@date", SqlDbType.Date);
param[14].Value = date;
param[15] = new SqlParameter("@doctor_code", SqlDbType.Int);
param[15].Value = doctor_code;
DAL.ExectCommand("UPDATE_Acadimic_Staff", param);
DAL.close();
}
public void ADD_states(string name)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
DAL.ExectCommand("Add_states", param);
DAL.close();
}
public void DELETE_Exam(int Exam_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Exam_code", SqlDbType.Int);
param[0].Value = Exam_code;
DAL.ExectCommand("DELETE_Exam", param);
DAL.close();
}
public void DELETE_Discussant(int code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@code", SqlDbType.Int);
param[0].Value = code;
DAL.ExectCommand("DELETE_Discussant", param);
DAL.close();
}
public void ADD_Program(string name, string type)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
param[1] = new SqlParameter("@type", SqlDbType.VarChar);
param[1].Value = type;
DAL.ExectCommand("Add_Program", param);
DAL.close();
}
public void DELETE_USERS(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@user_code", SqlDbType.Int);
param[0].Value = id;
DAL.ExectCommand("DELETE_USERS", param);
DAL.close();
}
public void UPDATE_request_course(string accepted, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@accepted", SqlDbType.VarChar);
param[0].Value = accepted;
param[1] = new SqlParameter("@code", SqlDbType.Int);
param[1].Value = id;
DAL.ExectCommand("UPDATE_request_course", param);
DAL.close();
}
public void DELETE_Book(string id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ISPN", SqlDbType.VarChar);
param[0].Value = id;
DAL.ExectCommand("DELETE_Book", param);
DAL.close();
}
public void UPDATE_grievance_cba(string accepted, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@accepted", SqlDbType.Char);
param[0].Value = accepted;
param[1] = new SqlParameter("@ID", SqlDbType.Int);
param[1].Value = id;
DAL.ExectCommand("UPDATE_grievance_cba", param);
DAL.close();
}
public void UPDATE_states(string name, int state_id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
param[1] = new SqlParameter("@id", SqlDbType.Int);
param[1].Value = state_id;
DAL.ExectCommand("UPDATE_states", param);
DAL.close();
}
public void UPDATE_Program(string name, string type, int program_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@name", SqlDbType.VarChar, 50);
param[0].Value = name;
param[1] = new SqlParameter("@type", SqlDbType.VarChar, 50);
param[1].Value = type;
param[2] = new SqlParameter("@id", SqlDbType.Int);
param[2].Value = program_code;
DAL.ExectCommand("UPDATE_Program", param);
DAL.close();
}
public void ADD_intake(string name, int num, string year)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
param[1] = new SqlParameter("@num", SqlDbType.Int);
param[1].Value = num;
param[2] = new SqlParameter("@year", SqlDbType.Date);
param[2].Value = year;
DAL.ExectCommand("Add_intake", param);
DAL.close();
}
public void ADD_USERS(string user_name, string password, int priv_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@user_name", SqlDbType.NVarChar);
param[0].Value = user_name;
param[1] = new SqlParameter("@password", SqlDbType.NVarChar);
param[1].Value = password;
param[2] = new SqlParameter("@priv_code", SqlDbType.NVarChar);
param[2].Value = priv_code;
DAL.ExectCommand("Add_USER", param);
DAL.close();
}
public void ADD_Courses(string name, string type, int houres, string ECTS)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
param[1] = new SqlParameter("@type", SqlDbType.VarChar);
param[1].Value = type;
param[2] = new SqlParameter("@houres", SqlDbType.Int);
param[2].Value = houres;
param[3] = new SqlParameter("@ECTS", SqlDbType.Int);
param[3].Value = ECTS;
DAL.ExectCommand("Add_Course", param);
DAL.close();
}
public void UPDATE_intake(string name, int num, string year, int Intake_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@name", SqlDbType.VarChar);
param[0].Value = name;
param[1] = new SqlParameter("@num", SqlDbType.Int);
param[1].Value = num;
param[2] = new SqlParameter("@year", SqlDbType.Date);
param[2].Value = year;
param[3] = new SqlParameter("@id", SqlDbType.Int);
param[3].Value = Intake_code;
DAL.ExectCommand("UPDATE_intake", param);
DAL.close();
}
public void UPDATE_Courses(string name, string type, int houres, string ECTS, int course_code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@name", SqlDbType.VarChar, 50);
param[0].Value = name;
param[1] = new SqlParameter("@type", SqlDbType.VarChar, 50);
param[1].Value = type;
param[2] = new SqlParameter("@houres", SqlDbType.Int);
param[2].Value = houres;
param[3] = new SqlParameter("@ECTS", SqlDbType.VarChar);
param[3].Value = ECTS;
param[4] = new SqlParameter("@course_code", SqlDbType.Int);
param[4].Value = course_code;
DAL.ExectCommand("UPDATE_Courses", param);
DAL.close();
}
public void ADD_Grade_Discussant(string Unique_num, decimal grade_disc_Supervisor, decimal grade_disc_internal, decimal grade_disc_external)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@Unique_num", SqlDbType.VarChar);
param[0].Value = Unique_num;
param[1] = new SqlParameter("@grade_disc_Supervisor", SqlDbType.Decimal);
param[1].Value = grade_disc_Supervisor;
param[2] = new SqlParameter("@grade_disc_internal", SqlDbType.Decimal);
param[2].Value = grade_disc_internal;
param[3] = new SqlParameter("@grade_disc_external", SqlDbType.Decimal);
param[3].Value = grade_disc_external;
DAL.ExectCommand("ADD_Grade_Discussant", param);
DAL.close();
}
public void UPDATE_USERS(string user_name, string password, int priv_code, int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@user_name", SqlDbType.NVarChar);
param[0].Value = user_name;
param[1] = new SqlParameter("@password", SqlDbType.NVarChar);
param[1].Value = password;
param[2] = new SqlParameter("@priv_code", SqlDbType.Int);
param[2].Value = priv_code;
param[3] = new SqlParameter("@user_code", SqlDbType.Int);
param[3].Value = id;
DAL.ExectCommand("UPDATE_USERS", param);
DAL.close();
}
