public bool UpdateStudent(tbl.tblStudent st, string ID) { string sql = "UPDATE STUDENTS SET STUDENT_ID = @STUDENT_ID, USERNAME = @USERNAME," + "PASSWORD = @PASSWORD, FULLNAME = @FULLNAME,BIRTHDAY = @BIRTHDAY " + " WHERE STUDENT_ID = '" + ID + "' COLLATE SQL_Latin1_General_CP1_CS_AS "; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@STUDENT_ID", SqlDbType.VarChar).Value = st.STUDENT_ID; cmd.Parameters.Add("@USERNAME", SqlDbType.VarChar).Value = st.USERNAME; cmd.Parameters.Add("@PASSWORD", SqlDbType.VarChar).Value = st.PASSWORD; cmd.Parameters.Add("@FULLNAME", SqlDbType.NVarChar).Value = st.FULLNAME; cmd.Parameters.Add("@BIRTHDAY", SqlDbType.SmallDateTime).Value = st.BIRTHDAY; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool Check_Login(tbl.tblStudent st) { string sql = "SELECT COUNT (*) FROM STUDENTS WHERE " + "USERNAME = '******' COLLATE SQL_Latin1_General_CP1_CS_AS " + "AND PASSWORD = '******' COLLATE SQL_Latin1_General_CP1_CS_AS"; SqlConnection con = dc.getConnect(); da = new SqlDataAdapter(sql, con); con.Open(); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows[0][0].ToString() == "1") { sql = "SELECT ADMIN_ID FROM ADMINS WHERE USERNAME = '******' COLLATE SQL_Latin1_General_CP1_CS_AS"; da = new SqlDataAdapter(sql, con); DataTable dst = new DataTable(); da.Fill(dst); st.STUDENT_ID = dst.Rows[0][0].ToString(); con.Close(); return(true); } con.Close(); return(false); }
private void ad_bsd_Click(object sender, EventArgs e) { tbl.tblStudent st = new tbl.tblStudent(txtStudentID.Text, txtStudentUsername.Text, txtStudentPassword.Text, txtStudentFullname.Text, dtpStudentBirthday.Text); if (student.DeleteStudent(st) == false) { MessageBox.Show("Can not delete this student !!!", "Error"); } else { MessageBox.Show("Successfully Deleted !!!"); } ad_dgv_st.DataSource = student.getAllStudents(); ad_dgv_st.Show(); Binding(); }
private void ad_bstup_Click(object sender, EventArgs e) { int index = ad_dgv_st.CurrentRow.Index; string ID = ad_dgv_st.Rows[index].Cells["STUDENT_ID"].Value.ToString(); tbl.tblStudent st = new tbl.tblStudent(txtStudentID.Text, txtStudentUsername.Text, txtStudentPassword.Text, txtStudentFullname.Text, dtpStudentBirthday.Text); if (student.UpdateStudent(st, ID) == false) { MessageBox.Show("Can not update this student !!!", "Error"); } else { MessageBox.Show("Successfully Updated !!!"); } ad_dgv_st.DataSource = student.getAllStudents(); ad_dgv_st.Show(); }
private void btnCreate_Click(object sender, EventArgs e) { if (Check_Fill()) { tbl.tblStudent st = new tbl.tblStudent(txtStudentID.Text, txtStudentUsername.Text, txtStudentPassword.Text, txtStudentFullname.Text, dtpStudentBirthday.Text); if (student.InsertStudent(st) == false) { MessageBox.Show("Can not create this student account !!!", "Error"); } else { MessageBox.Show("Successfully !!!"); } ad_dgv_st.DataSource = student.getAllStudents(); ad_dgv_st.Show(); Binding(); } }
public bool DeleteStudent(tbl.tblStudent st) { string sql = "DELETE STUDENTS WHERE STUDENT_ID = @STUDENT_ID COLLATE SQL_Latin1_General_CP1_CS_AS "; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@STUDENT_ID", SqlDbType.VarChar).Value = st.STUDENT_ID; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool InsertStudent(tbl.tblStudent st) { string sql = "INSERT INTO STUDENTS VALUES(@STUDENT_ID,@USERNAME,@PASSWORD,@FULLNAME,@BIRTHDAY)"; SqlConnection con = dc.getConnect(); try { cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.Add("@STUDENT_ID", SqlDbType.VarChar).Value = st.STUDENT_ID; cmd.Parameters.Add("@USERNAME", SqlDbType.VarChar).Value = st.USERNAME; cmd.Parameters.Add("@PASSWORD", SqlDbType.VarChar).Value = st.PASSWORD; cmd.Parameters.Add("@FULLNAME", SqlDbType.NVarChar).Value = st.FULLNAME; cmd.Parameters.Add("@BIRTHDAY", SqlDbType.SmallDateTime).Value = st.BIRTHDAY; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { return(false); } return(true); }
public bool DeleteStudent(tbl.tblStudent st) { return(dalST.DeleteStudent(st)); }
public bool UpdateStudent(tbl.tblStudent st, string ID) { return(dalST.UpdateStudent(st, ID)); }
public bool InsertStudent(tbl.tblStudent st) { return(dalST.InsertStudent(st)); }