public void insertEmployee(int ID, string firstName, string lastName, string department, DateTime hireDate) { Employee e = new Employee(); e.ID = ID; e.FirstName = firstName; e.LastName = lastName; e.Department = department; e.HireDate = hireDate; _context.Employees.Add(e); _context.SaveChanges(); }
private void SaveManualTracker() { using (var context = new Models.TimeTrackerDBContext()) { var tracker = new Models.TimeTracking(); tracker.CreateDate = DateTime.Now; tracker.Date = ManualDate.Value.Value; var project = context.Projects.Where(o => o.ProjectName == this.ManualProjectCombo.SelectedItem.ToString()).FirstOrDefault(); tracker.ProjectID = project.ID; tracker.HourCount = Convert.ToDouble(HoursNumeric.Value); tracker.MinutesCount = Convert.ToDouble(MinutesNumeric.Value); tracker.UserID = Tools.CurrentUser.ID; tracker.Description = this.ManualDescTxt.Text; context.TimeTrackings.Add(tracker); context.SaveChanges(); MessageBox.Show("Tracker is saved."); makefieldsEmptyInManual(); } }
private void SaveAutoTracker() { using (var context = new Models.TimeTrackerDBContext()) { TimeSpan elapsed = (DateTime.Now - StartTime) - PausedElapsedTime; var tracker = new Models.TimeTracking(); tracker.CreateDate = DateTime.Now; tracker.Date = DateTime.Now.Date; var project = context.Projects.Where(o => o.ProjectName == this.ProjectComboBox.SelectedItem.ToString()).FirstOrDefault(); tracker.ProjectID = project.ID; tracker.HourCount = elapsed.Hours; tracker.MinutesCount = elapsed.Minutes; tracker.UserID = Tools.CurrentUser.ID; tracker.Description = this.DescriptionTxtBox.Text; context.TimeTrackings.Add(tracker); context.SaveChanges(); MessageBox.Show("Tracker is saved."); makefieldsEmptyInAuto(); } }