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