public JsonResult AddComment(int macv, string noidung)
{
bool status = true;
UserSession user = SessionHelper.GetSession();
BinhLuan b = new BinhLuan();
b.MaCV = macv;
b.MaNV = user.id;
b.BinhLuan1 = noidung;
b.created_at = DateTime.Now;
string ten = db.NhanViens.Find(b.MaNV).HoTen;
try
{
db.BinhLuans.Add(b);
CongViec c = db.CongViecs.Find(macv);
db.SaveLog(SessionHelper.GetSession().id, "Đã thêm bình luận cho công việc: " + c.MaCV + "_" + c.TieuDe, "Công việc");
db.SaveChanges();
}
catch (Exception e)
{
status = false;
}
return(Json(new
{
noidung = noidung,
macv = macv,
nhavien = user.id,
ten = ten,
status = status
}));
}
// hàm xóa
public void delete(CongViec cv)
{
CongViec ph = db.congViecs.Find(cv.CongViecId);
db.congViecs.Remove(ph);
db.SaveChanges();
}
public static List <QuanLyNhanVien> ToListNVPBDTOs(List <NhanVien> nhanViens, List <ChiTietNhanVien> chiTietNhanViens,
List <PhongBan> phongBans, List <ChucVu> chucVus, List <NhanVienCongViec> nhanVienCongViecs, List <CongViec> congViecs,
List <HopDong> hopDongs, List <Account> accounts, string id)
{
List <QuanLyNhanVien> listNVPB = new List <QuanLyNhanVien>();
foreach (NhanVien nhanVien in nhanViens)
{
//Tìm từng đứa một để chuyển qua DTO đưa lên cho người dùng xem
if (nhanVien.TrangThai == 0 || nhanVien.PhongBanId != id)
{
continue;
}
ChiTietNhanVien chiTietNhanVien = chiTietNhanViens.Find(x => x.ChiTietNhanVienId == nhanVien.NhanVienId);
PhongBan phongBan = phongBans.Find(x => x.PhongBanId == nhanVien.PhongBanId);
ChucVu chucVu = chucVus.Find(x => x.ChucVuId == nhanVien.ChucVuId);
//Tìm công việc hiện tại ứng với nhân viên
NhanVienCongViec nhanVienCongViec = nhanVienCongViecs.Find(x => x.NhanVienId == nhanVien.NhanVienId && x.NgayKetThuc == null);
CongViec congViec = null;
if (nhanVienCongViec != null)
{
congViec = congViecs.Find(x => x.CongViecId == nhanVienCongViec.CongViecId);
}
//Tìm hợp đồng hiện tại ứng với nhân viên
HopDong hopDong = hopDongs.Find(x => x.NhanVienId == nhanVien.NhanVienId && x.TrangThai == 1);
Account account = accounts.Find(x => x.AccountId == nhanVien.NhanVienId);
//Chuyển thành DTO
listNVPB.Add(ToDTO(nhanVien, chiTietNhanVien, phongBan, chucVu, congViec, hopDong, account));
}
return(listNVPB);
}
public string Add(CongViec obj)
{
myData.CongViecs.Add(obj);
myData.SaveChanges();
return(null);
}
private void btnXoa_Click(object sender, EventArgs e)
{
CongViec tg = getCongViecWithID();
if (tg.ID == 0)
{
MessageBox.Show("Chưa có công việc nào được chọn",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
DialogResult rs = MessageBox.Show("Bạn có chắc chắn xóa công việc này?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (rs == DialogResult.Cancel)
{
return;
}
ModelContext.XoaCongViec(tg);
MessageBox.Show("Xóa công việc thành công",
"Thông báo",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
LoadDgv();
}
public async Task <CongViec> Update(CongViec congviec)
{
return(await WithConnection(async c =>
{
CongViec obj = await c.GetAsync(congviec);
if (obj == null)
{
throw new Exception(string.Format("Update id {0} not exist", congviec.CongViecId.ToString()));
}
if (obj.CtrVersion != congviec.CtrVersion)
{
throw new Exception(string.Format("Update id {0} have version confict"
, congviec.CongViecId.ToString()));
}
congviec.CtrVersion += 1;
var result = await c.UpdateAsync(congviec);
if (result != true)
{
throw new Exception("Update Fail");
}
return congviec;
}));
}
public string Update(CongViec obj)
{
myData.CongViecs.Update(obj);
myData.SaveChanges();
return(null);
}
public IActionResult Post([FromBody] CongViec cb)
{
cb.TrangThai = true;
try
{
CongViec tour = new CongViec()
{
MaCongViec = cb.MaCongViec,
TenCongViec = cb.TenCongViec,
MaNhiemVu = cb.MaNhiemVu,
CapCongViec = cb.CapCongViec,
MoTaCongViec = cb.MoTaCongViec,
NgayBatDauDuKien = cb.NgayBatDauDuKien,
NgayKetThucDuKien = cb.NgayKetThucDuKien,
SoTietChuan = cb.SoTietChuan,
SoLuongConLai = cb.SoLuongConLai,
SoLuongDangKy = cb.SoLuongDangKy,
TrangThai = cb.TrangThai
};
_db.CongViec.Add(tour);
_db.SaveChanges();
return(Ok("Them thanh cong"));
}
catch (Exception)
{
return(BadRequest());
}
}
public static QuanLyNhanVien ToDTO(this NhanVien nhanVien, ChiTietNhanVien chiTietNhanVien, PhongBan phongBan,
ChucVu chucVu, CongViec congViec, HopDong hopDong, Account account)
{
if (account == null)
{
account = new Account();
}
if (chiTietNhanVien == null)
{
chiTietNhanVien = new ChiTietNhanVien();
}
if (phongBan == null)
{
phongBan = new PhongBan();
}
if (chucVu == null)
{
chucVu = new ChucVu();
}
if (congViec == null)
{
congViec = new CongViec();
}
if (hopDong == null)
{
hopDong = new HopDong();
}
return(new QuanLyNhanVien()
{
NhanVienId = nhanVien.NhanVienId,
HoNhanVien = nhanVien.HoNhanVien,
TenNhanVien = nhanVien.TenNhanVien,
PhongBanId = phongBan.PhongBanId,
TenPhongBan = phongBan.TenPhongBan,
ChucVuId = chucVu.ChucVuId,
TenChucVu = chucVu.TenChucVu,
CongViecId = congViec.CongViecId,
TenCongViec = congViec.TenCongViec,
LuongCanBan = hopDong.LuongCanBan,
NgaySinh = chiTietNhanVien.NgaySinh.ToString(),
NoiSinh = chiTietNhanVien.NoiSinh,
TrinhDoHocVan = chiTietNhanVien.TrinhDoHocVan,
GioiTinh = chiTietNhanVien.GioiTinh,
CMND = chiTietNhanVien.CMND,
NgayCapCMND = chiTietNhanVien.NgayCapCMND.ToString(),
DiaChi = chiTietNhanVien.DiaChi,
SDT = chiTietNhanVien.SDT,
Email = chiTietNhanVien.Email,
HinhAnh = chiTietNhanVien.HinhAnh,
TaiKhoan = account.TaiKhoan,
Quyen = account.Quyen,
MatKhau = account.MatKhau,
});
}
//hàm thêm
public void insert(CongViec cv)
{
CongViec p = new CongViec();
p.TenCV = cv.TenCV;
db.congViecs.Add(p);
db.SaveChanges();
}
public static CongViecDTO ToDTO(this CongViec congViec)
{
return(new CongViecDTO()
{
CongViecId = congViec.CongViecId,
TenCongViec = congViec.TenCongViec
});
}
//ham sửa
public void Update(CongViec cv)
{
CongViec p = db.congViecs.SingleOrDefault(x => x.CongViecId == cv.CongViecId);
p.CongViecId = cv.CongViecId;
p.TenCV = cv.TenCV;
db.SaveChanges();
}
public ActionResult DeleteConfirmed(int id)
{
CongViec congViec = db.CongViecs.Find(id);
db.CongViecs.Remove(congViec);
db.SaveChanges();
db.SaveLog(SessionHelper.GetSession().id, "Đã xóa công việc: " + congViec.MaCV + "_" + congViec.TieuDe, "Công việc");
return(RedirectToAction("Index"));
}
public CongViecView(CongViec cv)
{
CongViecID = cv.CongViecID;
TieuDe = cv.TieuDe;
ThoiGianHoanThanh = cv.ThoiGianHoanThanh;
NoiDung = cv.NoiDung;
NguoiDungID = cv.NguoiDungID;
DanhDau = cv.PhanLoaiCongViec == "ChuaHoanThanh" || cv.PhanLoaiCongViec == "DangThucHien" ? false : true;
}
private void btnThem_Click(object sender, EventArgs e)
{
CongViec a = new CongViec();
a.ID = 0;
FrmChiTietCongViec form = new FrmChiTietCongViec(a);
form.ShowDialog();
LoadDgv();
}
public eCongViec layCongViecTheoMa(string ma)
{
CongViec cv = db.CongViecs.Where(x => x.maCongViec.Equals(ma)).FirstOrDefault();
if (cv != null)
{
eCongViec congviec = new eCongViec(cv.maCongViec, null, cv.tenCongViec, cv.ngayBatDau, cv.ngayKetThuc, cv.tienDoCongViec, cv.trangThai, cv.viTriCongViec);
return(congviec);
}
return(null);
}
private void btnSave_Click(object sender, EventArgs e)
{
CongViec cv = new CongViec();
cv.TenCV = txtTenCV.Text;
new CongViecModel().insert(cv);
MessageBox.Show("Thành Công");
// grcCongViec.RefreshDataSource();
//
CongViecForm_Load(sender, e);
}
// POST: odata/CongViecs
public IHttpActionResult Post(CongViec congViec)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CongViecs.Add(congViec);
db.SaveChanges();
return(Created(congViec));
}
public ActionResult Edit([Bind(Include = "MaCV,TieuDe,NgayBatDau,NgayKetKhuc,TrangThai,PhamVi")] CongViec congViec)
{
if (ModelState.IsValid)
{
db.Entry(congViec).State = EntityState.Modified;
db.SaveChanges();
db.SaveLog(SessionHelper.GetSession().id, "Đã sửa thông tin công việc: " + congViec.MaCV + "_" + congViec.TieuDe, "Công việc");
return(RedirectToAction("Index"));
}
ViewBag.TrangThai = new SelectList(db.TrangThais, "Ma", "TinhTrang", congViec.TrangThai);
return(View(congViec));
}
public IActionResult Post3(string id)
{
try{
CongViec del = _db.CongViec.FirstOrDefault(x => x.MaCongViec == id);
del.TrangThai = false;
_db.SaveChanges();
return(Ok("Xoa thanh cong"));
}
catch {
return(BadRequest());
}
}
public string Add(CongViec obj)
{
//Kiểm tra khóa chính
if (myData.CongViecs.ToList().Find(x => x.CongViecId == obj.CongViecId) != null)
{
return("Công việc id đã tồn tại");
}
myData.CongViecs.Add(obj);
myData.SaveChanges();
return(null);
}
/// <summary>
/// name: Quynh
/// content: Cap nhat thong tin cua cong viec
/// </summary>
public void Update(eCongViec entity)
{
CongViec congViec = db.CongViecs.Where(t => t.maCongViec.Equals(entity.MaCongViec)).FirstOrDefault();
congViec.tenCongViec = entity.TenCongViec;
congViec.tienDoCongViec = entity.Tiendo;
congViec.trangThai = entity.TrangThai;
congViec.ngayBatDau = entity.NgayBatDau;
congViec.ngayKetThuc = entity.NgayKetThuc;
congViec.viTriCongViec = entity.ViTriCongViec;
db.SubmitChanges();
}
private CongViec getCongViecWithID()
{
try
{
int id = (int)dgvCongViec.SelectedRows[0].Cells["ID"].Value;
CongViec ans = ModelContext.CongViecs.Where(p => p.ID == id).FirstOrDefault();
return(ans);
}
catch
{
return(new CongViec());
}
}
public CongViec_User_ViewModel(CongViec obj)
{
MaHieuCV_User = obj.MaHieuCV_User;
MaHM = obj.MaHM;
MaHieuCV_DM = obj.MaHieuCV_DM;
TenCongViec = obj.TenCongViec;
DonVi = obj.DonVi;
KhoiLuong = obj.KhoiLuong;
GiaVL = obj.GiaVL;
GiaNC = obj.GiaNC;
GiaMTC = obj.GiaMTC;
ThanhTien = obj.ThanhTien;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//Update
CongViec cv = new CongViec();
cv.CongViecId = int.Parse(txtCVId.Text);
cv.TenCV = txtTenCV.Text;
//
new CongViecModel().Update(cv);
MessageBox.Show("Thành Công");
// grcCongViec.RefreshDataSource();
CongViecForm_Load(sender, e);
}
private void CheckBoxCongViec_Check(object sender, RoutedEventArgs e)
{
CheckBox chkBox = sender as CheckBox;
CongViecView cvv = (CongViecView)chkBox.DataContext;
using (QuanLyDuLieu db = new QuanLyDuLieu())
{
CongViec cvThayDoi = db.CongViec.ToList().Single(m => m.CongViecID == cvv.CongViecID);
cvThayDoi.PhanLoaiCongViec = chkBox.IsChecked == null ? cvThayDoi.PhanLoaiCongViec : ((bool)chkBox.IsChecked ? "DaHoanThanh" : "DangThucHien");
db.SaveChanges();
}
LoadCongViec();
}
// DELETE: odata/CongViecs(5)
public IHttpActionResult Delete([FromODataUri] int key)
{
CongViec congViec = db.CongViecs.Find(key);
if (congViec == null)
{
return(NotFound());
}
db.CongViecs.Remove(congViec);
db.SaveChanges();
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: CongViecs/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CongViec congViec = db.CongViecs.Find(id);
if (congViec == null)
{
return(HttpNotFound());
}
return(View(congViec));
}
public async Task <CongViec> Insert(CongViec congviec)
{
return(await WithConnection(async c =>
{
await c.InsertAsync(congviec);
if (congviec.CongViecId == 0)
{
throw new Exception("Insert Fail");
}
return congviec;
}));
}
public string addNewCV(CongViec nv, bool isNewNCV)
{
DBKetNoi.initializeInstance();
DBKetNoi dbmg = DBKetNoi.getInstance();
SqlConnection con = dbmg.openDatabase();
string newCongViec = "INSERT CONGVIEC (MaCV, MaCa, MoTaCV, XulyCV, DeXuat, GhiChu)"
+ " VALUES (@maCV, @maCa, @motaCV, @xuLyCV, @deXuat, @ghiChu)";
string updateCongViec = "UPDATE CONGVIEC SET MaCV = @maCV, MaCa = @maCa, MoTaCV = @motaCV, XulyCV = @xuLyCV "
+ ", DeXuat = @deXuat, GhiChu = @ghiChu WHERE MaCV = @maCV";
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
if (isNewNCV)
{
cmd.CommandText = newCongViec;
}
else
{
cmd.CommandText = updateCongViec;
}
cmd.Parameters.AddWithValue("@maCV", nv.maCV);
cmd.Parameters.AddWithValue("@maCa", nv.maCa);
cmd.Parameters.AddWithValue("@motaCV", nv.moTaCV);
cmd.Parameters.AddWithValue("@xuLyCV", nv.xuLyCV);
cmd.Parameters.AddWithValue("@deXuat", nv.deXuat);
cmd.Parameters.AddWithValue("@ghiChu", nv.ghiChu);
string ret = "";
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Debug.WriteLine("The product name is " + e.Message);
ret = e.Message;
}
dbmg.closeDatabase();
return(ret);
}
