public int DeleteProject()
{
string[] paras = new string[1] {
"@PID"
};
object[] values = new object[1] {
PID
};
return(MyDB.Execute_Sql("procedureDeleteProject", CommandType.StoredProcedure, paras, values));
}
public int UpdateProject()
{
string[] paras = new string[6] {
"@PID", "@PName", "@PContent", "@PType", "@PBegin", "@PEnd"
};
object[] values = new object[6] {
PID, PName, PContent, PType, PBegin, PEnd
};
return(MyDB.Execute_Sql("procedureUpdateProject", CommandType.StoredProcedure, paras, values));
}
public int UpdateStudent()
{
string[] paras = new string[8] {
"@ID", "@Fullname", "@Picture", "@Birthday", "@Gender", "@Class", "@Email", "@Phone"
};
object[] values = new object[8] {
ID, Fullname, Picture.ToArray(), Birthday, Gender, Class, Email, Phone
};
return(MyDB.Execute_Sql("procedureUpdateStudent", CommandType.StoredProcedure, paras, values));
}
public int InsertTaiKhoan()
{
string[] paras = new string[3] {
"@ID", "@Username", "@Password"
};
object[] values = new object[3] {
ID, Username, Password
};
return(MyDB.Execute_Sql("procedureInsertTaiKhoan", CommandType.StoredProcedure, paras, values));
}
public static int InsertStudentToProject(string ID, string PID)
{
try
{
string[] paras = new string[2] {
"@ID", "@PID"
};
object[] values = new object[2] {
ID, PID
};
return(MyDB.Execute_Sql("InsertStudentToProject", CommandType.StoredProcedure, paras, values));
}
catch
{
return(0);
}
}
