private void CapNhatBangDiem()
{
if (Software.mGroup == "SINHVIEN")
{
var ngayThiCheck = (from a in db.GIAOVIEN_DANGKY
where a.NGAYTHI < DateTime.Now
select a
).ToList();
var query = new BANGDIEM();
query.MAMH = frmThongTinThi.ChonMonHoc;
query.MASV = txtMaSV.Text;
query.LAN = (short)frmThongTinThi.LanThi;
query.NGAYTHI = frmThongTinThi.NgayThi;
query.DIEM = float.Parse(txtDiem.Text);
//query.BAITHI = baiThi.ToString();
//db.BANGDIEMs.Add(query);
db.SaveChanges();
}
else
{
return;
};
}
public static void Insert(BANGDIEM _bangdiem)
{
try
{
_bangdiem.CreatedDate = DateTime.Now;
_bangdiem.CreatedBy = GlobalSettings.UserCode;
_bangdiem.CreatedLog = GlobalSettings.SessionMyIP;
_bangdiem.IsRemove = 0;
Database.BANGDIEMs.InsertOnSubmit(_bangdiem);
Database.SubmitChanges();
int _id = _bangdiem.BangDiemId;
//Insert Bang diem chi tiet
List <KHOAHOC_MONHOC> _khmh = KhoaHocMonHocLogic.SelectTheoKhoaHoc(_bangdiem.KhoaHocId);
foreach (var item in _khmh)
{
BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET();
_chitiet.BangDiemId = _id;
_chitiet.MonHocId = item.MonHocId ?? 0;
_chitiet.TenMonHoc = item.TenMonHoc;
_chitiet.IsRemove = 0;
//_chitiet.CreatedDate = DateTime.Now;
//_chitiet.CreatedBy = GlobalSettings.UserCode;
//_chitiet.CreatedLog = GlobalSettings.SessionMyIP;
Database.BANGDIEMCHITIETs.InsertOnSubmit(_chitiet);
Database.SubmitChanges();
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
}
}
public static void Update(BANGDIEM b)
{
var temp = Select(b.HocVienId, b.LopHocId);
temp.DiemTrungBinh = b.DiemTrungBinh;
Database.SubmitChanges();
}
private void btnLuuLop_Click(object sender, EventArgs e)
{
try
{
//insert + Xoa tai BANGDIEM
int _LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
foreach (var item in this.dsXepLopHocVien)
{
//kiem tra ton tai hay khong
List <BANGDIEM> _kiemtratontai = BangDiemLogic.SelectTheoPhieuGhiDanh(item.PhieuGhiDanhId ?? 0);
if (_kiemtratontai == null || _kiemtratontai.Count == 0)
{
BANGDIEM _bangdiem = new BANGDIEM();
_bangdiem.HocVienId = item.HocVienId ?? 0;
_bangdiem.LopHocId = _LopHocId;
_bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0;
_bangdiem.KhoaHocId = item.KhoaHocId ?? 0;
_bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thuc
BangDiemLogic.Insert(_bangdiem);
}
}
List <BANGDIEM> _lstBangDiem_LopHoc = BangDiemLogic.SelectTheoLopHoc(_LopHocId);
if (_lstBangDiem_LopHoc != null && _lstBangDiem_LopHoc.Count > 0)
{
List <BANGDIEM> _bangdiem_Xoa = (from p in _lstBangDiem_LopHoc
where !(from q in this.dsXepLopHocVien select q.PhieuGhiDanhId).Contains(p.PhieuGhiDanhId)
select p).ToList();
if (_bangdiem_Xoa != null && _bangdiem_Xoa.Count > 0)
{
BangDiemLogic.DeleteList(_bangdiem_Xoa);
}
}
//Update SiSo cua LOPHOC
LOPHOC _lophoc = LopHocLogic.SelectSingle(_LopHocId);
LopHocLogic.Update(new LOPHOC()
{
LopHocId = _lophoc.LopHocId,
TenLopHoc = _lophoc.TenLopHoc,
NgayBatDau = _lophoc.NgayBatDau,
NgayKetThuc = _lophoc.NgayKetThuc,
SiSoToiDa = _lophoc.SiSoToiDa,
SiSo = this.dsXepLopHocVien.Count,
KhoaHocId = _lophoc.KhoaHocId,
IsLock = _lophoc.IsLock
});
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG);
frmthongbao.Show();
}
catch (Exception ex)
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI);
frmthongbao.Show();
O2S_Common.Logging.LogSystem.Error(ex);
}
}
/// <summary>
/// Cập nhật bảng điểm
/// </summary>
/// <param name="b"></param>
public static void Update(BANGDIEM b)
{
var temp = Select(b.MaHV, b.MaLop);
temp.DiemNghe = b.DiemNghe;
temp.DiemNoi = b.DiemNoi;
temp.DiemDoc = b.DiemDoc;
temp.DiemViet = b.DiemViet;
Database.SubmitChanges();
}
public bool AddMHhs(int hs, int hk, string mh)
{
HocSinhDBDataContext hdb = new HocSinhDBDataContext();
try {
var kq = from s in hdb.MONHOCs where s.TenMonHoc == mh select s.MaMonHoc;
string mamh = kq.First().ToString();
BANGDIEM bd = new BANGDIEM {
MaBangDiem = hs + mamh, MaHocSinh = hs, MaHocKi = hk, MaMonHoc = mamh, Diem15Phut = 0, Diem1Tiet = 0, DiemCuoiKi = 0
};
hdb.BANGDIEMs.InsertOnSubmit(bd);
hdb.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// Thêm một bảng điểm
/// </summary>
/// <param name="bd">Bảng điểm cần thêm</param>
public static void Insert(BANGDIEM bd)
{
Database.BANGDIEMs.InsertOnSubmit(bd);
Database.SubmitChanges();
}
public void LayBangDiem(ListView lbd, ListViewGroup bd, BANGDIEM BD)
{
string sql = "select HSHS.MAHS, HOTEN, KTM1, KTM2, KTM3, KTM4, KTM5, KT15P1, KT15P2, KT15P3, KT15P4, KT15P5, KT15P6, KT1T1, KT1T2, KT1T3, KT1T4, KT1T5, KT1T6, DIEMTHI, DIEMTB from HSHS, BANGDIEM where HSHS.MAHS = BANGDIEM.MAHS, MAHK = " + BD.MAHK + ", MALOP = " + BD.MALOP + ", MAMONHOC = " + BD.MAMONHOC + ", MANAMHOC = " + BD.MANAMHOC;
}
public static bool InsertPGDFull_XepLop(PHIEUGHIDANH _phieughidanh, PHIEUTHU _phieuthu, List <HOCPHIHOCVIEN> _lsthphv, BANGDIEM _bangdiem, ref int _PhieuGhiDanhId, ref int _PhieuThuId)
{
try
{
// O2S_Common.Logging.LogSystem.Error("Luu log InsertPGDFull");
using (TransactionScope ts = new TransactionScope())
{
//Phieu ghi danh
_phieughidanh.CoSoId = GlobalSettings.CoSoId;
_phieughidanh.CreatedDate = DateTime.Now;
_phieughidanh.CreatedBy = GlobalSettings.UserCode;
_phieughidanh.CreatedLog = GlobalSettings.SessionMyIP;
_phieughidanh.IsRemove = 0;
Database.PHIEUGHIDANHs.InsertOnSubmit(_phieughidanh);
Database.SubmitChanges();
_PhieuGhiDanhId = _phieughidanh.PhieuGhiDanhId;
_phieughidanh.MaPhieuGhiDanh = string.Format("{0}{1:D7}", "PGD", _PhieuGhiDanhId);
Database.SubmitChanges();
//insert bang PHIEUTHU
if (_phieuthu != null && _phieuthu.HocVienId > 0)
{
_phieuthu.PhieuGhiDanhId = _PhieuGhiDanhId;
_phieuthu.CreatedDate = DateTime.Now;
_phieuthu.CreatedBy = GlobalSettings.UserCode;
_phieuthu.CreatedLog = GlobalSettings.SessionMyIP;
_phieuthu.IsRemove = 0;
Database.PHIEUTHUs.InsertOnSubmit(_phieuthu);
Database.SubmitChanges();
_PhieuThuId = _phieuthu.PhieuThuId;
_phieuthu.MaPhieuThu = string.Format("{0}{1:D7}", "PT", _phieuthu.PhieuThuId);
Database.SubmitChanges();
}
//Hocphihocvien
if (_lsthphv != null && _lsthphv.Count > 0)
{
foreach (var item in _lsthphv)
{
item.PhieuGhiDanhId = _PhieuGhiDanhId;
item.PhieuThuId = _phieuthu.PhieuThuId;
item.CreatedDate = DateTime.Now;
item.CreatedBy = GlobalSettings.UserCode;
item.CreatedLog = GlobalSettings.SessionMyIP;
item.IsRemove = 0;
Database.HOCPHIHOCVIENs.InsertOnSubmit(item);
Database.SubmitChanges();
}
}
//insert BANGDIEM
if (_bangdiem.LopHocId != 0)
{
_bangdiem.PhieuGhiDanhId = _PhieuGhiDanhId;
_bangdiem.CreatedDate = DateTime.Now;
_bangdiem.CreatedBy = GlobalSettings.UserCode;
_bangdiem.CreatedLog = GlobalSettings.SessionMyIP;
_bangdiem.IsRemove = 0;
Database.BANGDIEMs.InsertOnSubmit(_bangdiem);
Database.SubmitChanges();
int _id = _bangdiem.BangDiemId;
//Insert Bang diem chi tiet
List <KHOAHOC_MONHOC> _khmh = KhoaHocMonHocLogic.SelectTheoKhoaHoc(_bangdiem.KhoaHocId);
foreach (var item in _khmh)
{
BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET();
_chitiet.BangDiemId = _id;
_chitiet.MonHocId = item.MonHocId ?? 0;
_chitiet.TenMonHoc = item.TenMonHoc;
_chitiet.IsRemove = 0;
//_chitiet.CreatedDate = DateTime.Now;
//_chitiet.CreatedBy = GlobalSettings.UserCode;
//_chitiet.CreatedLog = GlobalSettings.SessionMyIP;
Database.BANGDIEMCHITIETs.InsertOnSubmit(_chitiet);
Database.SubmitChanges();
}
//Update SiSo cua LOPHOC
LOPHOC _lophoc = LopHocLogic.SelectSingle(_bangdiem.LopHocId);
LopHocLogic.Update(new LOPHOC()
{
//LopHocId = _lophoc.LopHocId,
//TenLopHoc = _lophoc.TenLopHoc,
//NgayBatDau = _lophoc.NgayBatDau,
//NgayKetThuc = _lophoc.NgayKetThuc,
//SiSoToiDa = _lophoc.SiSoToiDa,
SiSo = _lophoc.SiSo + 1,
//KhoaHocId = _lophoc.KhoaHocId,
//IsLock = _lophoc.IsLock
});
}
//Update HOCVIEN = Hoc vien chinh thuc
HOCVIEN _hocvien = HocVienLogic.SelectSingle(_phieughidanh.HocVienId ?? 0);
_hocvien.LOAIHOCVIEN = LoaiHocVienLogic.Select(KeySetting.LOAIHOCVIEN_CHINHTHUC);
//Database.SubmitChanges();
//Update TAIKHOAN = được sử dụng
TAIKHOAN _taikhoan = TaiKhoanLogic.SelectTheoTenDangNhap(_hocvien.MaHocVien);
_taikhoan.IsRemove = 0;
Database.SubmitChanges();
ts.Complete();
return(true);
}
}
catch (Exception ex)
{
O2S_Common.Logging.LogSystem.Error(ex);
return(false);
}
}
private void btnLuuPhieu_Click(object sender, EventArgs e)
{
try
{
ValidateLuuPhieu();
DOTHOC _dotHoc = null;
if (cboDotHoc.SelectedValue != null)
{
_dotHoc = DotHocLogic.SelectSingle(O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString()));
}
//Insert bang PHIEUGHIDANH
//insert bang PHIEUTHU; HOCPHIHOCVIEN
//cap nhat bang HOCVIEN trang thai hoc vien = hoc vien chinh thuc + TAIKHOAN=chinh thuc
PHIEUGHIDANH _phieughidanh = new PHIEUGHIDANH();
_phieughidanh.HocVienId = this.HocVienId_Select;
_phieughidanh.KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
_phieughidanh.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
_phieughidanh.NgayGhiDanh = DateTime.ParseExact(dateNgayGhiDanh.Text, "HH:mm:ss dd/MM/yyyy", CultureInfo.InvariantCulture);
//tong tien cua lop hoc den thoi diem hien tai
List <DOTHOC> _lstDotHoc = DotHocLogic.SelectTheoLopHoc(_phieughidanh.LopHocId ?? 0);
_phieughidanh.HocPhiKH = _lstDotHoc != null?_lstDotHoc.Sum(o => o.HocPhi) : 0;
_phieughidanh.SoTietKH = _lstDotHoc != null?_lstDotHoc.Sum(o => o.SoBuoiHoc) : 0;
_phieughidanh.HocPhiHocVienKH = O2S_Common.TypeConvert.Parse.ToDecimal(lblThanhTienKhoaHoc.Text.Replace(",", ""));
_phieughidanh.SoTietHocVienKH = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text);
_phieughidanh.ThuKhoanKhac = TinhTongTien_ThuThem();
_phieughidanh.TongTien = O2S_Common.TypeConvert.Parse.ToDecimal(numTongTien.Text);
_phieughidanh.DaDong = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", ""));
_phieughidanh.ConNo = O2S_Common.TypeConvert.Parse.ToDecimal(numConNo.Text);
_phieughidanh.MienGiam_PhanTram = O2S_Common.TypeConvert.Parse.ToInt16(numMienGiam_PTram.Value.ToString());
_phieughidanh.MienGiam_Tien = O2S_Common.TypeConvert.Parse.ToDecimal(numMienGiam_Tien.Text.Replace(",", ""));
_phieughidanh.LyDoMienGiam = txtLyDoMienGiam.Text;
if (GlobalSettings.UserID != -1)
{
_phieughidanh.NhanVienId = GlobalSettings.UserID;
}
//insert bang PHIEUTHU
PHIEUTHU _phieuthu = new PHIEUTHU();
List <HOCPHIHOCVIEN> _lsthphv = new List <HOCPHIHOCVIEN>();
if (O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", "")) > 0)
{
//_phieuthuInsert.PhieuGhiDanhId = this.PhieuGhiDanhId;
_phieuthu.CoSoId = GlobalSettings.CoSoId;
_phieuthu.HocVienId = this.HocVienId_Select;
_phieuthu.ThoiGianThu = DateTime.Now;
_phieuthu.SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(numDaDong.Text.Replace(",", ""));
_phieuthu.NoiDung = cboDotHoc.Text;
_phieuthu.GhiChu = "Thu tiền đợt học: " + cboDotHoc.Text;
//Tien Dot Hoc
if (cboDotHoc.SelectedValue != null)
{
HOCPHIHOCVIEN _hphv_kh = new HOCPHIHOCVIEN()
{
Stt = 1,
HocVienId = this.HocVienId_Select,
DmDichVuId = O2S_Common.TypeConvert.Parse.ToInt32(cboDotHoc.SelectedValue.ToString()),
TenDichVu = cboDotHoc.Text,
SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(lblThanhTienKhoaHoc.Text.Replace(",", "")),
SoLuong = O2S_Common.TypeConvert.Parse.ToDecimal(numSoBuoiHVDangKy.Text.Replace(",", "")),
DonGia = O2S_Common.TypeConvert.Parse.ToDecimal(numHocPhi.Text) / O2S_Common.TypeConvert.Parse.ToDecimal(numSoTietHoc.Text),
//PhieuThuId = _phieuthuId,
GhiChu = "",
};
_lsthphv.Add(_hphv_kh);
}
//tien khoan Khac
if (gridViewKhoanKhac.RowCount > 0)
{
_phieuthu.NoiDung += " và khoản khác";
_phieuthu.GhiChu += " và khoản khác";
int _stt_thuthem = 2;
for (int i = 0; i < gridViewKhoanKhac.RowCount; i++)
{
object _noidungkt = gridViewKhoanKhac.GetRowCellValue(i, "noidung");
if (_noidungkt != null)
{
HOCPHIHOCVIEN _hphv_khac = new HOCPHIHOCVIEN()
{
Stt = _stt_thuthem,
HocVienId = this.HocVienId_Select,
DmDichVuId = 0,
TenDichVu = gridViewKhoanKhac.GetRowCellValue(i, "noidung") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "noidung").ToString(),
SoTien = O2S_Common.TypeConvert.Parse.ToDecimal(gridViewKhoanKhac.GetRowCellValue(i, "sotien").ToString()),
SoLuong = 1,
DonGia = O2S_Common.TypeConvert.Parse.ToDecimal(gridViewKhoanKhac.GetRowCellValue(i, "sotien").ToString()),
//PhieuThuId = _phieuthuId,
GhiChu = gridViewKhoanKhac.GetRowCellValue(i, "ghichu") == null ? "" : gridViewKhoanKhac.GetRowCellValue(i, "ghichu").ToString(),
};
_lsthphv.Add(_hphv_khac);
_stt_thuthem += 1;
}
}
}
}
//bang diem
BANGDIEM _bangdiem = new BANGDIEM();
_bangdiem.HocVienId = this.HocVienId_Select;
_bangdiem.LopHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboLopHoc.SelectedValue.ToString());
// _bangdiem.PhieuGhiDanhId = item.PhieuGhiDanhId ?? 0;
_bangdiem.KhoaHocId = O2S_Common.TypeConvert.Parse.ToInt32(cboKhoaHoc.SelectedValue.ToString());
_bangdiem.TrangThai = 0;//=0: xep lop; =1: dang hoc; =3: co diem; =99:ket thu
if (PhieuGhiDanhLogic.InsertPGDFull_XepLop(_phieughidanh, _phieuthu, _lsthphv, _bangdiem, ref this.PhieuGhiDanhId, ref this.PhieuThuId))
{
HOCVIEN _hv = HocVienLogic.SelectSingle(this.HocVienId_Select);
MessageBox.Show(string.Format("Học viên {0} đã được chuyển thành học viên chính thức với tài khoản:{1}Tên đăng nhập: {2}{3}Mật khẩu: {4}",
_hv.TenHocVien, Environment.NewLine, _hv.MaHocVien, Environment.NewLine, _hv.MaHocVien),
"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
isSave = true;
btnLuuPhieu.Enabled = false;
LoadPhieuGhiDanh();
if (this.PhieuThuId != 0)
{
btnInBienLai.Enabled = true;
if (MessageBox.Show("Bạn có muốn in phiếu ghi danh vừa lưu?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
InBienLaiThuTien_Process(this.PhieuThuId);
}
}
}
else
{
O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.THEM_MOI_THAT_BAI);
frmthongbao.Show();
}
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
