예제 #1
0
        // Görev ekler.
        public void AddTask(int projectID, int taskStatuID, string projectName, string technicalExpert, int predictTime, int actualTime,
                            string workDetail, string nots, List <Work> workList)
        {
            SqlConnection connection = database.OpenConnection();
            SqlCommand    sqlCommand;

            sqlCommand = database.CreateConnection("INSERT INTO dbo.Task (ProjeID, TaskStatuID, ProjeAdi,TeknikUzman,Tarih,TahminiSure,GerceklesenSure, IsAciklamasi,Notlar) " +
                                                   "VALUES (@projectID, @taskStatuID, @projectName, @technicalExpert, GETDATE(), @predictTime, @actualTime, @workDetail, @nots)");

            sqlCommand.Parameters.AddWithValue("@projectID", projectID);
            sqlCommand.Parameters.AddWithValue("@taskStatuID", taskStatuID);
            sqlCommand.Parameters.AddWithValue("@projectName", projectName);
            sqlCommand.Parameters.AddWithValue("@technicalExpert", technicalExpert);
            sqlCommand.Parameters.AddWithValue("@predictTime", predictTime);
            sqlCommand.Parameters.AddWithValue("@actualTime", actualTime);
            sqlCommand.Parameters.AddWithValue("@workDetail", workDetail);
            sqlCommand.Parameters.AddWithValue("@nots", nots);

            sqlCommand.ExecuteNonQuery();

            connection.Close();

            WorkBLL workBll = new WorkBLL();

            workBll.AddWork(GetLastAddedTaskID(), projectID, workList);
        }
예제 #2
0
        // Projedeki tüm görevleri siler.
        public void DeleteTasks(int projectID)
        {
            WorkBLL workBll = new WorkBLL();

            workBll.DeleteWorks(projectID);

            SqlConnection connection = database.OpenConnection();
            SqlCommand    sqlCommand = database.CreateConnection("DELETE FROM dbo.Task WHERE ProjeID=@projectID;");

            sqlCommand.Parameters.AddWithValue("@projectID", projectID);
            sqlCommand.ExecuteNonQuery();

            connection.Close();
        }
예제 #3
0
        // Görev durumuna göre görevleri siler.
        public void DeleteTaskForTaskStatu(int taskStatuID)
        {
            List <Task> taskStatusTasks = GetTaskStatusTasks(taskStatuID);

            foreach (var task in taskStatusTasks)
            {
                WorkBLL workBll = new WorkBLL();
                workBll.DeleteWork(task.TaskID);
            }

            SqlConnection connection = database.OpenConnection();
            SqlCommand    sqlCommand = database.CreateConnection("DELETE FROM dbo.Task WHERE TaskStatuID=@taskStatuID;");

            sqlCommand.Parameters.AddWithValue("@taskStatuID", taskStatuID);
            sqlCommand.ExecuteNonQuery();

            connection.Close();
        }
예제 #4
0
        // Görev günceller.
        public void UpdateTask(int taskID, int projectID, string technicalExpert, DateTime date, int predictTime, int actualTime, string workDetail, string nots, List <Work> works)
        {
            SqlConnection connection = database.OpenConnection();
            SqlCommand    sqlCommand = database.CreateConnection("UPDATE dbo.Task SET TeknikUzman=@technicalExpert, Tarih=@date, " +
                                                                 "TahminiSure=@predictTime, GerceklesenSure=@actualTime, IsAciklamasi=@workDetail, Notlar=@nots WHERE TaskID=@taskID");

            sqlCommand.Parameters.AddWithValue("@taskID", taskID);
            sqlCommand.Parameters.AddWithValue("@technicalExpert", technicalExpert);
            sqlCommand.Parameters.AddWithValue("@date", date);
            sqlCommand.Parameters.AddWithValue("@predictTime", predictTime);
            sqlCommand.Parameters.AddWithValue("@actualTime", actualTime);
            sqlCommand.Parameters.AddWithValue("@workDetail", workDetail);
            sqlCommand.Parameters.AddWithValue("@nots", nots);

            sqlCommand.ExecuteNonQuery();

            connection.Close();

            WorkBLL workBll = new WorkBLL();

            workBll.UpdateWorks(taskID, projectID, works);
        }