public static DataSet getInfoProjectName(string IDStudent)
{
string[] para = new string[1] {
"@ID"
};
object[] value = new object[1] {
IDStudent
};
return(MyDB.FillDataSet("procedureProjectsForCombobox", CommandType.StoredProcedure, para, value));
}
public static DataSet getStudentScore(string PID)
{
string[] para = new string[1] {
"@PID"
};
object[] value = new object[1] {
PID
};
return(MyDB.FillDataSet("procedureGetAllScoreByProject", CommandType.StoredProcedure, para, value));
}
public DataSet CheckDangNhap()
{
string[] paras = new string[2] {
"@Username", "@Password"
};
object[] values = new object[2] {
Username, Password
};
return(MyDB.FillDataSet("procedureCheckDangNhap", CommandType.StoredProcedure, paras, values));
}
//public int getproject(string IDStudent)
//{
// //DataTable check = data.readdata("select * from Project WHERE PID in ( SELECT Project_PID FROM StudentProjects WHERE Student_ID='" + IDStudent + "');");
// DataSet check = MyDB.Execute_Sql("Select distinct(Project.PID), Project.PName, Project.PContent, Project.PType, Project.PBegin, Project.PEnd, Score.score, Score.comment " +
// "from Project Left Join Score ON(Project.PID = Score.PID)"+
// "Where Project.PID in (SELECT Project_PID FROM StudentProjects WHERE Student_ID = '" + IDStudent + "');");
// return check;
//}
public static DataSet FillDataSetProject(string IDStudent)
{
//DataSet check = MyDB.FillDataSet("Select distinct(Project.PID), Project.PName, Project.PContent, Project.PType, Project.PBegin, Project.PEnd, Score.score, Score.comment " +
// "from Project Left Join Score ON(Project.PID = Score.PID)" +
// "Where Project.PID in (SELECT Project_PID FROM StudentProjects WHERE Student_ID = '" + IDStudent + "');", CommandType.Text);
string[] para = new string[1] {
"@ID"
};
object[] value = new object[1] {
IDStudent
};
return(MyDB.FillDataSet("procedureGetProjectsByStudent", CommandType.StoredProcedure, para, value));
}
internal DataSet FillDataSet_getProjectById()
{
DataSet ds = new DataSet();
string[] paras = new string[1] {
"@PID"
};
object[] values = new object[1] {
PID
};
ds = MyDB.FillDataSet("procedureGetBanByID", CommandType.StoredProcedure, paras, values);
return(ds);
}
public DataSet obtainInformationStudentByName()
{
DataSet ds = new DataSet();
string[] paras = new string[1] {
"@Fullname"
};
object[] values = new object[1] {
ID
};
ds = MyDB.FillDataSet("procedureObtainStudentByName", CommandType.StoredProcedure, paras, values);
return(ds);
}
public DataSet FillDataSet_getTaiKhoanByID()
{
DataSet ds = new DataSet();
string[] paras = new string[1] {
"@ID"
};
object[] values = new object[1] {
ID
};
ds = MyDB.FillDataSet("procedureGetTaiKhoanByID", CommandType.StoredProcedure, paras, values);
return(ds);
}
public static DataSet getStudentScore()
{
return(MyDB.FillDataSet("SELECT * FROM dbo.viewScore", CommandType.Text));
}
public static DataSet getProjectName()
{
return(MyDB.FillDataSet("SELECT * FROM dbo.viewProject", CommandType.Text));
}
public static DataSet StudentFeedback(string IDProject)
{
return(MyDB.FillDataSet("select * from Student WHERE ID in ( SELECT Student_ID FROM StudentProjects WHERE Project_PID='" + IDProject + "');", CommandType.Text));
}
public static DataSet FillDataSetTaiKhoan()
{
return(MyDB.FillDataSet("SELECT * FROM viewGetTaiKhoan", CommandType.Text));
}