public TicketFieldModel UpdateOrInsert(TicketFieldModel ticketField) { using (var model = new gb_ts_stagingEntities()) { var recordToEdit = model.TicketFields.FirstOrDefault(rec => rec.TicketId == ticketField.TicketId && rec.CustomFieldId == ticketField.CustomFieldId); if (recordToEdit != null) { recordToEdit.TicketId = ticketField.TicketId; recordToEdit.CustomFieldId = ticketField.CustomFieldId; recordToEdit.Value = ticketField.Value; recordToEdit.TextValue = ticketField.TextValue; } else { recordToEdit = new TicketField { Value = ticketField.Value, CustomFieldId = ticketField.CustomFieldId, TextValue = ticketField.TextValue, TicketId = ticketField.TicketId, }; model.TicketFields.Add(recordToEdit); } model.SaveChanges(); ticketField.Id = recordToEdit.Id; return(ticketField); } }
public TicketFieldModel Insert(TicketFieldModel ticketField) { using (var model = new gb_ts_stagingEntities()) { var newRecord = new TicketField { Value = ticketField.Value, CustomFieldId = ticketField.CustomFieldId, TextValue = ticketField.TextValue, TicketId = ticketField.TicketId, }; model.TicketFields.Add(newRecord); model.SaveChanges(); ticketField.Id = newRecord.Id; return(ticketField); } }