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