public bool UpdateLop(lop l)
{
String query = "update lop set tenlop =N'" + l.tenlop + "' , makhoa ='" + l.makhoa + "' where malop = '" + l.malop + "'";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
cmd.ExecuteNonQuery();
return(true);
} catch (Exception e) {
return(false);
}
}
public bool deleteLop(lop l)
{
String query = "delete lop where malop = '" + l.malop + "'";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
cmd.ExecuteNonQuery();
return(true);
} catch (Exception e) {
return(false);
}
}
public bool insertLop(lop lop)
{
String query = "Insert into lop values ('" + lop.malop + "' , N'" + lop.tenlop + "' , '" + lop.makhoa + "');";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
cmd.ExecuteNonQuery();
return(true);
} catch (Exception e) {
return(false);
}
}
public List <lop> searchListLop(String search)
{
List <lop> list = new List <lop>();
String query;
query = "Select * from lop where makhoa = '" + search + "' or lop.malop = '" + search + "' or lop.tenlop = '" + search + "'";
try {
SqlCommand cmd = new SqlCommand(query, getConnection());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lop l = new lop();
l.lopIDataReader(reader);
list.Add(l);
}
reader.Close();
} catch (Exception e) {
}
return(list);
}
public List <lop> getListLop()
{
List <lop> list = new List <lop>();
String query;
query = "Select * from lop ";
try
{
SqlCommand cmd = new SqlCommand(query, getConnection());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
lop l = new lop();
l.lopIDataReader(reader);
list.Add(l);
}
reader.Close();
}
catch (Exception e)
{
}
return(list);
}