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