/// <summary> /// This method deletes a Vendor record /// <returns>The return value from the stored procedure.</returns> public int MarkMoved(DBOFactoryTransaction objTransaction) { LastUpdated = DateTime.Now; if (string.IsNullOrWhiteSpace(UpdatedBy)) { UpdatedBy = CurrentWindowsUser.Name; } FillCommandParamsDelegate objFillParamsMethod = new FillCommandParamsDelegate( delegate(SqlCommand objSQLCommand) { objSQLCommand.Parameters.AddWithValue($"@{Identity}", IdValue); objSQLCommand.Parameters.AddWithValue("@IsMoved", IsMoved); objSQLCommand.Parameters.AddWithValue("@NewFullPath", NewFullPath); objSQLCommand.Parameters.AddWithValue("@LastUpdated", LastUpdated); objSQLCommand.Parameters.AddWithValue("@UpdatedBy", UpdatedBy); } ); QueryController objQueryController = new QueryController(null, $"UPDATE {Table} SET IsMoved = @IsMoved, NewFullPath = @NewFullPath, LastUpdated = @LastUpdated, UpdatedBy = @UpdatedBy WHERE {Identity} = @{Identity}", objFillParamsMethod, null); int intReturnCode = PerformQuery(objQueryController, "GetByName", null); this.ResultDataSet = null; return(intReturnCode); }
/// <summary> /// This method deletes a Vendor record /// <returns>The return value from the stored procedure.</returns> public int DeleteAll(DBOFactoryTransaction objTransaction) { GetResultsDataSetDelegate objGetResultsMethod = null; FillCommandParamsDelegate objFillParamsMethod = null; QueryController objQueryController = new QueryController(null, $"DELETE {Table}", objFillParamsMethod, objGetResultsMethod); int intReturnCode = PerformQuery(objQueryController, "GetByName", null); return(intReturnCode); }
/// <summary> /// This method deletes a Vendor record /// <returns>The return value from the stored procedure.</returns> public DataObjects.ImageFileInfoList GetMultiples(DBOFactoryTransaction objTransaction) { GetResultsDataSetDelegate objGetResultsMethod = new GetResultsDataSetDelegate(GetSelectResultsDataSet); FillCommandParamsDelegate objFillParamsMethod = new FillCommandParamsDelegate(delegate(SqlCommand objSQLCommand) { objSQLCommand.Parameters.AddWithValue("@IsMoved", IsMoved); }); QueryController objQueryController = new QueryController(null, $"SELECT {AllColumnsString} FROM {Table} WHERE FileName IN ( SELECT FileName FROM {Table} GROUP BY FileName HAVING COUNT(1) > 1 ) AND IsMoved = @IsMoved", objFillParamsMethod, objGetResultsMethod); int intReturnCode = PerformQuery(objQueryController, "GetSingledtons", null); DataObjects.ImageFileInfoList objectList = GetObjectListFromDataset(this.ResultDataSet); return(objectList); }
/// <summary> /// This method deletes a Vendor record /// <returns>The return value from the stored procedure.</returns> public DataObjects.ImageFileInfo GetByName(DBOFactoryTransaction objTransaction) { GetResultsDataSetDelegate objGetResultsMethod = new GetResultsDataSetDelegate(GetSelectResultsDataSet); FillCommandParamsDelegate objFillParamsMethod = new FillCommandParamsDelegate(delegate(SqlCommand objSQLCommand) { objSQLCommand.Parameters.AddWithValue("@FileFullPath", FileFullPath); }); QueryController objQueryController = new QueryController(null, $"SELECT {AllColumnsString} FROM {Table} WHERE FileFullPath = @FileFullPath", objFillParamsMethod, objGetResultsMethod); int intReturnCode = PerformQuery(objQueryController, "GetByName", null); DataObjects.ImageFileInfoList objectList = GetObjectListFromDataset(this.ResultDataSet); this.ResultDataSet = null; return(objectList.FirstOrDefault()); }
/// <summary> /// This static method ... /// </summary> /// <returns></returns> public static int DeleteAll(string objConn, DBOFactoryTransaction objTran) { SQL_ImageFileInfo imageFileInfo = new SQL_ImageFileInfo(new DataObjects.ImageFileInfo(), objConn); return(imageFileInfo.DeleteAll(objTran)); }
/// <summary> /// This static method ... /// </summary> /// <returns></returns> public static DataObjects.ImageFileInfoList GetMultiples(bool isMoved, string objConn, DBOFactoryTransaction objTran) { SQL_ImageFileInfo imageFileInfo = new SQL_ImageFileInfo(new DataObjects.ImageFileInfo() { IsMoved = isMoved }, objConn); return(imageFileInfo.GetMultiples(objTran)); }
/// <summary> /// This static method ... /// </summary> /// <returns></returns> public static DataObjects.ImageFileInfo GetByName(string fullPath, string objConn, DBOFactoryTransaction objTran) { SQL_ImageFileInfo imageFileInfo = new SQL_ImageFileInfo(new DataObjects.ImageFileInfo() { FileFullPath = fullPath }, objConn); return(imageFileInfo.GetByName(objTran)); }