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);
}
}
