public VeChungToi()
{
InitializeComponent();
MyEntity db = new MyEntity();
//Hình từ đường dẫn database
var link = from linkNao in db.TDuongDans
where linkNao.MaDuongDan == "HA5"
select linkNao;
List <DuongDan> dsDuongDan1 = link.ToList();
DuongDan timDuocHinh5a = dsDuongDan1[0];
string pathHinh5 = timDuocHinh5a.DuongDanDenFile;
try
{
ImageSource imageSourceHinh5 = new BitmapImage(new Uri(pathHinh5));
hinh5.ImageSource = imageSourceHinh5;
}
catch (Exception)
{
}
}
private void btAnhHocSinh_Click(object sender, RoutedEventArgs e)
{
//Wpf không có Class giúp mở folder nên chúng ta phải mượn từ Winform
WinForms.FolderBrowserDialog openFolder = new WinForms.FolderBrowserDialog();
openFolder.ShowDialog();
if (openFolder.SelectedPath != "")
{
string path = openFolder.SelectedPath;
MyEntity db = new MyEntity();
var duongDan = from linkNao in db.TDuongDans
where linkNao.MaDuongDan == "HAHS"
select linkNao;
List <DuongDan> dsDuongDan = duongDan.ToList();
DuongDan timDuoc = dsDuongDan[0];
DuongDan linkMoi = new DuongDan(timDuoc.MaDuongDan, path);
db.TDuongDans.Attach(timDuoc);
db.TDuongDans.Remove(timDuoc);
db.TDuongDans.Add(linkMoi);
db.SaveChanges();
linkHocSinh.Text = linkMoi.DuongDanDenFile;
}
}
public ThemHocSinh(string maGV, string lopCuaHS)
{
InitializeComponent();
maGVTrongNay = maGV;
lopCuaHSTrongNay = lopCuaHS;
txtMaHS.Focus();
MyEntity db = new MyEntity();
var link = from linkNao in db.TDuongDans
where linkNao.MaDuongDan == "HALG"
select linkNao;
List <DuongDan> dsDuongDan = link.ToList();
DuongDan timDuocLogo = dsDuongDan[0];
string pathLogo = timDuocLogo.DuongDanDenFile;
try
{
ImageSource imageSourceLogo = new BitmapImage(new Uri(pathLogo));
hinhLogo.Source = imageSourceLogo;
}
catch (Exception)
{
}
}
private void btAnh4_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Ảnh (*.png;*.jpeg;*.jpg)|*.png;*.jpeg;*.jpg|All files (*.*)|*.*";
openFileDialog.ShowDialog();
if (openFileDialog.FileName != "")
{
string path = openFileDialog.FileName;
MyEntity db = new MyEntity();
var duongDan = from linkNao in db.TDuongDans
where linkNao.MaDuongDan == "HA4"
select linkNao;
List <DuongDan> dsDuongDan = duongDan.ToList();
DuongDan timDuoc = dsDuongDan[0];
DuongDan linkMoi = new DuongDan(timDuoc.MaDuongDan, path);
db.TDuongDans.Attach(timDuoc);
db.TDuongDans.Remove(timDuoc);
db.TDuongDans.Add(linkMoi);
db.SaveChanges();
linkHinh4.Text = linkMoi.DuongDanDenFile;
}
}
public CuaSoChinh(string maGV)
{
InitializeComponent();
maDangNhap = maGV;
btThongTinGiaoVien.RaiseEvent(new RoutedEventArgs(ButtonBase.ClickEvent));
MyEntity db = new MyEntity();
//Hình từ đường dẫn database
var link = from linkNao in db.TDuongDans
where linkNao.MaDuongDan == "HA2"
select linkNao;
List <DuongDan> dsDuongDan = link.ToList();
DuongDan timDuocHinh1 = dsDuongDan[0];
string pathHinh1 = timDuocHinh1.DuongDanDenFile;
try
{
ImageSource imageSourceHinh1 = new BitmapImage(new Uri(pathHinh1));
hinh2.ImageSource = imageSourceHinh1;
}
catch (Exception)
{
}
}
public CaiDat(string maGV)
{
InitializeComponent();
maGVTrongNay = maGV;
MyEntity db = new MyEntity();
//Cho giáo viên đó thấy Mã pin của mình
var maPin = from maNao in db.TDangNhaps
where maNao.MaTaiKhoan == maGV
select maNao;
List <DangNhap> timDuoc = maPin.ToList();
tbMaPin.Text = "Mã Pin: " + timDuoc[0].MaPin;
//Hình từ đường dẫn database
var link = from linkNao in db.TDuongDans
where linkNao.MaDuongDan == "HA5"
select linkNao;
List <DuongDan> dsDuongDan1 = link.ToList();
DuongDan timDuocHinh5a = dsDuongDan1[0];
string pathHinh5 = timDuocHinh5a.DuongDanDenFile;
try
{
ImageSource imageSourceHinh5 = new BitmapImage(new Uri(pathHinh5));
hinh5.ImageSource = imageSourceHinh5;
}
catch (Exception)
{
}
var duongDan = from linkNao in db.TDuongDans
select linkNao;
List <DuongDan> dsDuongDan = duongDan.ToList();
DuongDan timDuocLogo = new DuongDan();
DuongDan timDuocHinh1 = new DuongDan();
DuongDan timDuocHinh2 = new DuongDan();
DuongDan timDuocHinh3 = new DuongDan();
DuongDan timDuocHinh4 = new DuongDan();
DuongDan timDuocHinh5 = new DuongDan();
DuongDan timDuocFolderHS = new DuongDan();
foreach (var item in dsDuongDan)
{
if (item.MaDuongDan == "HALG")
{
timDuocLogo = item;
}
else if (item.MaDuongDan == "HA1")
{
timDuocHinh1 = item;
}
else if (item.MaDuongDan == "HA2")
{
timDuocHinh2 = item;
}
else if (item.MaDuongDan == "HA3")
{
timDuocHinh3 = item;
}
else if (item.MaDuongDan == "HA4")
{
timDuocHinh4 = item;
}
else if (item.MaDuongDan == "HA5")
{
timDuocHinh5 = item;
}
else
{
timDuocFolderHS = item;
}
}
linkLogo.Text = timDuocLogo.DuongDanDenFile;
linkHinh1.Text = timDuocHinh1.DuongDanDenFile;
linkHinh2.Text = timDuocHinh2.DuongDanDenFile;
linkHinh3.Text = timDuocHinh3.DuongDanDenFile;
linkHinh4.Text = timDuocHinh4.DuongDanDenFile;
linkHinh5.Text = timDuocHinh5.DuongDanDenFile;
linkHocSinh.Text = timDuocFolderHS.DuongDanDenFile;
}
