public GiangVienDTO findById(string ma)
{
conn.Open();
string sql = "select * from giangvien where id_GV = @ma";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("ma", ma);
SqlDataReader dr = cmd.ExecuteReader();
GiangVienDTO gv = null;
while (dr.Read())
{
gv = GiangVienMapper.map(dr);
}
conn.Close();
return(gv);
}
public List <GiangVienDTO> findByName(string ten)
{
conn.Open();
List <GiangVienDTO> gvs = new List <GiangVienDTO>();
string sql = "select * from giangvien where ten_GV like concat('%',@ten,'%')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("ten", ten);
SqlDataReader dr = cmd.ExecuteReader();
GiangVienDTO gv = null;
while (dr.Read())
{
gv = GiangVienMapper.map(dr);
gvs.Add(gv);
}
conn.Close();
return(gvs);
}
public List <GiangVienDTO> getAll(string sortBy = null, string sortType = null)
{
if (sortBy == "ghichu_GV")
{
sortBy = "CAST(" + sortBy + " AS NVARCHAR(100))";
}
List <GiangVienDTO> gvs = new List <GiangVienDTO>();
conn.Open();
string sql = "";
SqlCommand cmd;
if (sortBy != null && sortType != null)
{
sql = "select * from giangvien order by " + sortBy + " " + sortType;
cmd = new SqlCommand(sql, conn);
//cmd.Parameters.AddWithValue("sort", sortBy);
//cmd.Parameters.AddWithValue("type", sortType);
}
else
{
sql = "select * from giangvien";
cmd = new SqlCommand(sql, conn);
}
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
GiangVienDTO gv = GiangVienMapper.map(dr);
gvs.Add(gv);
}
conn.Close();
return(gvs);
}