public void Add_Lesson(string category_cat, string class_cat, string course_cat, string lecturer_cat, string day_cat, int strt_cat, int end_cat, int numOfStud)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[8];
p[0] = new SqlParameter("@Type", SqlDbType.NVarChar, 50);
p[0].Value = category_cat;
p[1] = new SqlParameter("@ClassRoom", SqlDbType.NVarChar, 20);
p[1].Value = class_cat;
p[2] = new SqlParameter("@CourseID", SqlDbType.NVarChar, 10);
p[2].Value = course_cat;
p[3] = new SqlParameter("@LecturerID", SqlDbType.NVarChar, 20);
p[3].Value = lecturer_cat;
p[4] = new SqlParameter("@Day", SqlDbType.NVarChar, 10);
p[4].Value = day_cat;
p[5] = new SqlParameter("@StrtTime", SqlDbType.Int);
p[5].Value = strt_cat;
p[6] = new SqlParameter("@EndTime", SqlDbType.Int);
p[6].Value = end_cat;
p[7] = new SqlParameter("@Numofstud", SqlDbType.Int);
p[7].Value = numOfStud;
DAl.Execute("Add_Lesson", p);
DAl.close();
}
public void add_user(string ID, string name, string password, string permission, string address, string email, string isLogged)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[7];
p[0] = new SqlParameter("@ID", SqlDbType.NChar, 10);
p[0].Value = ID;
p[1] = new SqlParameter("@Name", SqlDbType.NVarChar);
p[1].Value = name;
p[2] = new SqlParameter("@Password", SqlDbType.NChar, 10);
p[2].Value = password;
p[3] = new SqlParameter("@Permission", SqlDbType.NChar, 10);
p[3].Value = permission;
p[4] = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
p[4].Value = address;
p[5] = new SqlParameter("@Email", SqlDbType.NVarChar);
p[5].Value = email;
p[6] = new SqlParameter("@isLogged", SqlDbType.NChar);
p[6].Value = "false";
DAl.Execute("add_user", p);
DAl.close();
}
public void Add_Course(string CourseID, string name, int hoursPerWk, float point, string category, Boolean pract, Boolean lab, string semester)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[8];
p[0] = new SqlParameter("@CourseID", SqlDbType.NVarChar, 10);
p[0].Value = CourseID;
p[1] = new SqlParameter("@Name", SqlDbType.NVarChar, 50);
p[1].Value = name;
p[2] = new SqlParameter("@HoursPerWk", SqlDbType.Int);
p[2].Value = hoursPerWk;
p[3] = new SqlParameter("@Point", SqlDbType.Float);
p[3].Value = point;
p[4] = new SqlParameter("@Category", SqlDbType.NVarChar, 20);
p[4].Value = category;
p[5] = new SqlParameter("@Lab", SqlDbType.Bit);
p[5].Value = lab;
p[6] = new SqlParameter("@Practition", SqlDbType.Bit);
p[6].Value = pract;
p[7] = new SqlParameter("@Semester", SqlDbType.NChar, 10);
p[7].Value = semester;
DAl.Execute("AddCourse", p);
DAl.close();
}
public DataTable get_all_users()
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
DataTable dt = new DataTable();
dt = DAl.SelectData("get_all_users", null);
DAl.close();
return(dt);
}
public void delete_user(string ID)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@ID", SqlDbType.NChar, 10);
p[0].Value = ID;
DAl.Execute("delete_user", p);
DAl.close();
}
public void Delete_Classroom(string name)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@name", SqlDbType.NVarChar, 50);
p[0].Value = name;
DAl.Execute("Deleting_Classroom", p);
DAl.close();
}
public void Delete_Course(string CourseID)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@CourseID", SqlDbType.NVarChar, 10);
p[0].Value = CourseID;
DAl.Execute("Deleting_Course", p);
DAl.close();
}
public DataTable Verify_CourseID(string CourseID)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@CourseID", SqlDbType.NVarChar, 10);
p[0].Value = CourseID;
dt = DAl.SelectData("Verify_CourseID", p);
DAl.close();
return(dt);
}
public bool Delete_Course(string CourseID)
{
if (Verify_CourseID(CourseID).Rows.Count == 1)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("@CourseID", SqlDbType.NVarChar, 10);
p[0].Value = CourseID;
DAl.Execute("Deleting_Course", p);
DAl.close();
return(true);
}
return(false);
}
public void Update_Classroom(string name, int seats_num, Boolean proj, Boolean comp)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
try
{
DAl.open();
SqlCommand cmd = new SqlCommand("UPDATE Class SET seats_num=@seats_num, projector=@projector, computer=@computer WHERE name = @name", DAl.Return_Connection());
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@seats_num", seats_num);
cmd.Parameters.AddWithValue("@projector", proj);
cmd.Parameters.AddWithValue("@computer", comp);
cmd.ExecuteNonQuery();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
DAl.close();
}
public void Update_Lesson(string class_cat, string lecturer_cat, int id)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@ClassRoom", SqlDbType.NVarChar, 20);
p[0].Value = class_cat;
p[1] = new SqlParameter("@LecturerID", SqlDbType.NVarChar, 20);
p[1].Value = lecturer_cat;
p[2] = new SqlParameter("@id", SqlDbType.Int);
p[2].Value = id;
DAl.Execute("Update_Lesson", p);
DAl.close();
}
public void Add_Classroom(string name, int seats_num, Boolean proj, Boolean comp)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@name", SqlDbType.NVarChar, 50);
p[0].Value = name;
p[1] = new SqlParameter("@seats_num", SqlDbType.Int);
p[1].Value = seats_num;
p[2] = new SqlParameter("@projector", SqlDbType.Bit);
p[2].Value = proj;
p[3] = new SqlParameter("@computer", SqlDbType.Bit);
p[3].Value = comp;
DAl.Execute("Adding_Classroom", p);
DAl.close();
}
public DataTable Verify_lecConstraint(string lecID, string day, int StrtTime, int EndTime)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[4];
p[0] = new SqlParameter("@LecturerID", SqlDbType.NVarChar, 20);
p[0].Value = lecID;
p[1] = new SqlParameter("@Day", SqlDbType.NVarChar, 10);
p[1].Value = day;
p[2] = new SqlParameter("@StrtTime", SqlDbType.Int);
p[2].Value = StrtTime;
p[3] = new SqlParameter("@EndTime", SqlDbType.Int);
p[3].Value = EndTime;
dt = DAl.SelectData("Verify_lecConstraint", p);
DAl.close();
return(dt);
}
public DataTable get_labClassID(string d, int strt, int end)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@day", SqlDbType.NVarChar, 10);
p[0].Value = d;
p[1] = new SqlParameter("@StrtTime", SqlDbType.Int);
p[1].Value = strt;
p[2] = new SqlParameter("@EndTime", SqlDbType.Int);
p[2].Value = end;
dt = DAl.SelectData("get_labClassID", p);
DAl.close();
return(dt);
}
public DataTable get_lecID(string day, int StrtTime, int EndTime)
{
Project_Sce.DAL.DataBase DAl = new Project_Sce.DAL.DataBase();
DAl.open();
DataTable dt = new DataTable();
SqlParameter[] p = new SqlParameter[3];
p[0] = new SqlParameter("@day", SqlDbType.NVarChar, 10);
p[0].Value = day;
p[1] = new SqlParameter("@StrtTime", SqlDbType.Int);
p[1].Value = StrtTime;
p[2] = new SqlParameter("@EndTime", SqlDbType.Int);
p[2].Value = EndTime;
dt = DAl.SelectData("get_lecID", p);
DAl.close();
return(dt);
}
