public void Xoa(TaiKhoanEntity tk)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblTaiKhoan WHERE MaNV=@MaNV";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaNV", tk.MaNV);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(TaiKhoanEntity tk)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblTaiKhoan SET MatKhau =@MatKhau, TaiKhoan =@TaiKhoan Where MaNV=@MaNV";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@TaiKhoan", tk.TaiKhoan);
cdm.Parameters.AddWithValue("@MatKhau", tk.MatKhau);
cdm.Parameters.AddWithValue("@MaNV", tk.MaNV);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(TaiKhoanEntity tk)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblTaiKhoan(TaiKhoan, MatKhau, MaNV) VALUES (@TaiKhoan,@MatKhau,@MaNV)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@TaiKhoan", tk.TaiKhoan);
cdm.Parameters.AddWithValue("@MatKhau", tk.MatKhau);
cdm.Parameters.AddWithValue("@MaNV", tk.MaNV);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
