public static List <ENTVWPRJPROJECTTASK> GetAllListProjectsTasks(Guid PROJECTID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM VW_PRJ_ProjectTask WHERE PROJECTID=@PROJECTID ORDER BY CREATEDATE DESC", con);
cmd.Parameters.AddWithValue("@PROJECTID", PROJECTID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTVWPRJPROJECTTASK ptsk = null;
DateTime? dueDate = null;
List <ENTVWPRJPROJECTTASK> ptsklist = new List <ENTVWPRJPROJECTTASK>();
while (dr.Read())
{
dueDate = null;
if (!string.IsNullOrEmpty(dr["DUEDATE"].ToString()))
{
dueDate = Convert.ToDateTime(dr["DUEDATE"].ToString());
}
ptsk = new ENTVWPRJPROJECTTASK(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["PROJECTID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Byte.Parse(dr["TYPEPROJECTTASKSTATUSID"].ToString()), Convert.ToDateTime(dr["CREATEDATE"].ToString()), dueDate, dr["TYPEPROJECTTASKSTATUSNAME"].ToString(), bool.Parse(dr["TYPEPROJECTTASKSTATUSISOPEN"].ToString()), dr["PROJECTNAME"].ToString());//ısopen ekledim kontrol et
ptsklist.Add(ptsk);
}
con.Close();
return(ptsklist);
}
public static ENTVWPRJPROJECTTASK GetValueTask(Guid ID)//Id getiriyorum detaildaki labellara yazdırmak için
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM VW_PRJ_ProjectTask WHERE ID=@ID", con);
cmd.Parameters.AddWithValue("@ID", ID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTVWPRJPROJECTTASK ptsk = null;
DateTime? dueDate = null;
Guid PROJECTID;
while (dr.Read())
{
dueDate = null;
if (!string.IsNullOrEmpty(dr["DUEDATE"].ToString()))
{
dueDate = Convert.ToDateTime(dr["DUEDATE"].ToString());
}
PROJECTID = Guid.Parse(dr["PROJECTID"].ToString());
ptsk = new ENTVWPRJPROJECTTASK(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["PROJECTID"].ToString()), dr["NAME"].ToString(), dr["DESCRIPTION"].ToString(), Byte.Parse(dr["TYPEPROJECTTASKSTATUSID"].ToString()), Convert.ToDateTime(dr["CREATEDATE"].ToString()), dueDate, dr["TYPEPROJECTTASKSTATUSNAME"].ToString(), Convert.ToBoolean(dr["TYPEPROJECTTASKSTATUSISOPEN"].ToString()), dr["PROJECTNAME"].ToString());
break;
}
con.Close();
return(ptsk);
}