public bool ChangePassword(string newpass)
{
//Kiểm tra coi pass cũ có đúng ko đã
if (isAbleToUpdate() == false)
{
MessageBox.Show("Mời bạn kiểm tra lại Password cũ");
return(false);
}
else
{
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "update Student set Pass = ? where StudentID = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@Pass", OleDbType.WChar);
cmd.Parameters.Add("@StudentID", OleDbType.Integer);
cmd.Parameters["@Pass"].Value = newpass;
cmd.Parameters["@StudentID"].Value = sd.StudentID;
cmd.ExecuteNonQuery();
//B5: Dong ket noi CSDL
cn.Close();
return(true);
}
}
private bool isAbleToUpdate()
{
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Select * from Student where StudentID = " + sd.StudentID + " and Pass = '******'";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataAdapter dad;
dad = new OleDbDataAdapter(cmd);
DataSet dst = new DataSet();
dad.Fill(dst);
cn.Close();
if (dst.Tables[0].Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
public int isExist()
{
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Select * from Student where StudentID = " + sd.StudentID + " and Pass = '******'";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataAdapter dad;
dad = new OleDbDataAdapter(cmd);
DataSet dst = new DataSet();
dad.Fill(dst);
cn.Close();
if (dst.Tables[0].Rows.Count == 0)
{
return(-1);
}
else
{
DataRow dr = dst.Tables[0].Rows[0];
return(int.Parse(dr["StudentID"].ToString()));
}
}
public DataTable ThongTinThread(int iThead)
{
DataTable dt = new DataTable();
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Select * from Thread, Student where Thread.StudentID = Student.StudentID and ThreadID = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@ThreadID", OleDbType.Integer);
cmd.Parameters["@ThreadID"].Value = iThead;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(dt);
cn.Close();
return(dt);
}
public DataTable LayDanhSach(string MonHoc)
{
DataTable dt = new DataTable();
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Select * from Thread, Subject where Thread.OpenSubjectID = Subject.SubjectID and Subject.Name = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@Subject.Name", OleDbType.VarChar);
cmd.Parameters["@Subject.Name"].Value = MonHoc;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(dt);
cn.Close();
return(dt);
}
public DataTable LayDanhSach(int sID)
{
DataTable dt = new DataTable();
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Select Subject.Name, Thread.Title, Thread.TimePost, ThreadID from Thread, Subject, Student where Thread.OpenSubjectID = Subject.SubjectID and Thread.StudentID = Student.StudentID and Student.StudentID = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@Student.StudentID", OleDbType.Integer);
cmd.Parameters["@Student.StudentID"].Value = sID;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(dt);
cn.Close();
return(dt);
}
public DataTable LayDanhSach()
{
DataTable dtkq = new DataTable();
string strSQL = "Select Subject.Name, Deadline.Title, Deadline.TimeOut from Deadline, Subject where Deadline.OpenSubjectID = Subject.SubjectID and TimeOut > ? Order by TimeOut";
OleDbConnection cn = DataProvider.ConnectionData();
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@TimeOut", OleDbType.Date);
cmd.Parameters["@TimeOut"].Value = DateTime.Now;
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtkq);
cn.Close();
return(dtkq);
}
public static DataTable LayBang(string TenBang)
{
DataTable dt = new DataTable();
// B1 & B2: Tạo chuỗi kết nối, mở kết nối bằng đối tượng kết nối
OleDbConnection cn;
cn = DataProvider.ConnectionData();
string strSQL = "Select * from " + TenBang;
// B3: Tạo chuỗi strSQL thao tác cơ sở dữ liệu
OleDbDataAdapter da = new OleDbDataAdapter(strSQL, cn);
da.Fill(dt);
// B5: Đóng kết nối cơ sở dữ liệu
cn.Close();
return(dt);
}
public void ThemReply(ReplyThreadDTO rtdto)
{
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Insert into ReplyThread (Content, TimePost, ThreadID, StudentID) values (?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@Content", OleDbType.VarWChar);
cmd.Parameters.Add("@TimePost", OleDbType.Date);
cmd.Parameters.Add("@ThreadID", OleDbType.Integer);
cmd.Parameters.Add("@StudentID", OleDbType.Integer);
cmd.Parameters["@Content"].Value = rtdto.Content.ToString();
cmd.Parameters["@TimePost"].Value = rtdto.Time;
cmd.Parameters["@ThreadID"].Value = rtdto.ThreadID;
cmd.Parameters["@StudentID"].Value = rtdto.StudentID;
cmd.ExecuteNonQuery();
cn.Close();
}
public bool AddThread(ThreadDTO td)
{
OleDbConnection cn = DataProvider.ConnectionData();
string strSQL = "Insert into Thread(Title, Content, TimePost, OpenSubjectID, StudentID) values (?, ?, ?, ?, ?)";
//B4: Thuc thi chuoi strSQL
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@Title", OleDbType.WChar);
cmd.Parameters.Add("@Content", OleDbType.WChar);
cmd.Parameters.Add("@TimePost", OleDbType.Date);
cmd.Parameters.Add("@OpenSubjectID", OleDbType.Integer);
cmd.Parameters.Add("@StudentID", OleDbType.Integer);
cmd.Parameters["@Title"].Value = td.Title;
cmd.Parameters["@Content"].Value = td.Content;
cmd.Parameters["@TimePost"].Value = td.Time;
cmd.Parameters["@OpenSubjectID"].Value = td.OpenSubjectID;
cmd.Parameters["@StudentID"].Value = td.StudentID;
cmd.ExecuteNonQuery();
cn.Close();
return(true);
}
