public async Task <int> Department_Delete(int?DepartmentID, byte[] RowVersion_Original, OutputParameter <int> returnValue = null)
{
var parameterDepartmentID = new SqlParameter
{
ParameterName = "DepartmentID",
Value = DepartmentID ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Int,
};
var parameterRowVersion_Original = new SqlParameter
{
ParameterName = "RowVersion_Original",
Value = RowVersion_Original ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Timestamp,
};
var parameterreturnValue = new SqlParameter
{
ParameterName = "returnValue",
Direction = System.Data.ParameterDirection.Output,
SqlDbType = System.Data.SqlDbType.Int,
};
var _ = await _context.Database.ExecuteSqlRawAsync("EXEC @returnValue = [dbo].[Department_Delete] @DepartmentID, @RowVersion_Original", parameterDepartmentID, parameterRowVersion_Original, parameterreturnValue);
returnValue?.SetValue(parameterreturnValue.Value);
return(_);
}
public async Task <Department_UpdateResult[]> Department_Update(int?DepartmentID, string Name, decimal?Budget, DateTime?StartDate, int?InstructorID, byte[] RowVersion_Original, OutputParameter <int> returnValue = null)
{
var parameterDepartmentID = new SqlParameter
{
ParameterName = "DepartmentID",
Value = DepartmentID ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Int,
};
var parameterName = new SqlParameter
{
ParameterName = "Name",
Size = 100,
Value = Name ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.NVarChar,
};
var parameterBudget = new SqlParameter
{
ParameterName = "Budget",
Value = Budget ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Money,
};
var parameterStartDate = new SqlParameter
{
ParameterName = "StartDate",
Value = StartDate ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.DateTime,
};
var parameterInstructorID = new SqlParameter
{
ParameterName = "InstructorID",
Value = InstructorID ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Int,
};
var parameterRowVersion_Original = new SqlParameter
{
ParameterName = "RowVersion_Original",
Value = RowVersion_Original ?? Convert.DBNull,
SqlDbType = System.Data.SqlDbType.Timestamp,
};
var parameterreturnValue = new SqlParameter
{
ParameterName = "returnValue",
Direction = System.Data.ParameterDirection.Output,
SqlDbType = System.Data.SqlDbType.Int,
};
var _ = await _context.SqlQuery <Department_UpdateResult>("EXEC @returnValue = [dbo].[Department_Update] @DepartmentID, @Name, @Budget, @StartDate, @InstructorID, @RowVersion_Original", parameterDepartmentID, parameterName, parameterBudget, parameterStartDate, parameterInstructorID, parameterRowVersion_Original, parameterreturnValue);
returnValue?.SetValue(parameterreturnValue.Value);
return(_);
}