internal List <CongViecNvDTO> GetAllCongViecPublic() { //Ignore nhầm file này trong cái commit cũ nên thiếu mất method này List <CongViecNvDTO> list = new List <CongViecNvDTO>(); string connectionString = DataAccess.Internal.DataAccess.GetConnectionString("TodoListDb"); using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); // Set up a command with the given query and associate // this with the current connection. string query = @"select * from CongViec where IsPublic=1"; using (SqlCommand cmd = new SqlCommand(query, con)) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { CongViecNvDTO cv = new CongViecNvDTO(); cv.Id = Convert.ToInt32(dr["Id"].ToString()); cv.NgayBatDau = dr["StartDate"].ToString(); cv.NgayKetThuc = dr["EndDate"].ToString(); cv.PhamVi = Convert.ToBoolean(dr["IsPublic"]); cv.IdPartner = dr["PartnerNhanVien"].ToString(); cv.Status = Convert.ToInt32(dr["Status"]); cv.TenCongViec = dr["NameCongViec"].ToString(); //cv.BinhLuan = dr[6].ToString(); cv.FileDinhKem = dr["Files"].ToString(); cv.IsVisible = Convert.ToBoolean(dr["IsVisible"]); list.Add(cv); } } } } return(list); }
internal List <CongViecNvDTO> GetAllCongViecNv(string idNhanVien) { List <CongViecNvDTO> list = new List <CongViecNvDTO>(); string connectionString = DataAccess.Internal.DataAccess.GetConnectionString("TodoListDb"); using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); // Set up a command with the given query and associate // this with the current connection. string query = @"select cv.id,cv.NameCongViec,cv.StartDate,cv.EndDate,cv.isPublic,cv.Files,cv.Status,pc.comment from CongViec cv , NhanVien nv , PhanCong pc where nv.id = pc.idnhanvien and cv.id = pc.idcongviec and nv.id = " + idNhanVien; using (SqlCommand cmd = new SqlCommand(query, con)) { using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { CongViecNvDTO cv = new CongViecNvDTO(); cv.Id = Convert.ToInt32(dr["id"].ToString()); cv.NgayBatDau = dr["StartDate"].ToString(); cv.NgayKetThuc = dr["EndDate"].ToString(); cv.PhamVi = Convert.ToBoolean(dr["IsPublic"]); cv.Status = Convert.ToInt32(dr["Status"]); cv.TenCongViec = dr["NameCongViec"].ToString(); cv.BinhLuan = dr["comment"].ToString(); cv.FileDinhKem = dr["Files"].ToString(); list.Add(cv); } } } } return(list); }