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