public static List <ENTPRJPROJECTTASK> GetAllListTaskID(Guid PROJECTID)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("SELECT * FROM PRJ_PROJECTTASK WHERE PROJECTID=@PROJECTID", con);
cmd.Parameters.AddWithValue("@PROJECTID", PROJECTID);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ENTPRJPROJECTTASK ptsk = null;
DateTime? dueDate = null;
List <ENTPRJPROJECTTASK> ptsklist = new List <ENTPRJPROJECTTASK>();
while (dr.Read())
{
dueDate = null;
if (!string.IsNullOrEmpty(dr["DUEDATE"].ToString()))
{
dueDate = Convert.ToDateTime(dr["DUEDATE"].ToString());
}
ptsk = new ENTPRJPROJECTTASK(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);
ptsklist.Add(ptsk);
}
con.Close();
return(ptsklist);
}
public static ENTPRJPROJECTTASK GetTask(Guid ID)//Id getiriyorum update icin
{
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();
ENTPRJPROJECTTASK 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 ENTPRJPROJECTTASK(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);
break;
}
con.Close();
return(ptsk);
}
public static void InsertTable(ENTPRJPROJECTTASK ptsk)
{
try
{
con = SQL.GetConnection();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sql = string.Empty;
if (ptsk.DUEDATE.HasValue)
{
sql = "INSERT INTO PRJ_PROJECTTASK (ID,PROJECTID,NAME,DESCRIPTION,TYPEPROJECTTASKSTATUSID ,CREATEDATE,DUEDATE) VALUES (@ID,@PROJECTID,@NAME,@DESCRIPTION,@TYPEPROJECTTASKSTATUSID ,@CREATEDATE,@DUEDATE)";
}
else
{
sql = "INSERT INTO PRJ_PROJECTTASK (ID,PROJECTID,NAME,DESCRIPTION,TYPEPROJECTTASKSTATUSID,CREATEDATE) VALUES (@ID,@PROJECTID,@NAME,@DESCRIPTION,@TYPEPROJECTTASKSTATUSID,@CREATEDATE)";
}
cmd = SQL.SetCommand(sql, con);
cmd.Parameters.AddWithValue("@ID", ptsk.ID);
cmd.Parameters.AddWithValue("@PROJECTID", ptsk.PROJECTID);
cmd.Parameters.AddWithValue("@NAME", ptsk.NAME);
cmd.Parameters.AddWithValue("@DESCRIPTION", ptsk.DESCRIPTION);
cmd.Parameters.AddWithValue("@TYPEPROJECTTASKSTATUSID", ptsk.TYPEPROJECTTASKSTATUSID);
cmd.Parameters.AddWithValue("@CREATEDATE", ptsk.CREATEDATE);
if (ptsk.DUEDATE.HasValue)
{
cmd.Parameters.AddWithValue("@DUEDATE", ptsk.DUEDATE);
}
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public static void Update(ENTPRJPROJECTTASK ptsk)
{
con = SQL.GetConnection();
cmd = SQL.SetCommand("UPDATE PRJ_PROJECTTASK SET NAME = @NAME,TYPEPROJECTTASKSTATUSID=@TYPEPROJECTTASKSTATUSID,CREATEDATE=@CREATEDATE, DUEDATE=@DUEDATE, DESCRIPTION=@DESCRIPTION WHERE ID = @ID", con);
cmd.Parameters.AddWithValue("@ID", ptsk.ID);
cmd.Parameters.AddWithValue("@NAME", ptsk.NAME);
cmd.Parameters.AddWithValue("@TYPEPROJECTTASKSTATUSID", ptsk.TYPEPROJECTTASKSTATUSID);
cmd.Parameters.AddWithValue("@CREATEDATE", ptsk.CREATEDATE);
if (String.IsNullOrEmpty(ptsk.DUEDATE.ToString()))
{
cmd.Parameters.AddWithValue("@DUEDATE", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DUEDATE", ptsk.DUEDATE);
}
cmd.Parameters.AddWithValue("@DESCRIPTION", ptsk.DESCRIPTION);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
