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