Пример #1
0
 public void addTask(Task aTask)
 {
     using (SqlCommand cmd = DatabaseContext.Connection.CreateCommand())
     {
         cmd.CommandText = "INSERT INTO Task (ActivityNo, ProjectNo, EmployeeNo , StartPoint, EndPoint, Comment) VALUES (" + aTask.ActivityNo + ", " + aTask.ProjectNo + ", " + aTask.EmployeeNo + ", '" + aTask.StartPoint + "', '" + aTask.EndPoint + "', " + "'" + aTask.Comment + "'" + ");";
         cmd.ExecuteNonQuery();
     }
 }
Пример #2
0
 //public Task getTaskById(int id)
 //{
 //    return context.TaskRepository.getTaskById(id);
 //}
 //public List<Task> getAllTasks()
 //{
 //    return context.TaskRepository.getAllTasks();
 //}
 //public List<Task> getAllTaskByEmployeeNo(int employeeNo)
 //{
 //    return context.TaskRepository.getAllTaskByEmployeeNo(employeeNo);
 //}
 public void addTask(Task aTask)
 {
     context.TaskRepository.addTask(aTask);
 }
Пример #3
0
        private void taskAdd()
        {
            /*
            Task aTask = new Task
            {
                ProjectNo = Int32.Parse(cbProjectName.Text),
                EmployeeNo = Int32.Parse(cbEmployee.Text),
                TaskName = cbActivity.Text.ToString(),
                StartDate = dtpStartDate.Value,
                EndDate = dtpEndDate.Value,
                StartTime = new DateTime(0, 0, 0, Int32.Parse(cbStartTimeHour.SelectedText), Int32.Parse(cbStartTimeMinute.SelectedText), 0),
                EndTime = new DateTime(0, 0, 0, Int32.Parse(cbEndTimeHour.SelectedText), Int32.Parse(cbEndTimeMinute.SelectedText), 0),
                Comment = tbComment.Text.ToString()
            };*/

            Task aTask = new Task();
            DateTime aStartpoint = dtpStartDate.Value.Date + new TimeSpan(Int32.Parse(cbStartTimeHour.SelectedIndex.ToString()), Int32.Parse(cbStartTimeMinute.SelectedIndex.ToString()), 0);
            DateTime aEndPoint = dtpEndDate.Value.Date + new TimeSpan(Int32.Parse(cbEndTimeHour.SelectedIndex.ToString()), Int32.Parse(cbEndTimeMinute.SelectedIndex.ToString()), 0);

            aEndPoint.Add(new TimeSpan(Int32.Parse(cbEndTimeHour.Text), Int32.Parse(cbEndTimeMinute.Text), 0));

            //Funktioniert nicht, wenn im Projektnamen Nummern drinvorkommen

            // TODO: vielleicht besser überall Substring?
            aTask.ProjectNo = Int32.Parse(cbProject.Text.Substring(0, cbProject.Text.IndexOf(',')));
            aTask.EmployeeNo = Int32.Parse(Regex.Replace(cbEmployee.Text, @"\D", string.Empty));
            aTask.ActivityNo = Int32.Parse(cbActivity.Text.Substring(0, cbActivity.Text.IndexOf(',')));

            aTask.StartPoint = aStartpoint;
            aTask.EndPoint = aEndPoint;
            aTask.Comment = tbComment.Text.ToString();
            context.TaskService.addTask(aTask);
        }