public int Update(Task updatedTask) { conn.Open(); string query = "update Task set Name = '" + updatedTask.Name + "', Description='" + updatedTask.Description + "', MinEstDuration='" + updatedTask.MinDuration + "', MaxEstDuration='" + updatedTask.MaxDuration + "', MostLikelyeEstDuration='" + updatedTask.MostLikelyDuration + "', EndDate='" + updatedTask.CompletedDate + "', ModifiedDate='" + updatedTask.ModifiedDate + "', StatusId='" + updatedTask.Status + "', UserId='" + updatedTask.Owner.Id + "', ProjectId='" + updatedTask.Project.Id + "' Where TaskId=" + updatedTask.Id; SqlCommand cmd = new SqlCommand(query, conn); int effectedIds = cmd.ExecuteNonQuery(); conn.Close(); return(effectedIds); }
public int Insert(Task newTask) { conn.Open(); string query = "insert into Task(Name, Description, MinEstDuration, MaxEstDuration, MostLikelyeEstDuration, StartDate, EndDate, ModifiedDate, StatusId, UserId, ProjectId) values('" + newTask.Name + "', '" + newTask.Description + "', '" + newTask.MinDuration + "', '" + newTask.MaxDuration + "', '" + newTask.MostLikelyDuration + "', '" + newTask.StartedDate + "', '" + newTask.CompletedDate + "', '" + newTask.ModifiedDate + "', '" + newTask.Status + "', '" + newTask.Owner.Id + "', '" + newTask.Project.Id + "')'"; SqlCommand cmd = new SqlCommand(query, conn); int effectedIds = cmd.ExecuteNonQuery(); conn.Close(); return(effectedIds); }