public static bool Update(UserExternalListing externalListing)
{
externalListing.AutoRegisterUserJobTitles();
var sqlUpdate = @"
UPDATE UserExternalListing
SET title = @2,
jobTitles = @3,
notes = @4,
UpdatedDate = getdate()
WHERE
UserID = @0
AND UserExternalListingID = @1
AND Active = 1
";
using (var db = new LcDatabase())
{
var affected = db.Execute(sqlUpdate,
externalListing.userID,
externalListing.userExternalListingID,
externalListing.title,
Newtonsoft.Json.JsonConvert.SerializeObject(externalListing.jobTitles),
externalListing.notes
);
// Task done? Almost a record must be affected to be a success
return(affected > 0);
}
}
/// <summary>
///
/// </summary>
/// <param name="externalListing"></param>
/// <returns>Generated ID</returns>
public static int Insert(UserExternalListing externalListing)
{
externalListing.AutoRegisterUserJobTitles();
var sqlInsert = @"
INSERT INTO UserExternalListing (
UserID, PlatformID,
Title, JobTitles, Notes,
CreatedDate, UpdatedDate,
ModifiedBy, Active
) VALUES (
@0, @1,
@2, @3, @4,
getdate(), getdate(),
'sys', 1
)
SELECT @@Identity
";
using (var db = new LcDatabase())
{
return((int)db.QueryValue(sqlInsert,
externalListing.userID,
externalListing.platformID,
externalListing.title,
Newtonsoft.Json.JsonConvert.SerializeObject(externalListing.jobTitles),
externalListing.notes
));
}
}