private void btnThem_Click(object sender, EventArgs e) { try { PhanCong pc = new PhanCong() { MaPC = txtMaPC.Text, MaGV = cmbGiangVien.EditValue.ToString(), MaLop = cmbLop.EditValue.ToString(), MaMH = cmbMonHoc.EditValue.ToString(), NamHoc = dateNamHoc.DateTime.Year, HocKy = (byte)numHocKy.Value }; if (!PhanCongBUS.KiemTraTonTai(pc)) { PhanCongBUS.Them(pc); StaticClass.LuuThayDoi(); log.GhiFile("Thêm phân công giảng dạy: " + pc.MaPC); LoadSourceGridControl(); txtMaPC.Text = PhanCongBUS.SinhMa(); } else { MsgboxUtil.Exclamation("Đã tồn tại một phân công y hệt như thế này rồi. Vui lòng kiểm tra lại"); } } catch (Exception ex) { ExceptionUtil.ThrowMsgBox(ex.Message); } }
public errType ThemNVVaoDuAn(PhanCong pc) { using (var db = new Connection()) { NhanVien a = db.NhanViens.SingleOrDefault(x => x.NhanVienID == pc.NhanVienID); DuAn b = db.DuAns.SingleOrDefault(x => x.DuAnID == pc.DuAnID); if (a != null && b != null) { db.PhanCongs.Add(pc); return(errType.ThanhCong); } else { if (a == null) { return(errType.KhongCoNhanVien); } else { return(errType.KhongCoDuAn); } } } }
private void btnXoaNV_Click(object sender, EventArgs e) { if (dgvDANV.RowCount >= 1) { String a = dgvDuAn.CurrentRow.Cells["MaDuAn"].Value.ToString(); string b = dgvDANV.CurrentRow.Cells["MaNV"].Value.ToString(); try { PhanCong pc = new PhanCong(); pc = context.PhanCongs.Find(b, a); context.PhanCongs.Remove(pc); context.SaveChanges(); MessageBox.Show("Đã xóa"); LoadNV(); } catch (Exception ex) { MessageBox.Show("Xóa nhân viên tham gia dự án thất bại\n" + ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Chưa có nhân viên nào tham gia dự án"); } }
private void simpleButton1_Click(object sender, EventArgs e) { #region Xác nhận DialogResult dg = new DialogResult(); dg = XtraMessageBox.Show("Xác nhận đã trả lương cho nhân viên, thao tác này không thể hoàn tác !", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dg == DialogResult.Yes) { try { PhanCong pc1 = new PhanCong(); pc1.maPhanCong = _maPhanCongDangChon; pc1.trangThai = "X"; pc1.daTraLuong = "Đã Trả Lương"; if (pcbll.suaPhanCong_DaTraLuong(pc1, _maPhanCongDangChon)) { XtraMessageBox.Show("Đã xác nhận !"); loadDataLuong(); } } catch (Exception ex) { XtraMessageBox.Show("Lỗi: " + ex); } } #endregion }
private void btnThemNV_Click(object sender, EventArgs e) { if (kt == 0) { clear(); MessageBox.Show("Mời nhập thông tin"); kt = 1; return; } else { if (txtMaDA_PC.Text.Trim() == "" || txtMaNV_PC.Text.Trim() == "" || txtSG_PC.Text.Trim() == "") { MessageBox.Show("Chưa nhập đủ thông tin"); } else { PhanCong pc = new PhanCong(); pc.MaDA = Convert.ToInt32(txtMaDA_PC.Text); pc.MaNV = Convert.ToInt32(txtMaNV_PC.Text); pc.SoGio = Convert.ToInt32(txtSG_PC.Text); context.PhanCongs.Add(pc); context.SaveChanges(); kt = 0; init_PC(); } } }
public static List <ChamSoc> GetListChamSocFromPhanCong(PhanCong pc) { List <ChamSoc> result = null; try { result = DataProvider.ExecuteReader((SqlDataReader row) => { return(new ChamSoc() { MaChamSoc = row.GetValueDefault <string>(0), NgayGhiNhan = row.GetValueDefault <DateTime>(1), TinhTrangCongViec = row.GetValueDefault <string>(2), LuongSua = row.GetValueDefault <float>(3), DaChoAn = row.GetValueDefault <bool>(4), DaDonVeSinh = row.GetValueDefault <bool>(5), DaVatSua = row.GetValueDefault <bool>(6), MaPhanCong = row.GetValueDefault <string>(7), MaBo = row.GetValueDefault <string>(8) }); }, string.Format("select * from ChamSoc where maphancong = '{0}' and NgayGhiNhan='{1}'", pc.MaPhanCong, DateTime.Now)); } catch (Exception) { return(result); } //foreach (var item in result) //{ // IncludeTinhTrangBo(item); //} return(result); }
private void btnThemDA_NV_Click(object sender, EventArgs e) { if (txtMaDA.Text.Trim() == "" || cbbTenNV.Text.Trim() == "" || txtSogio.Text.Trim() == "") { MessageBox.Show("Chưa nhập đủ thông tin"); } else { int mada = Convert.ToInt32(txtMaDA.Text); int manv = Convert.ToInt32(cbbTenNV.Text); int sogio = Convert.ToInt32(txtSogio.Text); var da = context.PhanCongs.Where(x => x.MaDA == mada).OrderByDescending(x => x.MaNV).ToList(); da = da.Where(x => x.MaNV == manv).ToList(); try { } catch { } PhanCong pc = context.PhanCongs.Where(x => x.MaDA == mada).Where(x => x.MaNV == manv).OrderBy(x => x.SoGio).ToList()[0]; if (pc.SoGio == 0) { PhanCong pc1 = new PhanCong(); pc1.MaDA = mada; pc1.MaNV = manv; pc1.SoGio = sogio; context.PhanCongs.Add(pc1); } else { pc.SoGio = sogio; } context.SaveChanges(); } }
public AssignSubjectTeacherForClass() { assignment = new PhanCong(); classes = DataProvider.Instance.DB.LopHocs.ToList(); teachers = DataProvider.Instance.DB.GiaoViens.ToList(); subjects = DataProvider.Instance.DB.MonHocs.ToList(); InitCommand(); }
public bool Update(PhanCong pc, out string message) { bool result = false; string sql = string.Format("update PHANCONG set HeSo={0}" + "where MaCa = {1} and MaNV ={2}", pc.HeSo, pc.MaCa, pc.MaNV); result = main.ExecuteNonQuery(sql, out message); return(result); }
public bool ThemPhanCong(PhanCong pc) { if (!db.PhanCongs.Contains(pc)) { db.PhanCongs.InsertOnSubmit(pc); db.SubmitChanges(); return(true); } return(false); }
public void ThemLichLam(string manv, DateTime ngaybatdaulam, DateTime ngayketthuc, string calam) { PhanCong pc = new PhanCong(); pc.MaNV = manv; pc.NgayBatDauLam = ngaybatdaulam; pc.NgayKetThuc = ngayketthuc; pc.CaLam = calam; nv.ThemLichLam(pc); }
public ActionResult XemPhanCong(int?ID) { PhanCong phancong = db.PhanCongs.Where(x => x.ID == ID).FirstOrDefault(); ViewBag.batdongsan = db.BatDongSans.Where(x => x.ID == phancong.IDBatDongSan).FirstOrDefault(); if (phancong == null) { return(HttpNotFound()); } return(PartialView("XemPhanCong", phancong)); }
//add tinh trang bo public static ChamSoc AddTinhTrangBo(TinhTrangBo tinhTrangBo) { ChamSoc result = null; try { result = DataProvider.ExecuteReaderOne((SqlDataReader row) => { return(new ChamSoc() { MaChamSoc = row.GetValueDefault <string>(0), NgayGhiNhan = row.GetValueDefault <DateTime>(1), TinhTrangCongViec = row.GetValueDefault <string>(2), LuongSua = row.GetValueDefault <float>(3), DaChoAn = row.GetValueDefault <bool>(4), DaDonVeSinh = row.GetValueDefault <bool>(5), DaVatSua = row.GetValueDefault <bool>(6), MaPhanCong = row.GetValueDefault <string>(7), MaBo = row.GetValueDefault <string>(8) }); }, string.Format("select top 1 * from chamsoc where maphancong = '{0}' and mabo = '{1}' and NgayGhiNhan='{2}'", tinhTrangBo.MaPhanCong, tinhTrangBo.MaBo, DateTime.Now)); } catch (Exception) { return(null); } try { DataProvider.ExecuteNonQuery(string.Format("insert into TinhTrangBo(MaChamSoc,ThoiGianGhiNhan,CanNang,ChieuCao) values ('{0}', '{1}', {2}, {3})", result.MaChamSoc, DateTime.Now, tinhTrangBo.CanNang, tinhTrangBo.ChieuCao)); } catch (Exception) { return(null); } PhanCong temp = null; try { temp = DataProvider.ExecuteReaderOne((SqlDataReader row) => { return(new PhanCong() { MaPhanCong = row.GetValueDefault <string>(0), MaChuong = row.GetValueDefault <string>(5) }); }, string.Format("select top 1 * from phancong where maphancong = '{0}'", result.MaPhanCong)); } catch (Exception) { return(null); } result.MaChuong = temp.MaChuong; return(result); }
public static void Them(PhanCong pc) { try { db.PhanCongs.InsertOnSubmit(pc); } catch (Exception ex) { throw ex; } }
public ActionResult XacNhanBanThanhCong(int?ID) { PhanCong phancong = db.PhanCongs.Where(x => x.ID == ID).FirstOrDefault(); if (phancong == null) { return(HttpNotFound()); } phancong.PhanTramHoaHong = phancong.PhanTramHoaHong * 100; ViewBag.tienhoahong = phancong.BatDongSan.Gia * phancong.PhanTramHoaHong / 100; return(PartialView("XacNhanBanThanhCong", phancong)); }
public static bool KiemTraTonTai(PhanCong pc) { try { return(db.PhanCongs.Any(p => p.MaGV == pc.MaGV && p.MaMH == pc.MaMH && p.MaLop == pc.MaLop && p.HocKy == pc.HocKy && p.NamHoc == pc.NamHoc)); } catch (Exception ex) { throw ex; } }
public bool XoaPhanCong(ref string err, string MaNV) { QuanLyNVEntities qlnvEntity = new QuanLyNVEntities(); PhanCong pc = new PhanCong(); pc.MaNV = MaNV; qlnvEntity.PhanCongs.Attach(pc); qlnvEntity.PhanCongs.Remove(pc); qlnvEntity.SaveChanges(); return(true); }
private void dgvPhanCong_CellClick(object sender, DataGridViewCellEventArgs e) { int n = dgvPhanCong.CurrentCell.RowIndex; int iMaPC = Convert.ToInt32(dgvPhanCong.Rows[n].Cells[0].Value.ToString()); PhanCong pc = dbs.PhanCongs.First(p => p.MaPC == iMaPC); cbbNhomSV.Text = pc.MaNhom.ToString(); cbbTenDT.Text = pc.DeTai.TenDT; cbbHocKy.Text = pc.HocKy.ToString(); cbbNamHoc.Text = pc.NamHoc.ToString(); cbbGVHD.Text = pc.GiangVien.TenGV; }
public bool xoaPhanCong(string maNV) { PhanCong nv1 = new PhanCong(); if (nv1 != null) { nv1 = db.PhanCongs.Single(a => a.maNhanVien == maNV); db.PhanCongs.DeleteOnSubmit(nv1); db.SubmitChanges(); return(true); } return(false); }
public bool ThemPC(string MaNV, string MaDA, string NgayBD, string NgayKT, ref string err) { QuanLyNVEntities qlnvEntity = new QuanLyNVEntities(); PhanCong pc = new PhanCong(); pc.MaNV = MaNV; pc.MaDA = MaDA; pc.ThoiGianBatDau = Convert.ToDateTime(NgayBD, cultures); pc.ThoiGianKetThuc = Convert.ToDateTime(NgayKT, cultures); qlnvEntity.PhanCongs.Add(pc); qlnvEntity.SaveChanges(); return(true); }
private void btn_all_salar_Click(object sender, EventArgs e) { blPC = new BLPhanCong(); int heso = 4; List <int> ListOfOff = new List <int>(); int manv = int.Parse(cbb_empIDs.Text.Trim()); List <PhanCong> pcs = new List <PhanCong>(); for (int i = 0; i < checkedLists_ABS.Count(); i++) { foreach (int item in checkedLists_ABS[i].CheckedItems) { //ListOfOff.Contains(item); ListOfOff.Add(item); } } // ListOfOff = checkedLists_ABS[i].CheckedItems.OfType<int>().ToList(); while (ListOfOff.Count != 0) { int maCa1 = ListOfOff[0]; int count = 0; for (int i = 0; i < ListOfOff.Count(); i++) { if (ListOfOff[i] == maCa1) { count++; } } while (ListOfOff.Contains(maCa1)) { ListOfOff.Remove(maCa1); } PhanCong pc = new PhanCong(); pc.MaNV = manv; pc.MaCa = maCa1; pc.HeSo = 4 - count; if (blPC.Update(pc, out string a)) { string str = string.Format("MaNV: {0} MaCa: {1} HeSo: {2}", pc.MaNV, pc.MaCa, pc.HeSo); MessageBox.Show(str); } else { MessageBox.Show(a); } } }
public ActionResult XacNhanBanThanhCong(PhanCong epcs) { if (epcs == null) { return(HttpNotFound()); } var phancong = db.PhanCongs.Where(x => x.ID == epcs.ID).FirstOrDefault(); BatDongSan batdongsan = db.BatDongSans.Where(x => x.ID == epcs.IDBatDongSan).FirstOrDefault(); batdongsan.TrangThai = 4; batdongsan.NgayCapNhat = DateTime.Now; db.Entry(batdongsan).State = EntityState.Modified; db.SaveChanges(); return(Redirect("Index")); }
public bool suaPhanCong_DaTraLuong(PhanCong pc, int maPC) { PhanCong pc1 = new PhanCong(); pc1 = db.PhanCongs.Where(a => a.maPhanCong == maPC).SingleOrDefault(); if (pc1 != null) { //nv1.maNhanVien = nv.maNhanVien; pc1.trangThai = pc.trangThai; pc1.daTraLuong = pc.daTraLuong; db.SubmitChanges(); return(true); } return(false); }
public List <PhanCong> LayMaNhanVienTrongLichLam(string manv) { List <PhanCong> listpc = new List <PhanCong>(); var lstpc = db.spPhanCong_SelectID(manv).ToList(); foreach (var n in lstpc) { PhanCong ns = new PhanCong() { MaNV = n.MaNV, NgayBatDauLam = n.NgayBatDauLam, NgayKetThuc = n.NgayKetThuc, CaLam = n.CaLam }; listpc.Add(ns); } return(listpc); }
public List <PhanCong> LayLichLam() { List <PhanCong> listpc = new List <PhanCong>(); var lstpc = db.spPhanCong_SelectAll().ToList(); foreach (var n in lstpc) { PhanCong pc = new PhanCong() { MaNV = n.MaNV, NgayBatDauLam = n.NgayBatDauLam, NgayKetThuc = n.NgayKetThuc, CaLam = n.CaLam }; listpc.Add(pc); } return(listpc); }
public bool suaPhanCong(PhanCong pc, int maPC) { PhanCong pc1 = new PhanCong(); pc1 = db.PhanCongs.Where(a => a.maPhanCong == maPC).SingleOrDefault(); if (pc != null) { pc1.maPhanCong = pc.maPhanCong; //pc1.maNhanVien = ct.te; pc1.soNgayCong = pc1.soNgayCong - 1; pc1.tienLuong = pc1.tienLuong - 500000; pc1.trangThai = pc.trangThai; db.SubmitChanges(); return(true); } return(false); }
public bool suaPhanCong_DoiNgay(PhanCong nv, int maPC) { PhanCong nv1 = new PhanCong(); nv1 = db.PhanCongs.Where(a => a.maPhanCong == maPC).SingleOrDefault(); if (nv1 != null) { nv1.ngayBatDauLam = nv.ngayBatDauLam; nv1.ngayKetThuc = nv.ngayKetThuc; nv1.soNgayCong = nv.soNgayCong; // nv1.trangThai = nv.trangThai; nv1.tienLuong = nv.tienLuong; db.SubmitChanges(); return(true); } return(false); }
private void btnThêm_Click(object sender, EventArgs e) { DataDiagramDataContext data = new DataDiagramDataContext(); NhanVien NV = new NhanVien(); PhanCong PC = new PhanCong(); try { NV.MaNV = txtMaNV.Text; NV.HoTen = txtHoTen.Text; PC.MaNV = txtMaNV.Text; PC.MaDA = txtDuAn.Text; NV.Luong = Convert.ToInt32(txtLuong.Text); NV.MaNGS = txtMaNGS.Text; NV.MaPB = txtMaPB.Text; if (rabtn_nam.Checked == true) { NV.GT = false; } if (rabtn_nu.Checked == true) { NV.GT = true; } NV.NS = Convert.ToDateTime(dtpBirtday.Value.ToShortDateString()); data.NhanViens.InsertOnSubmit(NV); data.PhanCongs.InsertOnSubmit(PC); data.SubmitChanges(); txtMaNV.Text = ""; txtHoTen.Text = ""; ///txtNS.Text = ""; txtLuong.Text = ""; txtMaNGS.Text = ""; txtMaPB.Text = ""; dgvNhanVien.DataSource = bus.getData1(); dgvNhanVien.Refresh(); MessageBox.Show("Đã thêm thành công"); } catch (Exception ex) { Console.Write(ex); MessageBox.Show("Nhập liệu sai!!!"); } }
void phanCongRanDomGV(PhanCong pc) { var PhanCong = from x in dbs.PhanCongs select x; int SLGV = dbs.GiangViens.Count(); int MaGVHD = Convert.ToInt32(pc.GVHuongDan); int MaGVPhanBien; int UyVien; MaGVPhanBien = RanDom_GVPB_UV(SLGV, MaGVHD, -1); UyVien = RanDom_GVPB_UV(SLGV, MaGVHD, MaGVPhanBien); pc.GVPhanBien = MaGVPhanBien; pc.UyVien = UyVien; dbs.SubmitChanges(); }
public void deletePhanCong(PhanCong p) { try { openConnection(); SqlCommand cmd = new SqlCommand("XoaPC", Conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_PhanCong", p.ID_PhanCong); cmd.ExecuteNonQuery(); } catch (Exception ex) { new Exception("Error: " + ex.Message); } finally { closeConnection(); } }