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