public static List <ENTVWPRJPROJECTMYTASKS> GetAllListProjects(Guid USERID)//Görevlerim alanı icin listeleme { con = SQL.GetConnection(); cmd = SQL.SetCommand("SELECT * FROM VW_PRJ_ProjectMyTasks WHERE USERID=@USERID ORDER BY PROJECTTASKCREATEDATE ", con); cmd.Parameters.AddWithValue("@USERID", USERID); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ENTVWPRJPROJECTMYTASKS tasks = null; DateTime?dueDate = null; List <ENTVWPRJPROJECTMYTASKS> taskslist = new List <ENTVWPRJPROJECTMYTASKS>(); while (dr.Read()) { dueDate = null; if (!string.IsNullOrEmpty(dr["PROJECTTASKDUEDATE"].ToString())) { dueDate = Convert.ToDateTime(dr["PROJECTTASKDUEDATE"].ToString()); } tasks = new ENTVWPRJPROJECTMYTASKS(Guid.Parse(dr["PROJECTTASKRESOURSEID"].ToString()), Guid.Parse(dr["USERID"].ToString()), dr["USERFULLNAME"].ToString(), Guid.Parse(dr["FIRMID"].ToString()), dr["FIRMNAME"].ToString(), Guid.Parse(dr["PROJECTID"].ToString()), dr["PROJECTNAME"].ToString(), byte.Parse(dr["TYPEPROJECTSTATUSID"].ToString()), dr["TYPEPROJECTSTATUSNAME"].ToString(), Guid.Parse(dr["PROJECTTASKID"].ToString()), dr["PROJECTTASKNAME"].ToString(), Convert.ToDateTime(dr["PROJECTTASKCREATEDATE"]), dueDate, byte.Parse(dr["TYPEPROJECTTASKSTATUSID"].ToString()), dr["TYPEPROJECTTASKSTATUSNAME"].ToString(), bool.Parse(dr["TYPEPROJECTTASKSTATUSISOPEN"].ToString())); taskslist.Add(tasks); } con.Close(); return(taskslist); }
public static ENTVWPRJPROJECTMYTASKS GetActivity(Guid PROJECTTASKRESOURSEID) { con = SQL.GetConnection(); cmd = SQL.SetCommand("SELECT * FROM VW_PRJ_ProjectMyTasks WHERE PROJECTTASKRESOURSEID=@PROJECTTASKRESOURSEID", con); cmd.Parameters.AddWithValue("@PROJECTTASKRESOURSEID", PROJECTTASKRESOURSEID); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ENTVWPRJPROJECTMYTASKS act = null; DateTime?dueDate = null; while (dr.Read()) { dueDate = null; if (!string.IsNullOrEmpty(dr["PROJECTTASKDUEDATE"].ToString())) { dueDate = Convert.ToDateTime(dr["PROJECTTASKDUEDATE"].ToString()); } act = new ENTVWPRJPROJECTMYTASKS(Guid.Parse(dr["PROJECTTASKRESOURSEID"].ToString()), Guid.Parse(dr["USERID"].ToString()), dr["USERFULLNAME"].ToString(), Guid.Parse(dr["FIRMID"].ToString()), dr["FIRMNAME"].ToString(), Guid.Parse(dr["PROJECTID"].ToString()), dr["PROJECTNAME"].ToString(), byte.Parse(dr["TYPEPROJECTSTATUSID"].ToString()), dr["TYPEPROJECTSTATUSNAME"].ToString(), Guid.Parse(dr["PROJECTTASKID"].ToString()), dr["PROJECTTASKNAME"].ToString(), Convert.ToDateTime(dr["PROJECTTASKCREATEDATE"]), dueDate, byte.Parse(dr["TYPEPROJECTTASKSTATUSID"].ToString()), dr["TYPEPROJECTTASKSTATUSNAME"].ToString(), bool.Parse(dr["TYPEPROJECTTASKSTATUSISOPEN"].ToString())); } con.Close(); return(act); }