public ObservableCollection <UngSinh> ThemUngSinh(UngSinh obj) { using (SqlConnection conn = getConnect()) { conn.Open(); string q = "Insert into UngSinh values (N'" + obj.TenThanh + "',N'" + obj.HoVaTenLot + "',N'" + obj.TenUngSinh + "',N'" + obj.MaTinhTrang + "',N'" + obj.MaLop + "',N'" + obj.NgaySinh + "',N'" + obj.NoiSinh + "',N'" + obj.NguyenQuan + "',N'" + obj.HoKhauThuongTru + "',N'" + obj.SoCMND + "',N'" + obj.NgayCapCMND + "',N'" + obj.NoiCapCMND + "',N'" + obj.NgayRuaToi + "',N'" + obj.GiaoXuRuaToi + "',N'" + obj.NgayThemSuc + "',N'" + obj.GiaoXuThemSuc + "',N'" + obj.GiaoXu + "',N'" + obj.GiaoPhan + "',N'" + obj.DienThoaiGiaoXu + "',N'" + obj.DienThoaiCaNhan + "',N'" + obj.CaTinh + "',N'" + obj.LichSuOnGoi + "',N'" + obj.YThucDoiTu + "',N'" + obj.HocTapNangKhieu + "',N'" + obj.NhungDiemCoGangThayDoi + "',N'" + obj.NhanDinhOnGoi + "',N'" + obj.SucKhoe + "',N'" + obj.NhanDinhDiem + "', N'" + obj.AnhDaiDien + "') SELECT SCOPE_IDENTITY()"; SqlCommand myCommands = new SqlCommand(q, conn); myCommands.CommandType = CommandType.Text; myCommands.ExecuteNonQuery(); q = "Select top 1 * from UngSinh order by MaUngSinh DESC"; SqlCommand myCommand = new SqlCommand(q, conn); myCommand.CommandType = CommandType.Text; ObservableCollection <UngSinh> lst = new ObservableCollection <BOL.UngSinh>(); SqlDataReader Reader = myCommand.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { lst.Add(UngSinhIDataReader(Reader)); } Reader.Close(); } conn.Close(); return(lst); } }
public void HienThiYThucDoiTu(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objYThucDoiTu = UngSinh.HienThiUngSinh(11); try { rtb_YThucDoiTu_Editor.Document = SetRTF(obj[0].YThucDoiTu); } catch { } }
private void btn_ThemUngSinh_Click(object sender, RoutedEventArgs e) { UngSinh obj = new UngSinh(); obj.TenThanh = text_TenThanh.Text; obj.HoVaTenLot = text_HoVaTenLot.Text; obj.TenUngSinh = text_TenUngSinh.Text; obj.MaTinhTrang = int.Parse(cmb_TinhTrang.SelectedValue.ToString()); obj.MaLop = int.Parse(cmb_Lop.SelectedValue.ToString()); obj.NgaySinh = DateTime.Parse(text_NgaySinh.Text); obj.NoiSinh = text_NoiSinh.Text; obj.NguyenQuan = text_NguyenQuan.Text; obj.HoKhauThuongTru = text_HoKhauThuongTru.Text; obj.SoCMND = text_SoCMND.Text; obj.NgayCapCMND = DateTime.Parse(text_NgayCapCMND.Text); obj.NoiCapCMND = text_NoICapCMND.Text; obj.NgayRuaToi = DateTime.Parse(text_NgayRuaToi.Text); obj.GiaoXuRuaToi = text_GiaoXuRuaToi.Text; obj.NgayThemSuc = DateTime.Parse(text_NgayThemSuc.Text); obj.GiaoXuThemSuc = text_GiaoXuThemSuc.Text; obj.GiaoXu = text_GiaoXu.Text; obj.GiaoPhan = text_GiaoPhan.Text; obj.DienThoaiGiaoXu = text_DienThoaiGiaoXu.Text; obj.DienThoaiCaNhan = text_DienThoaiCaNhan.Text; ObservableCollection <UngSinh> objUngSinh = UngSinh.ThemUngSinh(obj); UploadAnhDaiDien(objUngSinh[0].MaUngSinh); }
public void HienThiHocTapNangKhieu(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objHocTapNangKhieu = UngSinh.HienThiUngSinh(11); try { rtb_HocTapNangKhieu_Editor.Document = SetRTF(obj[0].HocTapNangKhieu); } catch { } }
private UngSinh UngSinhIDataReader(IDataReader Reader) { UngSinh obj = new UngSinh(); obj.MaUngSinh = (Reader["MaUngSinh"] is DBNull) ? int.MinValue : (int)Reader["MaUngSinh"]; obj.TenThanh = (Reader["TenThanh"] is DBNull) ? string.Empty : (string)Reader["TenThanh"]; obj.HoVaTenLot = (Reader["HoVaTenLot"] is DBNull) ? string.Empty : (string)Reader["HoVaTenLot"]; obj.TenUngSinh = (Reader["TenUngSinh"] is DBNull) ? string.Empty : (string)Reader["TenUngSinh"]; obj.MaTinhTrang = (Reader["MaTinhTrang"] is DBNull) ? int.MinValue : (int)Reader["MaTinhTrang"]; obj.MaLop = (Reader["MaLop"] is DBNull) ? int.MinValue : (int)Reader["MaLop"]; obj.NgaySinh = (Reader["NgaySinh"] is DBNull) ? DateTime.MinValue : (DateTime)Reader["NgaySinh"]; obj.NoiSinh = (Reader["NoiSinh"] is DBNull) ? string.Empty : (string)Reader["NoiSinh"]; obj.NguyenQuan = (Reader["NguyenQuan"] is DBNull) ? string.Empty : (string)Reader["NguyenQuan"]; obj.HoKhauThuongTru = (Reader["HoKhauThuongTru"] is DBNull) ? string.Empty : (string)Reader["HoKhauThuongTru"]; obj.SoCMND = (Reader["SoCMND"] is DBNull) ? string.Empty : (string)Reader["SoCMND"]; obj.NgayCapCMND = (Reader["NgayCapCMND"] is DBNull) ? DateTime.MinValue : (DateTime)Reader["NgayCapCMND"]; obj.NoiCapCMND = (Reader["NoiCapCMND"] is DBNull) ? string.Empty : (string)Reader["NoiCapCMND"]; obj.NgayRuaToi = (Reader["NgayRuaToi"] is DBNull) ? DateTime.MinValue : (DateTime)Reader["NgayRuaToi"]; obj.GiaoXuRuaToi = (Reader["GiaoXuRuaToi"] is DBNull) ? string.Empty : (string)Reader["GiaoXuRuaToi"]; obj.NgayThemSuc = (Reader["NgayThemSuc"] is DBNull) ? DateTime.MinValue : (DateTime)Reader["NgayThemSuc"]; obj.GiaoXuThemSuc = (Reader["GiaoXuThemSuc"] is DBNull) ? string.Empty : (string)Reader["GiaoXuThemSuc"]; obj.GiaoXu = (Reader["GiaoXu"] is DBNull) ? string.Empty : (string)Reader["GiaoXu"]; obj.GiaoPhan = (Reader["GiaoPhan"] is DBNull) ? string.Empty : (string)Reader["GiaoPhan"]; obj.DienThoaiGiaoXu = (Reader["DienThoaiGiaoXu"] is DBNull) ? string.Empty : (string)Reader["DienThoaiGiaoXu"]; obj.DienThoaiCaNhan = (Reader["DienThoaiCaNhan"] is DBNull) ? string.Empty : (string)Reader["DienThoaiCaNhan"]; obj.CaTinh = (Reader["CaTinh"] is DBNull) ? string.Empty : (string)Reader["CaTinh"]; obj.LichSuOnGoi = (Reader["LichSuOnGoi"] is DBNull) ? string.Empty : (string)Reader["LichSuOnGoi"]; obj.YThucDoiTu = (Reader["YThucDoiTu"] is DBNull) ? string.Empty : (string)Reader["YThucDoiTu"]; obj.HocTapNangKhieu = (Reader["HocTapNangKhieu"] is DBNull) ? string.Empty : (string)Reader["HocTapNangKhieu"]; obj.NhungDiemCoGangThayDoi = (Reader["NhungDiemCoGangThayDoi"] is DBNull) ? string.Empty : (string)Reader["NhungDiemCoGangThayDoi"]; obj.NhanDinhOnGoi = (Reader["NhanDinhOnGoi"] is DBNull) ? string.Empty : (string)Reader["NhanDinhOnGoi"]; obj.NhanDinhDiem = (Reader["NhanDinhDiem"] is DBNull) ? string.Empty : (string)Reader["NhanDinhDiem"]; obj.AnhDaiDien = (Reader["AnhDaiDien"] is DBNull) ? string.Empty : (string)Reader["AnhDaiDien"]; return(obj); }
public void HienThiCaTinh(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objCaTinh = UngSinh.HienThiUngSinh(11); try { rtb_CaTinh_Editor.Document = SetRTF(obj[0].CaTinh); } catch { } }
public void HienThiNhanDinhDiem(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objNhanDinhDiem = UngSinh.HienThiUngSinh(11); try { rtb_NhanDinhDiem_Editor.Document = SetRTF(obj[0].NhanDinhDiem); } catch { } }
public void HienThiSucKhoe(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objSucKhoe = UngSinh.HienThiUngSinh(11); try { rtb_SucKhoe_Editor.Document = SetRTF(obj[0].SucKhoe); } catch { } }
public void HienThiNhungDiemCoGangThayDoi(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objNhungDiemCoGangThayDoi = UngSinh.HienThiUngSinh(11); try { rtb_CanThayDoi_Editor.Document = SetRTF(obj[0].NhungDiemCoGangThayDoi); } catch { } }
public void HienThiLichSuOnGoi(ObservableCollection <UngSinh> obj) { ObservableCollection <UngSinh> objLichSu = UngSinh.HienThiUngSinh(11); try { rtb_LichSuOnGoi_Editor.Document = SetRTF(obj[0].LichSuOnGoi); } catch { } }
private void btn_NhanDinhDiem_Luu_Click(object sender, RoutedEventArgs e) { try { string NhanDinhDiem = GetRTF(rtb_NhanDinhDiem_Editor); UngSinh objNhanDinhDiem = new UngSinh(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); objNhanDinhDiem.MaUngSinh = obj[0].MaUngSinh; objNhanDinhDiem.NhanDinhDiem = NhanDinhDiem; objNhanDinhDiem.CapNhatNhanDinhDiem(objNhanDinhDiem); MessageBox.Show("Đã cập nhật dữ liệu."); } catch { MessageBox.Show("Cập nhật không thành công."); } }
private void btn_SucKhoe_Luu_Click(object sender, RoutedEventArgs e) { try { string SucKhoe = GetRTF(rtb_SucKhoe_Editor); UngSinh objSucKhoe = new UngSinh(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); objSucKhoe.MaUngSinh = obj[0].MaUngSinh; objSucKhoe.SucKhoe = SucKhoe; objSucKhoe.CapNhatSucKhoe(objSucKhoe); MessageBox.Show("Đã cập nhật dữ liệu."); } catch { MessageBox.Show("Cập nhật không thành công."); } }
private void btn_CanThayDoi_Luu_Click(object sender, RoutedEventArgs e) { try { string NhungDiemCoGangThayDoi = GetRTF(rtb_CanThayDoi_Editor); UngSinh objNhungDiemCoGangThayDoi = new UngSinh(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); objNhungDiemCoGangThayDoi.MaUngSinh = obj[0].MaUngSinh; objNhungDiemCoGangThayDoi.NhungDiemCoGangThayDoi = NhungDiemCoGangThayDoi; objNhungDiemCoGangThayDoi.CapNhatNhungDiemCoGangThayDoi(objNhungDiemCoGangThayDoi); MessageBox.Show("Đã cập nhật dữ liệu."); } catch { MessageBox.Show("Cập nhật không thành công."); } }
private void btn_HocTapNangKhieu_Luu_Click(object sender, RoutedEventArgs e) { try { string HocTapNangKhieu = GetRTF(rtb_HocTapNangKhieu_Editor); UngSinh objHocTapNangKhieu = new UngSinh(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); objHocTapNangKhieu.MaUngSinh = obj[0].MaUngSinh; objHocTapNangKhieu.HocTapNangKhieu = HocTapNangKhieu; objHocTapNangKhieu.CapNhatHocTapNangKhieu(objHocTapNangKhieu); MessageBox.Show("Đã cập nhật dữ liệu."); } catch { MessageBox.Show("Cập nhật không thành công."); } }
private void btn_CaTinh_Luu_Click(object sender, RoutedEventArgs e) { try { string CaTinh = GetRTF(rtb_CaTinh_Editor); UngSinh objCaTinh = new UngSinh(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); objCaTinh.MaUngSinh = obj[0].MaUngSinh; objCaTinh.CaTinh = CaTinh; objCaTinh.CapNhatCaTinh(objCaTinh); MessageBox.Show("Đã cập nhật dữ liệu."); } catch { MessageBox.Show("Cập nhật không thành công."); } }
private void btn_LichSuOnGoi_Luu_Click(object sender, RoutedEventArgs e) { try { string LichSuOnGoi = GetRTF(rtb_LichSuOnGoi_Editor); UngSinh objLichSu = new UngSinh(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); objLichSu.MaUngSinh = obj[0].MaUngSinh; objLichSu.LichSuOnGoi = LichSuOnGoi; objLichSu.CapNhatLichSuOnGoi(objLichSu); MessageBox.Show("Đã cập nhật dữ liệu."); } catch { MessageBox.Show("Cập nhật không thành công."); } }
public frmUngSinh() { InitializeComponent(); //load font LoadFontAndSize(); ObservableCollection <UngSinh> obj = UngSinh.HienThiUngSinh(11); HienThiThongTinChiTiet(obj); HienThiLichSuOnGoi(obj); HienThiCaTinh(obj); HienThiYThucDoiTu(obj); HienThiHocTapNangKhieu(obj); HienThiNhungDiemCoGangThayDoi(obj); HienThiNhanDinhOnGoi(obj); HienThiSucKhoe(obj); HienThiNhanDinhDiem(obj); }
public int ThemTaiKhoan(UngSinh obj) { try { using (SqlConnection conn = getConnect()) { conn.Open(); string q = "Insert into UngSinh values (N'" + obj.TenThanh + "',N'" + obj.HoVaTenLot + "',N'" + obj.TenUngSinh + "',N'" + obj.MaTinhTrang + "',N'" + obj.MaLop + "',N'" + obj.NgaySinh + "',N'" + obj.NoiSinh + "',N'" + obj.NguyenQuan + "',N'" + obj.HoKhauThuongTru + "',N'" + obj.SoCMND + "',N'" + obj.NgayCapCMND + "',N'" + obj.NoiCapCMND + "',N'" + obj.NgayRuaToi + "',N'" + obj.GiaoXuRuaToi + "',N'" + obj.NgayThemSuc + "',N'" + obj.GiaoXuThemSuc + "',N'" + obj.GiaoXu + "',N'" + obj.GiaoPhan + "',N'" + obj.DienThoaiGiaoXu + "',N'" + obj.DienThoaiCaNhan + "',N'" + obj.CaTinh + "',N'" + obj.LichSuOnGoi + "',N'" + obj.YThucDoiTu + "',N'" + obj.HocTapNangKhieu + "',N'" + obj.NhungDiemCoGangThayDoi + "',N'" + obj.NhanDinhOnGoi + "',N'" + obj.SucKhoe + "',N'" + obj.NhanDinhDiem + "', N'" + obj.AnhDaiDien + "') "; SqlCommand myCommand = new SqlCommand(q, conn); myCommand.CommandType = CommandType.Text; myCommand.ExecuteNonQuery(); conn.Close(); } return(1); } catch { return(0); } }
public int SuaUngSinh(UngSinh obj) { try { using (SqlConnection conn = getConnect()) { conn.Open(); string q = "Update UngSinh set TenThanh = N'" + obj.TenThanh + "', HoVaTenLot = N'" + obj.HoVaTenLot + "',TenUngSinh = N'" + obj.TenUngSinh + "',MaTinhTrang =N'" + obj.MaTinhTrang + "',MaLop = N'" + obj.MaLop + "',NgaySinh=N'" + obj.NgaySinh + "',NoiSinh=N'" + obj.NoiSinh + "',NguyenQuan=N'" + obj.NguyenQuan + "',HoKhauThuongTru=N'" + obj.HoKhauThuongTru + "',SoCMND=N'" + obj.SoCMND + "',NgayCapCMND=N'" + obj.NgayCapCMND + "',NoiCapCMND=N'" + obj.NoiCapCMND + "',NgayRuaToi=N'" + obj.NgayRuaToi + "',GiaoXuRuaToi=N'" + obj.GiaoXuRuaToi + "',NgayThemSuc=N'" + obj.NgayThemSuc + "',GiaoXuThemSuc=N'" + obj.GiaoXuThemSuc + "',GiaoXu=N'" + obj.GiaoXu + "',GiaoPhan=N'" + obj.GiaoPhan + "',DienThoaiGiaoXu=N'" + obj.DienThoaiGiaoXu + "',DienThoaiCaNhan=N'" + obj.DienThoaiCaNhan + "',CaTinh=N'" + obj.CaTinh + "',LichSuOnGoi=N'" + obj.LichSuOnGoi + "',YThucDoiTu=N'" + obj.YThucDoiTu + "',HocTapNangKhieu=N'" + obj.HocTapNangKhieu + "',NhungDiemCoGangThayDoi=N'" + obj.NhungDiemCoGangThayDoi + "',NhanDinhOnGoi=N'" + obj.NhanDinhOnGoi + "',SucKhoe=N'" + obj.SucKhoe + "',NhanDinhDiem=N'" + obj.NhanDinhDiem + "', AnhDaiDien = '" + obj.AnhDaiDien + "' where MaUngSinh = '" + obj.MaUngSinh + "' "; SqlCommand myCommand = new SqlCommand(q, conn); myCommand.CommandType = CommandType.Text; myCommand.ExecuteNonQuery(); conn.Close(); } return(1); } catch { return(0); } }
public int CapNhatAnhDaiDien(UngSinh obj) { try { using (SqlConnection conn = getConnect()) { conn.Open(); string q = "Update UngSinh set AnhDaiDien=N'" + obj.AnhDaiDien + "' where MaUngSinh = '" + obj.MaUngSinh + "' "; SqlCommand myCommand = new SqlCommand(q, conn); myCommand.CommandType = CommandType.Text; myCommand.ExecuteNonQuery(); conn.Close(); } return(1); } catch { return(0); } }