public ThanhVienDAOlmpl()
{
thanhVienList = new List <ThanhVien>();
string strConn = $"Server=localhost; Database=QLChuyenDi; Trusted_Connection=True;";
SqlConnection sqlConnection = new SqlConnection(strConn);
SqlCommand sqlCommand = new SqlCommand();
String query = "select * from THANHVIEN";
try
{
sqlCommand.CommandText = query;
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
ThanhVien thanhVien = new ThanhVien();
var currentFolder = AppDomain.CurrentDomain.BaseDirectory;
thanhVien.MaThanhVien = reader[0].ToString();
thanhVien.TenThanhVien = reader[1].ToString();
thanhVienList.Add(thanhVien);
}
sqlConnection.Close();
}
catch (Exception ex)
{
sqlConnection.Close();
throw ex;
}
}
public ThanhVien GetMemberById(string id)
{
ThanhVien rs = new ThanhVien();
foreach (var tv in thanhVienList)
{
if (tv.MaThanhVien == id)
{
rs = new ThanhVien(tv.MaThanhVien, tv.TenThanhVien);
break;
}
}
return(rs);
}
public void addThanhVien(ThanhVien thanhVien)
{
using (SqlConnection connection = new SqlConnection("Server=localhost; Database=QLChuyenDi; Trusted_Connection=True;"))
{
String query = "INSERT INTO dbo.THANHVIEN (MATHANHVIEN,TENTHANHVIEN)" +
" VALUES (@MaThanhVien,@TenThanhVien)";
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@MaThanhVien", thanhVien.MaThanhVien);
command.Parameters.AddWithValue("@TenThanhVien", thanhVien.TenThanhVien);
connection.Open();
int result = command.ExecuteNonQuery();
if (result < 0)
{
MessageBox.Show("fail");
}
}
}
}
public void deleteThanhVien(ThanhVien thanhVien)
{
String delQuery = $"DELETE FROM THANHVIEN WHERE MATHANHVIEN = '{thanhVien.MaThanhVien}';";
DatabaseHelper.executeQuery(delQuery);
}