public static List <ENTVWPRJPROJECTTASKRESOURSEACTIVITY> GetAllListTaskActivity(Guid PROJECTTASKRESOURSEID) { con = SQL.GetConnection(); cmd = SQL.SetCommand("SELECT * FROM VW_PRJ_ProjectTaskUserActivity WHERE PROJECTTASKRESOURSEID=@PROJECTTASKRESOURSEID", con); cmd.Parameters.AddWithValue("@PROJECTTASKRESOURSEID", PROJECTTASKRESOURSEID); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ENTVWPRJPROJECTTASKRESOURSEACTIVITY activity = null; byte?resourseduration = null; List <ENTVWPRJPROJECTTASKRESOURSEACTIVITY> activitylist = new List <ENTVWPRJPROJECTTASKRESOURSEACTIVITY>(); while (dr.Read()) { resourseduration = null; if (!string.IsNullOrEmpty(dr["RESOURSEDURATION"].ToString())) { resourseduration = Convert.ToByte(dr["RESOURSEDURATION"].ToString()); } activity = new ENTVWPRJPROJECTTASKRESOURSEACTIVITY(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["USERID"].ToString()), resourseduration, dr["DESCRIPTION"].ToString(), Convert.ToDateTime(dr["DATE"].ToString()), Guid.Parse(dr["PROJECTTASKRESOURSEID"].ToString()), Guid.Parse(dr["PROJECTTASKID"].ToString()), dr["PROJECTTASKNAME"].ToString(), Guid.Parse(dr["PROJECTID"].ToString()), dr["PROJECTNAME"].ToString()); activitylist.Add(activity); } con.Close(); return(activitylist); }
public static ENTVWPRJPROJECTTASKRESOURSEACTIVITY GetValueTaskResourseActivity(Guid ID)//Aktivite güncellemek için verileri getirme { con = SQL.GetConnection(); cmd = SQL.SetCommand("SELECT * FROM VW_PRJ_ProjectTaskUserActivity WHERE ID=@ID", con); cmd.Parameters.AddWithValue("@ID", ID); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ENTVWPRJPROJECTTASKRESOURSEACTIVITY activity = null; byte?resourseduration = null; while (dr.Read()) { if (!string.IsNullOrEmpty(dr["RESOURSEDURATION"].ToString())) { resourseduration = Convert.ToByte(dr["RESOURSEDURATION"].ToString()); } activity = new ENTVWPRJPROJECTTASKRESOURSEACTIVITY(Guid.Parse(dr["ID"].ToString()), Guid.Parse(dr["USERID"].ToString()), resourseduration, dr["DESCRIPTION"].ToString(), Convert.ToDateTime(dr["DATE"].ToString()), Guid.Parse(dr["PROJECTTASKRESOURSEID"].ToString()), Guid.Parse(dr["PROJECTTASKID"].ToString()), dr["PROJECTTASKNAME"].ToString(), Guid.Parse(dr["PROJECTID"].ToString()), dr["PROJECTNAME"].ToString()); break; } con.Close(); return(activity); }