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); }