/// <summary>
/// Checks whether the included job titles are already in the user listing at Loconomics
/// (AKA UseJobTitles, UserProfilePositions), adding them when not.
/// That way, we ensure that any job title added into an external listing, is available
/// in the regular listing at Loconomics account.
/// This MUST be run whenever an external listing is being stored.
/// </summary>
/// <param name="userID"></param>
/// <param name="jobTitles"></param>
void AutoRegisterUserJobTitles()
{
foreach (var jobTitleID in jobTitles.Keys)
{
if (!UserJobTitle.HasItem(userID, jobTitleID))
{
UserJobTitle.Create(new UserJobTitle
{
userID = userID,
jobTitleID = jobTitleID
});
}
}
}
public static int Set(UserEarningsEntry entry, LcDatabase sharedDb = null)
{
using (var db = new LcDatabase(sharedDb))
{
db.Query("BEGIN TRANSACTION");
// There is only one case where job title is already added to listing and external listing
// and will switch next flag, otherwise we need to double check.
var skipJobTitleCheck = false;
// On no listingID, create one for the given platform..
if (entry.userExternalListingID <= 0 && entry.platformID > 0)
{
// If exists one..
var byPlatform = UserExternalListing.GetByPlatformID(entry.userID, entry.platformID).FirstOrDefault();
if (byPlatform != null)
{
// ..use it
entry.userExternalListingID = byPlatform.userExternalListingID;
}
else
{
// ..otherwise, create a new one with all data we can know for it
var newForPlatform = new UserExternalListing
{
userID = entry.userID,
platformID = entry.platformID,
title = String.Format("My {0} listing", Platform.GetItem(entry.platformID).name),
notes = ""
};
var locale = Locale.Current;
newForPlatform.FillJobTitlesWithIds(new int[] { entry.jobTitleID }, locale.languageID, locale.countryID);
// insert and get the ID
entry.userExternalListingID = UserExternalListing.Insert(newForPlatform);
// this inserts the job title in the user Loconomics listing too if not exists
skipJobTitleCheck = true;
}
}
// ..or throw if no one of boths values is included
else if (entry.userExternalListingID <= 0 && entry.platformID <= 0)
{
throw new ConstraintException("A listing or platform must be specified for the earnings entry");
}
// ..otherwise, it will just use the given listingID
// Selected job title could have being selected from an existent listing, but not exists on the external listing selected
// or was selected as another job title from an autocomplete, then no in this external listing and no in the user listing
// we need to add it if is not, on each place,
// except we well know exists and skip this step, using the flag
if (!skipJobTitleCheck)
{
// Check if job title exist at user listing
if (!UserJobTitle.HasItem(entry.userID, entry.jobTitleID))
{
// then create a new one, with mostly default options
UserJobTitle.Create(new UserJobTitle
{
userID = entry.userID,
jobTitleID = entry.jobTitleID
});
}
// Get external listing
var externalListing = UserExternalListing.Get(entry.userID, entry.userExternalListingID);
if (externalListing == null)
{
throw new ConstraintException("The listing specified does not exists");
}
// Check if job title exist at the external listing
if (!externalListing.jobTitles.ContainsKey(entry.jobTitleID))
{
// then add it
var jobTitleIds = externalListing.jobTitles.Keys.ToList();
jobTitleIds.Add(entry.jobTitleID);
var locale = Locale.Current;
externalListing.FillJobTitlesWithIds(jobTitleIds, locale.languageID, locale.countryID);
// and save it
UserExternalListing.Update(externalListing);
}
}
var resultID = (int)db.QueryValue(sqlSet,
entry.userID,
entry.earningsEntryID,
entry.paidDate,
entry.durationMinutes,
entry.userExternalListingID,
entry.jobTitleID,
entry.clientUserID,
entry.notes,
entry.amount
);
db.Query("COMMIT TRANSACTION");
return(resultID);
}
}