public List <int> GetIDNGUOIDUNGinPHANCONG(int idcv, int idpc) { using (QLCVEntities e = new QLCVEntities()) { List <int> idnds = e.PHANCONGs.Where(a => a.IDCONGVIEC == idcv && a.IDPHANCONG == idpc).Select(a => a.NGUOIDUNG.ID).ToList(); return(idnds); } }
public List <CONGVIEC> GetCONGVIECs() { using (QLCVEntities e = new QLCVEntities()) { List <CONGVIEC> cvs = e.CONGVIECs.ToList(); return(cvs); } }
public CONGVIEC GetCONGVIEC(int id) { using (QLCVEntities e = new QLCVEntities()) { CONGVIEC cv = e.CONGVIECs.Include("PHANCONGs").Where(a => a.ID == id).FirstOrDefault(); return(cv); } }
public NGUOIDUNG GetNguoiDung(string username, string password) { using (QLCVEntities e = new QLCVEntities()) { var result = e.NGUOIDUNGs.Where(m => m.TENDANGNHAP == username && m.MATKHAU == password).FirstOrDefault(); return(result); } }
public List <PHANCONG> GetPhanCongTheoCongViec(int idCongViec) { using (QLCVEntities e = new QLCVEntities()) { var result = e.PHANCONGs.Where(a => a.IDCONGVIEC == idCongViec).ToList(); return(result); } }
public List <BAOCAOCONGVIEC> GetBAOCAO(int idcv, int idpc) { using (QLCVEntities e = new QLCVEntities()) { List <BAOCAOCONGVIEC> bcs = e.BAOCAOCONGVIECs.Include("NGUOIDUNG").Where(a => a.IDCONGVIEC == idcv && a.IDPHANCONG == idpc).ToList(); return(bcs); } }
public TRANGTHAI GetTrangThai(int id) { using (QLCVEntities e = new QLCVEntities()) { var result = e.TRANGTHAIs.Find(id); return(result); } }
public List <NGUOIDUNG> GetNGUOIDUNGs() { using (QLCVEntities e = new QLCVEntities()) { List <NGUOIDUNG> nds = e.NGUOIDUNGs.ToList(); return(nds); } }
public PHANCONG GetPHANCONG(int idcv, int idpc) { using (QLCVEntities e = new QLCVEntities()) { PHANCONG pc = e.PHANCONGs.Where(a => a.IDCONGVIEC == idcv && a.IDPHANCONG == idpc).FirstOrDefault(); return(pc); } }
public void InsertBAOCAO(BAOCAOCONGVIEC bc) { using (QLCVEntities e = new QLCVEntities()) { e.BAOCAOCONGVIECs.Add(bc); e.SaveChanges(); } }
public void UpdateTaskAfterInsert(int id, string thumuc) { using (QLCVEntities e = new QLCVEntities()) { CONGVIEC cv = e.CONGVIECs.Find(id); cv.THUMUC = thumuc; e.SaveChanges(); } }
public List <int> GetNGuoiDungTrongCongViec(int idCongViec) { using (QLCVEntities e = new QLCVEntities()) { var param = new SqlParameter("@idCongViec", idCongViec); var result = e.Database.SqlQuery <int>("select ID from NGUOIDUNG where ID in (select pc.IDNGUOINHAN from CONGVIEC cv, PHANCONG pc where cv.ID = @idCongViec and cv.ID = pc.IDCONGVIEC group by pc.IDNGUOINHAN)", param).ToList(); return(result); } }
public List <CONGVIEC> GetCongViecLienQuan(int idNguoiDung) { using (QLCVEntities e = new QLCVEntities()) { var param = new SqlParameter("@idNguoiDung", idNguoiDung); var result = e.CONGVIECs.SqlQuery("select DISTINCT cv.* from CONGVIEC cv, PHANCONG pc where cv.IDNGUOITAO = @idNguoiDung or pc.IDNGUOINHAN = @idNguoiDung and pc.IDCONGVIEC = cv.ID", param).ToList(); return(result); } }
public List <CONGVIEC> GetCongViecTheoPhanCong(int idNguoiDung, int trangthaiphancong) { using (QLCVEntities e = new QLCVEntities()) { var param = new SqlParameter("@idNguoiDung", idNguoiDung); var param1 = new SqlParameter("@trangthaiphancong", trangthaiphancong); var result = e.CONGVIECs.SqlQuery("select * from CONGVIEC where ID IN (select DISTINCT IDCONGVIEC from PHANCONG where IDTRANGTHAI = @trangthaiphancong and IDNGUOINHAN = @idNguoiDung)", param, param1).ToList(); return(result); } }
public int InsertTask(CONGVIEC cv) { using (QLCVEntities e = new QLCVEntities()) { e.CONGVIECs.Add(cv); e.SaveChanges(); int id = cv.ID; return(id); } }
public void UpdateTask(CONGVIEC cv1) { using (QLCVEntities e = new QLCVEntities()) { CONGVIEC cv2 = e.CONGVIECs.Find(cv1.ID); cv2.TIEUDE = cv1.TIEUDE; cv2.NOIDUNG = cv1.NOIDUNG; cv2.TAPTIN = cv1.TAPTIN; cv2.NGAYCAPNHAT = cv1.NGAYCAPNHAT; cv2.PHANCONGs.Clear(); cv2.PHANCONGs = cv1.PHANCONGs; e.SaveChanges(); } }
public Boolean CheckLogin(string username, string password) { using (QLCVEntities e = new QLCVEntities()) { if (e.NGUOIDUNGs.Where(a => a.TENDANGNHAP == username && a.MATKHAU == password && a.TRANGTHAI == true).ToList().Count == 1) { return(true); } else { return(false); } } }
public void UpdateTrangThaiCongViec(int idCongViec) { using (QLCVEntities e = new QLCVEntities()) { CONGVIEC cv = e.CONGVIECs.Find(idCongViec); if (cv.HOANTHANH == true) { cv.NGAYCAPNHAT = DateTime.Now; cv.HOANTHANH = false; } else { cv.NGAYCAPNHAT = DateTime.Now; cv.HOANTHANH = true; } e.SaveChanges(); } }
public void UpdateTrangThaiPhanCong(int idCongViec, int idPhanCong) { using (QLCVEntities e = new QLCVEntities()) { var result = e.PHANCONGs.Where(a => a.IDCONGVIEC == idCongViec && a.IDPHANCONG == idPhanCong).ToList(); result.ForEach(a => { if (a.IDTRANGTHAI == 5) { a.NGAYCAPNHAT = DateTime.Now; a.IDTRANGTHAI = 3; } else { a.NGAYCAPNHAT = DateTime.Now; a.IDTRANGTHAI = a.IDTRANGTHAI + 1; } }); //result.ForEach(a => a.IDTRANGTHAI = a.IDTRANGTHAI + 1); e.SaveChanges(); } }