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