private void gridTietHoc_SelectionChanged(object sender, SelectionChangedEventArgs e)//binding
{
try
{
tietHocSelected = ((TietHoc)gridTietHoc.Items[gridTietHoc.SelectedIndex]);
ngayHocTxt.SelectedDate = tietHocSelected.NgayHoc;
cbxTrangThai.SelectedIndex = tietHocSelected.TrangThai + 1;
txtTenPhong.Text = tietHocSelected.TenPhong;
txtTietBatDau.Text = tietHocSelected.TietBatDau + "";
txtGhiChu.Text = tietHocSelected.GhiChu;
if (!(tietHocSelected is TietHocBu))
{
txtTietBatDau.IsEnabled = false;
ngayHocTxt.IsEnabled = false;
}
else
{
txtTietBatDau.IsEnabled = true;
ngayHocTxt.IsEnabled = true;
}
}
catch
{
}
}
private List <TietHoc> sortBuoiHoc(List <TietHoc> th)
{
for (int i = 0; i < th.Count - 1; i++)
{
for (int j = i + 1; j < th.Count; j++)
{
if (TietHoc.Compare(th[i], th[j]) > 0)
{
TietHoc temp = th[i];
th[i] = th[j];
th[j] = temp;
}
}
}
return(th);
}
private void btnSua_Click(object sender, RoutedEventArgs e)
{
TietHoc th;
if (tietHocSelected is TietHocBu)
{
th = new TietHocBu(this.lopHoc, tietHocSelected.Id, txtTenPhong.Text, ngayHocTxt.SelectedDate.Value, cbxTrangThai.SelectedIndex - 1, txtGhiChu.Text, int.Parse(txtTietBatDau.Text));
}
else
{
th = new TietHoc(tietHocSelected.LopHoc, tietHocSelected.Id, txtTenPhong.Text.ToUpper(), tietHocSelected.NgayHoc, cbxTrangThai.SelectedIndex - 1, txtGhiChu.Text);
}
TietHocDAO.Instance.SuaTietHoc(th);
gridTietHoc.ItemsSource = sortBuoiHoc(TietHocDAO.Instance.DSTietHocTheoLopHoc(this.lopHoc.MaLopHoc + ""));
}
private void ExportDataGridViewTo_Excel()
{
try
{
Excel.Application oExcel = null; //Excel_12 Application
Excel.Workbook oBook = null; // Excel_12 Workbook
Excel.Sheets oSheetsColl = null; // Excel_12 Worksheets collection
Excel.Worksheet oSheet = null; // Excel_12 Worksheet
Excel.Range oRange = null; // Cell or Range in worksheet
Object oMissing = System.Reflection.Missing.Value;
// Create an instance of Excel_12.
oExcel = new Excel.Application();
// Make Excel_12 visible to the user.
oExcel.Visible = true;
// Set the UserControl property so Excel_12 won't shut down.
oExcel.UserControl = true;
// System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-US");
//object file = File_Name;
//object missing = System.Reflection.Missing.Value;
// Add a workbook.
oBook = oExcel.Workbooks.Add(oMissing);
// Get worksheets collection
oSheetsColl = oExcel.Worksheets;
// Get Worksheet "Sheet1"
oSheet = (Excel.Worksheet)oSheetsColl.get_Item("Sheet1");
oSheet.Name = "BuoiHoc";
oSheet.Range[oSheet.Cells[1, 1], oSheet.Cells[1, 8]].Merge();
oRange = (Excel.Range)oSheet.Cells[1, 1];
oRange.Value2 = lopHoc.GiangVien.HoTenGV;
oRange.EntireRow.Font.Bold = true;
oRange.EntireRow.Font.Size = 16;
oSheet.Range[oSheet.Cells[2, 1], oSheet.Cells[2, 8]].Merge();
oRange = (Excel.Range)oSheet.Cells[2, 1];
oRange.Value2 = lopHoc.NoiDung;
oRange.EntireRow.Font.Size = 12;
oSheet.Range[oSheet.Cells[3, 1], oSheet.Cells[3, 8]].Merge();
oRange = (Excel.Range)oSheet.Cells[3, 1];
oRange.Value2 = lopHoc.NoiDungLop;
oRange.EntireRow.Font.Size = 12;
// Export titles
for (int j = 0; j < gridTietHoc.Columns.Count; j++)
{
oRange = (Excel.Range)oSheet.Cells[5, j + 1];
//oRange.DisplayFormat.Font.Background = Colors.Black;
//oRange.DisplayFormat.Font.Color = Colors.White;
oRange.Value2 = gridTietHoc.Columns[j].Header;
oRange.Interior.ColorIndex = 5;
oRange.EntireRow.Font.Bold = true;
oRange.EntireRow.Font.Size = 14;
oRange.EntireRow.Font.ColorIndex = 2;
oRange.Columns.ColumnWidth = 20;
oRange.Columns.Borders.ColorIndex = 2;
oRange.Columns.Borders.Weight = 2;
oRange.Columns.VerticalAlignment = AlignmentY.Center;
}
// Export data
for (int i = 0; i < gridTietHoc.Items.Count; i++)
{
TietHoc th = ((TietHoc)gridTietHoc.Items[i]);
oRange = (Excel.Range)oSheet.Cells[i + 6, 1];
oRange.Value2 = th.NgayHoc.ToShortDateString() + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 2];
oRange.Value2 = th.Tuan + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 3];
oRange.Value2 = th.TuanHocBu + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 4];
oRange.Value2 = th.Thu + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 5];
oRange.Value2 = th.TenPhong + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 6];
oRange.Value2 = th.SoTiet + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 7];
oRange.Value2 = th.TextTrangThai + "";
oRange = (Excel.Range)oSheet.Cells[i + 6, 8];
oRange.Value2 = th.GhiChu + "";
}
oBook = null;
oExcel.Quit();
oExcel = null;
GC.Collect();
}
catch (Exception)
{
}
}