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