// custom method to insert a new DupesAction row using the stored procedure spDupesAction_ins
public void DupesAction_ins(DupesAction dupesAction)
{
var theFileName = new SqlParameter("@TheFileName", dupesAction.TheFileName);
var duplicateOf = new SqlParameter("@DuplicateOf", dupesAction.DuplicateOf);
var sHA = new SqlParameter("@SHA", dupesAction.SHA);
var fileExt = new SqlParameter("@FileExt", dupesAction.FileExt);
var fileSize = new SqlParameter("@FileSize", dupesAction.FileSize);
var fileCreateDt = new SqlParameter("@FileCreateDt", dupesAction.FileCreateDt);
var oneDriveRemoved = new SqlParameter("@OneDriveRemoved", dupesAction.OneDriveRemoved);
var googlePhotosRemoved = new SqlParameter("@googlePhotosRemoved", dupesAction.GooglePhotosRemoved);
this.Database.ExecuteSqlCommand("exec spDupesAction_ins @TheFileName, @DuplicateOf, @SHA, @FileExt, @FileSize, @FileCreateDt, @OneDriveRemoved, @googlePhotosRemoved",
theFileName, duplicateOf, sHA, fileExt, fileSize, fileCreateDt, oneDriveRemoved, googlePhotosRemoved);
}
// write new row into the DupesAction table
private void DupesAction_Insert(CheckSum photo)
{
// create a new DupesAction row
DupesAction dupesAction = new DupesAction();
dupesAction.TheFileName = photo.TheFileName;
dupesAction.Folder = photo.Folder;
dupesAction.SHA = photo.SHA;
dupesAction.FileExt = photo.FileExt;
dupesAction.FileSize = photo.FileSize;
dupesAction.FileCreateDt = photo.FileCreateDt;
dupesAction.OneDriveRemoved = "Y";
dupesAction.GooglePhotosRemoved = "N";
// call the custom stored procedure method in DbContext popsModel
Program.popsModel.DupesAction_ins(dupesAction);
}
