public void Sync(IEnumerable <TimeRecordBase> records, Category category) { foreach (var record in records) { var newSlot = new Xrm.New_TimeSlot(); var ord = _context.SalesOrderSet.FirstOrDefault(x => x.Name == record.Order); var cas = string.IsNullOrWhiteSpace(record.Case) ? null : _context.IncidentSet.FirstOrDefault(x => x.TicketNumber == record.Case); newSlot.SalesOrder_New_TimeSlots = ord; newSlot.new_incident_new_timeslot_Case = cas; newSlot.New_name = record.ItemTitle; newSlot.New_Category = category.Id; newSlot.New_StartTime = record.StartTime; newSlot.New_EndTime = record.EndTime; newSlot.New_Hours = record.Duration.TotalHours; newSlot.fso_TimeSpent = (int)Math.Floor(record.Duration.TotalMinutes); _context.AddObject(newSlot); } _context.SaveChanges(); }
public void Sync(IEnumerable<TimeRecordBase> records, Category category) { foreach(var record in records) { var newSlot = new Xrm.New_TimeSlot(); var ord = _context.SalesOrderSet.FirstOrDefault(x => x.Name == record.Order); var cas = string.IsNullOrWhiteSpace(record.Case) ? null : _context.IncidentSet.FirstOrDefault(x => x.TicketNumber == record.Case); newSlot.SalesOrder_New_TimeSlots = ord; newSlot.new_incident_new_timeslot_Case = cas; newSlot.New_name = record.ItemTitle; newSlot.New_Category = category.Id; newSlot.New_StartTime = record.StartTime; newSlot.New_EndTime = record.EndTime; newSlot.New_Hours = record.Duration.TotalHours; newSlot.fso_TimeSpent = (int)Math.Floor(record.Duration.TotalMinutes); _context.AddObject(newSlot); } _context.SaveChanges(); }