public bool AddAttempt(SettlementAttempt attempt)
{
// 1. create attempt in QuickBase ("Id" SQL PK should already be populated)
// 2. update the "RecordId" property/PK of attempt upon insertion
// 3. return if operation is successful
// auto-generated value from QB record insert
attempt.RecordId = 9999;
Console.WriteLine($"Adding attempt ID {attempt.RecordId} to Quickbase with SQL ID {attempt.Id}");
return(true);
}
public bool AddAttempt(SettlementAttempt attempt)
{
// 1. create attempt in SQL using entity framework
// 2. update the "Id" property/PK of attempt upon insertion
// 3. return if operation is successful
// auto-generated value from PK insert
attempt.Id = 12376;
Console.WriteLine($"Adding attempt ID {attempt.Id} to SQL");
return(true);
}
private static void Main(string[] args)
{
// build container
var container = CreateContainer();
// get instance via structuremap, as is typical
var settlementAttemptDataAccess = container.GetInstance <ISettlementAttemptDataAccess>();
#region Add attempt
var newAttempt = new SettlementAttempt
{
ClientFirstName = "Ryan",
ClientLastName = "Peters",
CreatedBy = "rpeters"
};
settlementAttemptDataAccess.AddAttempt(newAttempt);
// in most cases, the QuickBase DAL will update "RecordId" and
// the EF DAL will update "Id"
Console.WriteLine($"Attempt ID (SQL) => {newAttempt.Id}");
Console.WriteLine($"Attempt ID (QuickBase) => {newAttempt.RecordId}");
#endregion
#region Get attempt
var attempt = settlementAttemptDataAccess.GetAttempt(1234);
// dump the attempt
Console.WriteLine($"{nameof(attempt.Id)} => {attempt.Id}");
Console.WriteLine($"{nameof(attempt.RecordId)} => {attempt.RecordId}");
Console.WriteLine($"{nameof(attempt.ClientFirstName)} => {attempt.ClientFirstName}");
Console.WriteLine($"{nameof(attempt.ClientLastName)} => {attempt.ClientLastName}");
Console.WriteLine($"{nameof(attempt.Created)} => {attempt.Created}");
Console.WriteLine($"{nameof(attempt.CreatedBy)} => {attempt.CreatedBy}");
#endregion
// pause
Console.ReadLine();
}
public bool AddAttempt(SettlementAttempt attempt) => Invoke(d => d.AddAttempt(attempt));
