private List <LichHocDTO> getLichHocsFromGrd()
{
List <LichHocDTO> lstLichHocs = new List <LichHocDTO>();
foreach (DataGridViewRow row in grdLichHoc.Rows)
{
bool hasLichHoc = false;
LichHocDTO dto = new LichHocDTO();
// run from thu 2 (cot 3)
for (int i = 3; i < grdLichHoc.ColumnCount; i++)
{
if (row.Cells[i].Value != null && row.Cells[i].Value.ToString().Trim() != "")
{
dto.id_LH = currentLopHoc.id_LH;
dto.tuan = row.Index + 1;
dto.thu = i - 1;
dto.noiDung = row.Cells[i].Value.ToString().Trim();
hasLichHoc = true;
}
}
if (hasLichHoc)
{
lstLichHocs.Add(dto);
}
}
return(lstLichHocs);
}
private void grdLichHoc_CellClick(object sender, DataGridViewCellEventArgs e)
{
int index = grdLichHoc.SelectedCells[0].RowIndex;
currentLichHoc = new LichHocDTO();
currentLichHoc = currentListLichHoc.ElementAt(index);
}
public List <LichHocDTO> readLichHocs(string maLop)
{
conn.Open();
List <LichHocDTO> lstLichHocs = new List <LichHocDTO>();
string query = "select * from LICHHOC where id_LH = @id_LH order by tuan ASC";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("id_LH", maLop);
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
LichHocDTO lichHocDTO = new LichHocDTO();
lichHocDTO.id_LIH = rd["id_LIH"].ToString();
lichHocDTO.id_LH = rd["id_LH"].ToString();
lichHocDTO.tuan = int.Parse(rd["tuan"].ToString());
lichHocDTO.thu = int.Parse(rd["thu"].ToString());
lichHocDTO.noiDung = rd["noidung"].ToString();
lstLichHocs.Add(lichHocDTO);
}
conn.Close();
return(lstLichHocs);
}
public void insertLichHoc(LichHocDTO lichDTO)
{
conn.Open();
string query = "insert into LichHoc " +
"(id_LH, tuan, thu, noidung, ghiChu_LIH) values " +
"(@id_LH, @tuan, @thu, @noidung, @ghiChu_LIH)";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("id_LH", lichDTO.id_LH);
cmd.Parameters.AddWithValue("tuan", lichDTO.tuan);
cmd.Parameters.AddWithValue("thu", lichDTO.thu);
cmd.Parameters.AddWithValue("noidung", lichDTO.noiDung);
cmd.Parameters.AddWithValue("ghiChu_LIH", lichDTO.ghiChu_LIH);
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException sqle)
{
conn.Close();
throw sqle;
}
conn.Close();
}
public List <LichHocDTO> getLichHocById_LopHoc(string id_LopHoc)
{
conn.Open();
List <LichHocDTO> lstLichHocs = new List <LichHocDTO>();
string query = "select * from LichHoc where id_LH = @id_LH";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("id_LH", id_LopHoc);
try
{
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
LichHocDTO lih = new LichHocDTO();
lih.id_LIH = rd["id_LIH"].ToString();
lih.id_LH = rd["id_LH"].ToString();
lih.tuan = int.Parse(rd["tuan"].ToString());
lih.thu = int.Parse(rd["thu"].ToString());
lih.noiDung = rd["noidung"].ToString();
lih.ghiChu_LIH = rd["ghichu_LIH"].ToString();
lstLichHocs.Add(lih);
}
}
catch (SqlException sqle)
{
conn.Close();
throw sqle;
}
conn.Close();
return(lstLichHocs);
}
